- University: Salahaddin University-Erbil
- Department: Software Engineering Dept.
- My Status: Assistant Lecturer
- Level: BSc
- Year: 2009-2012
Course Description
This course is to teach students the concepts of relational database management systems. Concepts covered are tables, relations, joins, and queries. As wel as teaching basic database design principals like Creating ER-diagram and normalization.
Course Objectives
The students should be able to demonstrate the ability to:
- gathering requirements
- Analyze the requirements
- Normalize the database
- Design the database using ER-Diagram
- Creating the database using SQL
- Inserting/updating information into the database
- retrieving information from the database
Course Content
- Introduction to databases
- Entity/Relationship modelling
- The relational model
- Relational algebra
- Relational calculus
- Schema refinement: Functional dependencies
- Schema refinement: Normalization
- Transaction management overview
- Basic SQL, Integrity constraints
Polla Fattah