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
CIT 12000 and (MATH 15400 or MATH 15900)
- Microsoft Access
Course Outcomes (What are these?)
- Understand basic data management concepts (CIT a, i, j)
- Understand the structure and methods of the relational data model (CIT i, j)
- Create and manipulate relational databases using QBE and SQL (CIT a, c)
- Model logical data requirements using entity-oriented techniques (CIT b, c)
- Transform a logical data model into a relational database structure (CIT b, i, j)
- Apply normalization techniques to a database (CIT i, j)
- Understand the functions of a DBMS and database administration (CIT a, i, j)
CIT Student Outcomes (What are these?)
(a) An ability to apply knowledge of computing and mathematics appropriate to the program’s student outcomes and to the discipline.
(b) An ability to analyze a problem, and identify and define the computing requirements appropriate to its solution.
(c) An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.
(i) An ability to use current techniques, skills, and tools necessary for computing practice.
(j) An ability to use and apply current technical concepts and practices in the core information technologies.
- 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