ECE311 Database Systems I

Introduction to Database Management Systems (DBMS). Architecture of a DBMS. Data modeling with the Entity-Relationship model. Relational model. Transformation of the Entity-Relationship model to the Relational model. Relational algebra and relational calculus. SQL Language (data definition and manipulation). Introductory use of a Data Base Management System. Functional dependencies and Normalization. Design of a database. Physical organization of a DBMS. Storage media. File organizations and indexes.

Through this course, a student is expected to:

• Understand of the role and architecture of Database systems
• Acquire knowledge and skills on modeling and designing Databases
• Acquire knowledge and skills on programming Databases
• Introduction to the physical organization of Databases
• Acquire experience of installing, programming and managing of a Data Base Management System