Learning Outcomes

1. Understand data models and database technologies
2. Be able to design and implement relational database systems
3. Be able to use manipulation and querying tools
4. Be able to test and document relational database systems.

Assessments

1. Example 30th Mar 2017 Assessment A17.1: Database Systems
2. Example 16th Mar 2017 Assessment A17.2: Database Design
3. Example 20th Jun 2017 Assessment A33.1: Database Queries
4. Example 16th May 2017 Assessment A42.2: .NET Program
5. Example 20th Jun 2017 Assessment A42.3: .NET Testing

Assessment Criteria

1. Understand data models and database technologies
   1. critically compare different data models and schemas
   2. critically discuss the benefits and limitations of different database technologies
   3. analyse different approaches to database design
2. Be able to design and implement relational database systems
   1. design a relational database system to meet a given requirement
   2. build a relational database system based on a prepared design
   3. apply a range of database tools and techniques to enhance the user interface
3. Be able to use manipulation and querying tools
   1. explain the benefits of using manipulation and query tools in a relational database system
   2. implement a query language into the relational database system
   3. identify and implement opportunities for error handling and reporting
   4. critically evaluate how meaningful data has been extracted through the use of query tools
4. Be able to test and document relational database systems
   1. critically review and test a relational database system
   2. create documentation to support the implementation and testing of a relational database system
   3. create user documentation for a developed relational database system
   4. explain how verification and validation has been addressed
   5. explain how control mechanisms have been used

Session Index

• Course Index
• Unit Overview