This course introduce the fundamentals of database management system characteristics of DB approach, components of DB systems, DB architecture, Data modeling, Database users and administrators. Entity-Relationship model, Relational-Algebra, SQL Programming, Database design, Functional dependency and Normalization, Relational Database, Introduction to Object oriented database and UML, practical applications using a standard Relational DB system.
Intended learning outcomes
Knowledge &understand
The student remembers the database and the database management system and lists the uses of the database.
The student learns how to analyze the requirements to access the database using the ERD relational model.
The student draws these analyzed requirements through the use of Chen symbols in the ERD relational model.
The student converts these symbols into database properties, relationships, and tables.
The student learns how to analyze the requirements to access the database using normalization (simplification).
The student decomposes these requirements into properties using functional dependencies.
The student converts these properties into database tables using the four normalization formulas 0NF, 1NF, 2NF, and 3NF.
The student learns about relational algebra and how to deal with data in database tables theoretically.
mental skills
The student proposes a set of requirements.
The student analyzes requirements using Chen symbols in the relational model.
The student infers a set of properties, relationships, and tables.
The student analyzes the requirements using functional dependencies in the slightest normalization.
The student derives a set of properties, relationships, and tables using the four normalization formulas.
The student compares the relational model method with the normalization formulas.
Practical & professional skills
The student distinguishes the requirements through forms, reports, statements and texts.
The student uses the requirements to extract properties, relationships and tables in one of the two ways (relational model - normalization formulas).
The student should design a correct database.
The student performs a set of theoretical operations on the data inside the tables using relational algebra
General and transferable skills
The student is able to solve problems related to database design.
The student is able to use Chen symbols or normalization formulas in design.
The student is able to use any other symbols such as UML in the design.
The student is able to team work in designing a database.
The student is able to manage time when using one of the two design methods.
The student is able to communicate with institutions wishing to design a database for them.
Teaching and learning methods
Lectures
Tutorials
Solve some models
Labs
Methods of assessments
Midterm1 exam = 25
Midterm2 exam = 25
Practical exam = 15
Final exam = 35
Course contents
Database System
Database Structure
Data Models
Structure Of The Relational Model, Relational Keys, And Integration Constraints
Interpretation Of The Entity-Relationship Diagram, Pluralism, Participation And Origin Constraints
Entity, Property, And Relationships In An ERD Diagram - 1:1 Relationship And 1:N Relationship
Entity, Property, And Relationships In An ERD Diagram - The N:M Relationship And The Circular Relationship
Converting The Chart Using The Ten Conversion Rules - Part 1
Schema Transformation Using The 10 Transformation Rules - Part Two
Functional Dependency In Normalization
Determine The Primary Key Using Functional Dependencies
