Future University In Egypt (FUE)
Future University is one of most promising private universities in Egypt. Through excellence in teaching, research and service, Future University strives to provide a comprehensive, high-quality education that prepares our graduates to be future leaders.
mainLogo
90th Street
New Cairo
Egypt

Course List

Database System-1

  • Course Code :
    IS211
  • Level :
    Undergraduate
  • Course Hours :
    3.00 Hours
  • Department :
    Faculty of Computers & Information Technology

Instructor information :

Area of Study :

Introduce basic concepts of database systems. Learn how to design, construct and manage databases. Illustrate different components of a database management system Present the database development process Develop the relational data model Use Structured Query Language (SQL) Gain hands-on experience to understand the concepts and techniques for designing and implementing forms, queries, reports and using a popular database management system (DBMS) and object-oriented programming language. Use effectively communication skills.

For further information :

Database System-1

The main objective of this course is to provide students with the background to design, implement, and use database management systems. Topics Include: Basic concepts, database system environment, DBMS components and architecture, database design process, high-level data models, ER and EER models, the relational data model, relational languages, SQL, Data Definition Language (DDL), Data Manipulation Language (DML), introduction to functional dependencies and normalization, social and ethical context of databases.

For further information :

Database System-1

Course outcomes:

a. Knowledge and Understanding:

1- Explain the specifications and components of Database systems.
2- Comprehend the functionalities of Database management systems.
3- Explain the relational data model.
4- Explain the relational algebra as a formal language to manipulate relational data.
5- Comprehend data modeling and database designing.
6- Discuss the correspondence between Relational algebra and SQL.

b. Intellectual Skills:

1- Convert data models.
2- Formulate relational algebra expressions/SQL statements.
3- Express real-world environment in data models (database design skills).
4- Discover Entity Relationship Model to design databases.
5- Convert ER Models to relational models.
6- Normalize Database Tables.
7- Construct SQL language to define and manipulate relational databases.

c. Professional and Practical Skills:

1- Form and use Structured Query Language (SQL) in database construction anddata manipulation.
2- Hand on some well-known database management systems.
3- Design database using specific software.
4- Form design and implement database.
5- Report on design and implement database.

d. General and Transferable Skills:

1- Enhance work presentation skills.
2- Develop problem solving skills.
3- Demonstrate communication skills.
4- Work coherently and successfully as a part of a team.
5- Enhance data and information retrieval skills

For further information :

Database System-1

Course topics and contents:

Topic No. of hours Lecture Tutorial/Practical
Introduction to database systems 4 2 2
File processing and database systems 4 2 2
Database system components and characteristics 4 2 2
Relational data Model 4 2 2
Relational Algebra and an introduction to SQL 4 2 2
The Entity Relationship Model 4 2 2
Data modelling and database designing 4 2 2
Data modelling and database designing 4 2 2
Mid Term Exam 2
Converting ER model to relational model 4 2 2
Converting ER model to relational model 4 2 2
Database tables and normalization 4 2 2
Database Administration 4 2 2
Final Exam 2

For further information :

Database System-1

Teaching And Learning Methodologies:

Teaching and learning methods
Interactive Lectures including Discussions
Practical Lab Sessions
Case Studies
Brain Storming and Problem Solving

For further information :

Database System-1

Course Assessment :

Methods of assessment Relative weight % Week No. Assess What
Assignments 5.00 2
Practical Exam 10.00 12
Presentations 5.00 10
Quizzes 5.00 5
Team Work Projects 5.00 11
Written Final Exam 40.00 14
Written Midterm Exam (s) 30.00 9

For further information :

Database System-1

Books:

Book Author Publisher
Fundamentals of Database Systems Ramez Elmasri / Shamkant Navathe Pearson

Course notes :

An Electronic form of the Course Notes and all the slides of the Lectures is available on the Students Learning Management System (Moodle)

Recommended books :

• Connolly & Begg “ Database Systems, A practical approach to • Design, implementation, and management”, Pearson, last edition. • ISBN-13: 978-0133970777 ISBN-10: 0133970779

Web Sites :

www.ekb.eg

For further information :

Follow us on

Visit the Faculty

ADS