Database Theory and Design

5.0 Credits
Designed to recognize data as a business resource. Database models are discussed from both a developer’s and a user’s viewpoint. Topics include: Conceptual and logical models, and data normalization through case studies

Course-level Learning Objectives(CLOs)
Upon successful completion of this course, students will be able to:

1. Describe fundamental principals of database theory and design.
2. Research and analyze business data requirements.
3. Identify high-level business rules for data modeling.
4. Document high-level business rules for data modeling.
5. Create and refine conceptual and logical data models.
6. Validate conceptual and logical data models.
7. Select unique identifiers and normalize the data model.
8. Understand the role of SQL in the business and database contexts.
9. Recognize the basic components and issues of database application design.