Learning Partnerships, Unit Catalogue 2011/12 |
|
 Credits:
| 5 |
| Level:
| Certificate (FHEQ level 4) |
| Period: |
Semester 2 at City of Bath College Semester 2 at Weston College Semester 2 at Wiltshire College (Chippenham Campus) Semester 2 at Wiltshire College (Salisbury Campus) |
| Assessment:
| CW100 |
| Supplementary Assessment: | Supplementary assessment information not currently available (this will be added shortly) |
| Requisites:
| |
| Description:
| Aims: To equip the student with the necessary knowledge and skills to: * Derive and implement appropriate relational database schemas from a suitable scenario. Learning Outcomes: At the completion of the unit, learners should be able to: * Explain the need for and role of database management systems in providing access to data for users; * Appreciate the 3-layer SPARC model for DBMS; * Design a logical schema for a relational database; * Implement and test external schemas for a relational database. Skills: Practical skills - variety of database and application packages. Data manipulation language facilities of SQL. Taught and assessed. Personal skills - time management, personal organisation, working with others, independent research, problem solving - facilitated. Communication skills - interviewing, written reports - facilitated and assessed. Content: Model a system * Entity analysis and normalisation; derivation of ERDs. Use of appropriate tools. Explain the need for and role of database management systems in providing access to data for users * Problems of traditional file based approaches to data access. DBMS as a layer between the user and the data. Facilities of a DBMS. SQL DML. Appreciate the 3-layer SPARC model for DBMS * Physical, logical and external schemas. Design a logical schema for a relational database * Implementation of entities, attributes, relationships, primary and foreign keys in RDBMS tables Implement and test external schemas for a relational database Construction and testing of "front ends" in a variety of application packages. Client-server architecture. ODBC and other connectivity issues. |
| Programme availability: |
AS10343 is Compulsory on the following programmes:Learning Partnerships
|