الأهداف
Upon successful completion of this subject students should be able to:
- Explain the main issues related to the design and use of structured data.
- Construct conceptual and logical data models applying database design principles.
- Evaluate data redundancy levels and their impact on database integrity and maintainability.
- Construct conceptual data models applying data modeling principles.
- Construct logical data models adhering to data normalization principles.
- Distinguish between good and bad database design
- Construct efficient SQL queries to retrieve and manipulate data as required.
الخطوط العريضة
- The Role of Databases in Information Systems
- The Relational Data Model
- SQL: simple queries, aggregate functions, data modification statements, simple joins, complex joins, sub queries and set operators
- Conceptual database design (ER modeling)
- Logical design: ER conversion to a relational model
- Normalization