Faculty of Engineering - Ain Shams University, Home

Home  >  Faculty of Engineering - Ain Shams University, Home

Database Systems Design

What Will Learn?

  • Course Aims
    By the end of the course the students will be able to: • Provide the student with an understanding of what is meant by Database systems and Database Management Systems • Teach the student how to design database with different techniques • Provide the student with an understanding of entity-relationship diagrams and relational database. • Teach the student how to use SQL language to create and manipulate database systems. • Train the student to share ideas and work in a team effectively and independently. • Perform laboratory experiments to measure understanding of theoretical principal.
  • Course Goals
  • Decent Work and Economic Growth
  • Industry, Innovation and Infrastructure
  • Sustainable Cities and Communities

Requirements

CSE243

Description

  • English Description

    Introduction to database systems. Database design theory and methodology. Entity/Relationship model (ERM) and enhanced Entity/Relationship model (EERM). Functional dependency and normalization for relational database. Relational model: Domain, Relations, Relational integrity. SQL. The relational database language standard: Data definition language, Data manipulation language, Aggregate functions, Views, Database modification, Database Management System (DMS).
  • Arabic Description

    Introduction to database systems. Database design theory and methodology. Entity/Relationship model (ERM) and enhanced Entity/Relationship model (EERM). Functional dependency and normalization for relational database. Relational model: Domain, Relations, Relational integrity. SQL. The relational database language standard: Data definition language, Data manipulation language, Aggregate functions, Views, Database modification, Database Management System (DMS).
  • Department
    Computer and Systems Engineering
  • Credit Hours
    3
  • Grades
    Total ( 100 ) = Midterm (20) + tr.Major Assessment (25 = tr.Industry 0% , tr.Project 15% , tr.Self_learning 0% , tr.Seminar 15% ) + tr.Minor Assessment (5) + tr.Oral/Practical (10) + Exam Grade (40)
  • Hours
    Lecture Hours: 2, Tutorial Hours: 2, Lab Hours: 1
  • Required SWL
    125
  • Equivalent ECTS
    5
  • - Fundamentals of database systems ( 7th edition, 2016) By Ramez Elmasri, Shamkant B. Navathe.
  • - Database System Concepts - 7th edition -By Avi Silberschatz, 2015.
  • - Lab sheets. - Fundamentals of database systems ( 7th edition, 2016) By Ramez Elmasri, Shamkant B. Navathe.