Introduction to Data Management
CIT 21400/ 3 Cr.
Introduction to basic database development concepts. Extensive exploration of data manipulation using a relational DBMS and SQL. Students develop database applications using the most current database technologies.
- Available Online: Yes
- Credit by Exam: Yes
- Laptop Required: Yes
Prerequisites/Co-requisites:
CIT 12000
Software
- Microsoft Access
- mySQL
Outcomes
Course Outcomes (What are these?)
- Understand basic data management concepts (CIT 1)
- Understand the structure and methods of the relational data model (CIT 1)
- Create and manipulate relational databases using DBMS and SQL (CIT 1,2)
- Model logical data requirements using entity-oriented techniques (CIT 1,2)
- Transform a logical data model into a relational database structure (CIT 1)
- Apply normalization techniques to a database (CIT 1)
- Understand the functions of a DBMS and database administration (CIT 1)
CIT Student Outcomes (What are these?)
- (1) Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions.
- (2) Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline.
Topics
- Database Management Concepts
- Database Design
- Query by Example
- Structured Query Language (SQL)
Principles of Undergraduate Learning (PULs)
1b. Identify and propose solutions for problems using quantitative tools and reasoning.
1c. Make effective use of information resources and technology.
2. Critical Thinking
3. Integration and Application of Knowledge
4. Intellectual Depth, Breadth, and Adaptiveness