- Course Code
- CS 2008
- Credit Points
- 15
- Course Coordinator
- Dr N Beacham
Pre-requisites
None.
Co-requisites
None.
Notes
(i) Assistive technologies may be required for any student who is unable to use a standard keyboard/mouse/computer monitor. Any students wishing to discuss this further should contact the School Disability Co-ordinator.
Overview
The concepts of a database and database management. Database development. Illustrations. Entity-Relationship model. Database design: logical design and the relational model. Normalisation; different normal forms. Physical design; file organisation and access; indexing. Database administration. Query by Example and SQL. Query optimisation. Practical examples using MS Access.
Client-server model. Database servers. Database access from client applications. Web-based database access through server-side scripting. Practical examples using MS Access, My SQL, Php and JDBC.
A brief overview of key concepts in distributed, object -oriented, multimedia, spatial and geo-referenced database systems.
Structure
Four hours per week: 2 one-hour lectures, 1 two-hour practical.
Assessment
1st Attempt: 1 two-hour written examination (75%); continuous assessment (25%). In order to pass this course, candidates must obtain a pass mark in the examination and in the overal combination of examination and continuous assessment.
Resit: 1 two-hour written examination (75%); continuous assessment mark carried forwards (25%). In order to pass this course, candidates must obtain a pass mark in the examination and in the overal combination of examination and continuous assessment.
Formative Assessment
During lectures, student interaction will be used for formative assessment. Additionally, practical sessions will provide students with practice opportunities and formative assessment.
Feedback
Formative feedback for in-course assessments will be provided in written form. Additionally, formative feedback on performance will be provided informally during practical sessions.