Back to courses index

ITBP340: Database Systems

Description:The objective of this course is to give a thorough introduction to the concepts for organizing, querying and managing databases. This course introduces the concepts relating to information systems in organizational usage, focusing on the analysis and modelling of data. It covers the fundamentals of databases, the process of database design, including data modelling in particular with the Entity Relationship Model, and the relational data model. Students will gain a sound practical understanding of the SQL relational database query language. They will also develop deep technical knowledge in a relational DBMS and a sense of professionalism and team work discipline.
Credit Hours.:3
Text Book: Fundamentals of Database Systems, 5/E (2006), Ramez A. Elmasri, Shamkant B. Navathe, Pearson; ISBN 0-321-41506-X
Coordinator: Elarbi Badidi
Topics Outline:
  1. Databases and Database Users
  2. Database System Concepts and Architecture
  3. Data Modelling Using the Entity-Relationship Model
  4. Enhanced Entity-Relationship and Object Modelling
  5. The Relational Data Model, Relational Constraints, and the Relational Algebra
  6. Mapping an ER/EER to the Relational Model
  7. SQL: The Relational Database Standard
  8. Functional Dependencies and Normalization for Relational Databases
Outcomes:
  1. Describe the main concepts of a database system.
  2. Compare a database system approach to a file-based system approach.
  3. Design a database using the entity-relationship diagram (ERD).
  4. Use Relational Algebra to perform various operations on relations.
  5. Apply normalization to database tables.
  6. Create and query a database.
Mapping of Topics Outline to Outcomes
 1 2 3 4 5 6 7 8
1       
2       
3      
4        
5        
6      
Pre-requisiteITBP319: Data Structures
Co-requisite ITBP321: Web Application Development Lab
Volume of the Course that Contributes to CIT Students Outcomes(SOs)
Move the mouse over the Students Outcome number to view the Students Outcome text
a b c d e f g h i j k l m n
4% 11% 6% 11% 4% 8%2% 4% 2% 8% 8% 11% 8% 6%
Show Details