CSC422 Database Design
Lead Faculty: Dr. Alireza Moztarebi Farahani
Course Description
A survey of principles, structure, analysis, and techniques of database design and implementation. Topics include physical and logical design, normalization, database models, security, and integrity.
Learning Outcomes
- Describe characteristics of entity relationship components and explain how relationships between entities are defined.
- Build ER Model.
- Explain normalization and normal forms.
- Create data models based on EER diagrams.
- Use SQL commands and function for data manipulation and data administration.
- Create views, triggers and stored procedures.
- Describe database design strategies.
- Describe various models used for concurrency control.
- Explain how DBMS process SQL queries.
- Describe distributed database management system and how transactions are managed in a distributed database environment.
