Course Resources Archive
CT4007: Systems Analysis And Database Design
Module Title | Systems Analysis And Database Design |
---|---|
Module Code | CT4007 |
Module Tutor | Julie Paterson |
School | Computing and Technology |
CAT Points | 30 |
Level of Study | 4 |
Pre-requisites | None |
Co-requisites | None |
Restrictions | Cannot be counted with module IT120 |
Brief Description | This module introduces systems analysis and database design. Students learn how to identify business requirements and turn these rapidly into database systems. Students will be introduced to the requirements of being a Computing Professional. |
Indicative Syllabus | The database is central to all information systems. Database success requires good systems analysis. Students are shown how to analyse business requirements and turn these into database systems. The module introduces the theories behind systems analysis and database design, and gives the student much hands-on experience in these fields. Systems analysis subjects include: requirements analysis; process modelling; devising business options; estimating system costs; and data modelling and normalisation. Database subjects include: relational database theory; how to build reliable and efficient databases; field types; ensuring data quality; and importing and exporting data. Students are shown how to use computer-based systems analysis tools and database development tools. Students will study and investigate business scenarios for their coursework throughout the module. |
Learning Outcomes | A student passing this module should be able to:
|
Learning and Teaching Activities | Scheduled Contact Hours: 72 Independent Learning Hours: 228 |
Assessment (For further details see the Module Guide) | 001: 30% Coursework: Group work, standard, written: 1250 words or equivalent 002: 20% Coursework: Individual, standard written: 750 words or equivalent 003: 50% Coursework: Individual, standard written: 2000 words or equivalent |
Special Assessment Requirements | |
Indicative Resources | The Library Catalogue contains full details of the current reading list for this module. Further details may also be found in the Module Guide. |