|
|
 |
Information and Communications
Technology Qualifications
| Back to list of Prescriptions
| Prescription: DB700 (DB300)Database Management Systems (DBMS) |
| Credits | 7
|
| Student Learning hours | 70
|
| Content Revised | pre 1996
|
| Prescription Expiry Date | Nov 2005
|
The Student Will
| | | | 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.
|
top
| | | | 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
|
top
|
|
