F3038

Database System

DATABASE SYSTEM course offers a comprehensive coverage of databases and the various operations of data manipulation. This course covers how to design and develop normalized databases and manipulate data using Structured Query Language (SQL).
:: [ Click Here for Course Outline ] ::

LEARNING OUTCOMES
1. Describe the characteristics of database system.
2. Design the entity-relationship model for representing and designing databases.
3. Apply normalization techniques to design a database.
4. Discover the security issues, concurrency and recovery in database.
5. Create database using basic Structure Query Language.


ASSESSMENTS
a. Quiz – minimum 7 [15%]
b. Assignment – minimum 3 [15%]
c. Lab Works – minimum 10 [20%]
d. Tests – Comprising of two (2) Theory tests  [30%]
e. Mini Project – minimum 1 [20%]

GET YOUR NOTES HERE
- Topic 1 : Introduction to Database System :: [ Click Here ] ::
- Topic 2 : Entity Relationship Model :: [ Click Here ] ::
- Topic 3 : Data Relational Model :: [ Click Here ] ::
- Topic 4 : Operational Issues :: [ Click Here ] ::
- Topic 5 : Structured Query Language :: [ Click Here ] ::

LAB exercises
:: [ LAB 1 ] ::