Compare A Database System Approach To A File-Based System Approach.

Database Systems (CSBP340)

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, and in particular the Entity Relationship. Students will gain a sound practical understanding of the SQL relational query language. They will also develop deep technical knowledge in a relational DBMS and a sense of professionalism and team work discipline.

Learning Outcomes

At the end of the course, students will be able to :

1. Apply Normalization To Database Tables.
2. Compare A Database System Approach To A File-Based System Approach.
3. Describe The Main Concepts Of A Database System.
4. Design A Database Using The Entity-Relationship Diagram (Erd).
5. Function Effectively As A Team To Create And Query A Database.
6. Use Relational Algebra To Perform Various Operations On Relations.