|
On successful completion of the module, students should be able to:
-
Identify major Database Management Systems (DBMS) functions and describe their role in a database system
-
Design a relational schema from a conceptual model developed using the entity-relationship model
-
Demonstrate the creation of databases from external data sources such as files
-
Explain and demonstrate the concepts of entity integrity constraints and referential integrity constraints
-
Demonstrate queries in relational algebra
-
Use a declarative query language (SQL) to extract information from a database
-
Demonstrate use of SQL to work with many different data types (strings, timestamps, numerical, etc) in large databases
-
Explain the concepts of database security in the context of web-based database applications.
|