Learning Partnerships, Unit Catalogue 2010/11 |
AS10343: Introduction to database development |
 Credits:
| 5 |
| Level:
| Certificate |
| Period: | This unit is available in... |
| Semester 2 at City of Bath College | |
| Semester 2 at Weston College | |
| Semester 2 at Wiltshire College, Chippenham |
| 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. |