| Title | Database and Information Management |
| Code | SCPS232 |
| Prerequisites | SCPS111 | Co-requisites | None |
| Aim | - The aim of this course is to provide an introduction to databases and information
management
|
| Content | - Introduction to databases and Relational databases,
- Database Design: techniques and models, conceptual design, logical design and normalization.
- relational algebra and calculus, and SQL concurrency control.
|
| Outcomes | On completion of this module the learner should be able to: - demonstrate an understanding of basic concepts of database systems.
- demonstrate an understanding of the basics of SQL, construct queries using
SQL, and be able to write relational algebra expressions for queries. - use sound design principles to perform logical design of databases, including
the E‐R method and normalization approach. - demonstrate familiarity with the basic issues of transaction processing and
concurrency control.
|
| Assessment | 40% Continuous Assessment (comprising 20% practical assessment plus 20% theory assessments) 60% Summative Assessment (comprising 4 hour practical and theory exam) |
| DP Requirements | 40% Continuous Assessment Mark, 80% Attendance at practical’s |
