Advance Database I

College of Engineering & Computer Science

Department of Information Technology

Course Overview:

This course introduces database design and creation. Emphasis is on Database users, E-R Diagram, data integrity, Keys and Functional Dependency. Upon completion, students should be able to design and implement normalized database structures by creating simple database tables, queries, reports, and forms

Aims & Objective:

  • To understand the basic concept of database system.
  • To study the physical and logical database designs, database modelling, relational, hierarchical, and network models.
  • To understand and use data manipulation language to query, update, and manage a database.
  • To develop an understanding of essential DBMS concepts such as: database security, integrity, concurrency.
  • To design and build a simple database system and demonstrate competence with the fundamental tasks involved with modelling, designing, and implementing a DBMS.
  • Duration: 15 week
  • Lectures: 14
  • Language: English
  • Hours per Week: 4
Stage: Third Year
Semester: First Semester
Course Type: Coursat
Credit: 3
Code: IT3I
Attendance: 5%
Class Tests and Quizzes: 10%
Midterm Examination: 25%
Practical Exam: 10%
Final Examination: 50%
Passed Grade
50