Course description 

This course covers basic concepts behind database systems. It presents methodology for conceptual, logical, and physical database design for relational systems and its language (Structured Query Language). The course also examines distributed database management systems and object-oriented database management system 

Objective of the course

Upon successful completion of the course, the student is expected to be able to:

a. Describe the basic principles of the relational model of data. In which it includes modeling concepts, notations, operations, and how relations can be declared in a database system.

b. Learn how to manipulate relations and specify queries using SQL.

c. Delve into an important technique used in logical database design methodology using Entity Relationship and Enhanced Entity Relationship models.

d. Demonstrate how to transform a design from one normal form to another form and be able to show the advantages of having a logical database design that conforms to a particular normal form.

e. Apply step-by-step methodology for conceptual database design, logical database design, and physical database design for relational systems.

f. Know locking mechanisms for controlling the concurrency and also knowing the execution of different types of transactions and their schedules.

g. Employ proper technique on how users can access the database at their own site and also access data stored at remote sites.