| Credits | 7 |
| Student Learning hours | 70 |
| Content Revised | pre 1996 |
| Prescription Expiry Date | Nov 2007 |
| Topics | Highest Skill Level | Suggested Assessment Percentage | |
| 1 Database Performance Issues | P | 20 | |
| 2 Case Study | P | 80 | |
| 100 | |||
| 1 | Database Performance Issues |
| C | 1.1 | Identify factors affecting the performance of a database environment. |
| P | 1.2 | Given a logical and physical design take recovery, restart, audit and security controls information into consideration and modify the schema design accordingly. |
| P | 1.3 | Modify a database design on performance considerations, with particular emphasis on response-critical transactions. |
| 2 | Case Study |
| P | Given comprehensive information and statement of requirements from a realistic business situation: | |
| -design a complete database structure | ||
| -select a technically appropriate and cost-effective DBMS | ||
| -implement the database and load it with sample data | ||
| -examine its performance and tune the database to optimise transaction performance | ||
| -identify and resolve security issues applicable to this database |