M457 Database computer project

Level: 3        Credit points: 30


This course is for students who have passed the M357 Data Models & Databases course and would like to build on that work to complete a computer project. The project is defined and enables you to demonstrate your ability to present a written report based on your technical work and your management of a computer project. A pass may give you exemption from the British Computer Society Part I project.


This project course, based on the Open University course M357 Data Models & Databases, is designed to:

Give you an opportunity to present a well structured written account both of the processes of applying appropriate techniques and methods, and of the findings from the study.

Give you experience of planning and scheduling a project.

Provide an opportunity to apply concepts and skills you have already learnt to a large computing task.

Encourage reflection on the processes of carrying out such a piece of work.

You will have just one project to work on. Its topic is specified by the course team and will be based on the academic content of M357 Data Models & Databases. Any additions to the content of the course will be minimal and will be included as part of the project specification.

For this project you will be given a description of a sub-system of a real situation, such as part of the system for a record shop or a holiday company. For the first piece of written work you will be asked to produce a conceptual data model (an EAR model) with full definitions and descriptions of the components. You will then work on a revised conceptual model, in the light of comment from your tutor, and on a list of all the functional dependencies and a relational schema. Both these pieces of work are to be presented as small reports, to give you practice before you submit your project work. Finally, you will make a full report that includes the conceptual data model, the logical schema design, the SQL schema, queries and recorded data with implementation and testing.