258 - Database Management Systems

Fundamentals of Database Systems
by ( Elmasri / Navathe, Latest Edition )

Instructor : Husain Gholoom
Office Hours: to be announced
Computer Lab:
- Sun. 12:00 - 2:00
- Mon. 10:00 - 12:00
- Tue. 12:00 - 2:00
- Wed. 10:00 - 12:00

COURSE OBJECTIVES :

Upon completion of this course, participants will have gained knowledge of database system concepts and the ability to:
  • Understand user requirements/views.
  • Analyze existing and future data processing needs.
  • Develop an enterprise data model that reflects the organization's fundamental business rules.
  • Develop and refine the conceptual data model, including all entities, relationships, attributes, and business rules integrate and merge database views into conceptual model.
  • Dpply normalization techniques.
  • Identify data integrity and security requirements.
  • Derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements
  • Utilize prototyping as a rapid application development (RAD) method to implement a PC database (e.g.,MySql for the PC).

Course Outline