Course Outcomes:
The following highlighted course outcomes tie into module outcomes:
- Compare and contrast the basic database models;
- Analyze, design, develop and implement a relational database system based on business requirements;
- Create, modify and query databases using the SQL language;
- Analyze the major aspects of database administration and compare and contrast issues of database security;
- Describe XML and its use in database systems;
- Conduct independent research on a subject related to the course material.
Module 12 outcomes:
- Explain what is concurrency control
- Explain transaction recovery
- Identify the various steps of a transaction lifecycle as well as the DBMS components involved and the role of the logfile
- Explain the importance of locking and locking protocols
- Discern different types of failures and how to deal with them
Assessment:
This module will have a discussion.
Outcome/Assessment |
Outcome 1 |
Outcome 2 |
Outcome 3 |
Outcome 4 |
|
Read Content |
introduced |
introduced |
introduced |
introduced |
|
Read slides |
reinforced |
reinforced |
reinforced |
reinforced |
|
read links |
reinforced |
reinforced |
reinforced |
reinforced |
|
complete discussion |
reinforced |
reinforced |
reinforced |
reinforced |
|