- Student Records
Programme & Unit Catalogues


LP10382: Introduction to database development

Follow this link for further information on academic years Academic Year: 2012/3
Further information on owning departmentsOwning Department/School: Department of Computer Science (administered by the Learning Partnerships Office)
Further information on credits Credits: 6
Further information on unit levels Level: Certificate (FHEQ level 4)
Further information on teaching periods Period: Semester 2 at City of Bath College
Semester 2 at Weston College
Semester 2 at Wiltshire College
Further information on unit assessment Assessment: CW 100%
Further information on supplementary assessment Supplementary Assessment: Like-for-like reassessment (where allowed by programme regulations)
Further information on requisites Requisites:
Further information on descriptions 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.
Further information on programme availabilityProgramme availability:

LP10382 is Optional on the following programmes:

Programmes administered by the Learning Partnerships Office
  • USCM-DFF23 : FdSc Applied Computing (Full-time at City of Bath College) - Year 1
  • USCM-DPF23 : FdSc Applied Computing (Part-time at City of Bath College) - Year 2
  • USCM-LFF22 : FdSc Applied Computing (Full-time at Weston College) - Year 1
  • USCM-LPF22 : FdSc Applied Computing (Part-time at Weston College) - Year 2
  • USCM-WFF23 : FdSc Applied Computing (Full-time at Wiltshire College) - Year 1
  • USCM-WPF22 : FdSc Applied Computing (Part-time at Wiltshire College) - Year 2

Notes:
* This unit catalogue is applicable for the 2012/13 academic year only. Students continuing their studies into 2013/14 and beyond should not assume that this unit will be available in future years in the format displayed here for 2012/13.
* Programmes and units are subject to change at any time, in accordance with normal University procedures.
* Availability of units will be subject to constraints such as staff availability, minimum and maximum group sizes, and timetabling factors as well as a student's ability to meet any pre-requisite rules.