Advanced Database Design

CIT 44400/ 3 Cr.

This course addresses enterprise data management and logical database design concepts with an emphasis on needs determination and data modeling skills from an organizational perspective. Students will create data models and apply forward and reverse engineering techniques and will work through the full life cycle of the development of a software application.  A project-based learning approach is used in this course.

• Available Online: No
• Credit by Exam: No
• Laptop Required: No

Prerequisites/Co-requisites:

P: CIT 30400 and CIT 300-level programming course (CIT 31300, 34700, or 38800)

Software

ERwin Data Modeler

Outcomes

Course Outcomes (What are these?)

• Identify the major functions of data management. (CIT a)
• Describe data modeling concepts, terminology, and best practices. (CIT a, m)
• Design conceptual, logical, and physical data models for an enterprise. (CIT c)
• Use a professional data modeling tool for forward and reverse engineering. (CIT i)
• Understand the importance of needs determination and business requirements in the context of database design. (CIT m)
• Evaluate different data modeling standards and industry approaches. (CIT k)
• Contrast Entity-Relationship modeling with dimensional data modeling. (CIT i)
• Understand the challenges of enterprise data models and data management. (CIT 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.

(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.

(k) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems.

(m) An understanding of best practices and standards and their application.

Topics

• Data Management Framework
• Conceptual Data Modeling
• Logical Database Design
• Physical Database Design
• Managing the Data Modeling Process
• Enterprise Data Models and Data Management