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

Instructor information :

• Title:Assistant Lecturer
• Name: Mohamed Mahmoud Hasan Hamada
• Office hours:1-Hours


• Title:Lecturer
• Name: Mohamed Attia Mohamed
• Office hours:5-Hours


• Title:Teaching Assistant
• Name: Maha Farghaly Ali Ahmed
• Office hours:3-Hours

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.

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.

NAQAAABET

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 :

• Telephone: 16383 (16FUE)
• E-mail: [email protected]