|
On successful completion of the module, students should be able to:
-
Explain the characteristics that distinguish the database approach from the traditional approach of programming with data files
-
Identify major DBMS functions and describe their role in a database system
-
Prepare a relational schema from a conceptual model developed using the entity- relationship model
-
Explain and demonstrate the concepts of entity integrity constraint and referential integrity constraint (including definition of the concept of a foreign key)
-
Demonstrate use of the relational algebra operations from mathematical set theory (union, intersection, difference, and Cartesian product) and the relational algebra operations developed specifically for relational databases (select (restrict), project, join, and division)
-
Demonstrate queries in the relational algebra
-
Use a declarative query language to elicit information from a database
|