Learning Partnerships, Unit Catalogue 2011/12 |
|
 Credits:
| 6 |
| 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 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 an external schemas for a relational database. Skills: Practical skills - variety of database and application packages. Data manipulation language facilities of SQL. (T and F) Personal skills - time management, personal organisation, working with others, independent research, problem solving - (F) facilitated Communication skills - interviewing, written reports - (F and A) facilitated and assessed. Content: Model a system Entity analysis, normalisation; ERDs Requirement and role of database management systems 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: |
AS10382 is Optional on the following programmes:Learning Partnerships
|