كلية الهندسة - جامعة عين شمس, الرئيسية

الرئيسية  >  كلية الهندسة - جامعة عين شمس, الرئيسية

Database Systems

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

CSE331s

Description

  • English Description

    Concepts of database systems. Architecture of a database system. 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). Database design theory and methodology. Entity/relationship model (ERM).
  • Arabic Description

    Concepts of database systems. Architecture of a database system. 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). Database design theory and methodology. Entity/relationship model (ERM).
  • قسم
    هندسة الحاسبات والنظم
  • الساعات المعتمدة
    3
  • الدرجات
    الإجمالي ( 100 ) = نصف العام (20) + tr.Student Activities (20 = tr.Industry 0% , tr.Project 10% , tr.Self_learning 0% , tr.Seminar 10% ) + tr.Oral/Practical (10) + درجة الامتحان (50)
  • الساعات
    ساعات المحاضرة: 2, ساعات التعليم: 2, ساعات المعمل: 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.