First-cut entity relationship, Software Engineering

A University has asked you to design and implement a simple database to store student and module details (including details of which school students belong to and which schools run which module), upon student enrolment. Students are enrolled as a member of a school (e.g. School of Mathematics and Computer Science), whilst also being enrolled onto a number of modules, student contact details are also required. The modules a student may be enrolled onto are run by schools (e.g. Introduction to Information Systems is run by the School of Mathematics and Computer Science), with students limited to modules that are run by the school that they belong to. While designing and implementing the database system (following the steps below), you should apply common sense and make any necessary minor administrative decisions. You work report is to document your work in carrying out the following steps, and include sufficient information about the system implemented (as well as its design) that it can be understood without difficulty.

1. Produce a first-cut Entity Relationship (ER) Diagram for the system.

2. Carry out the Relational Data Analysis procedure from the "Structured System Analysis and Design" (PDF file). Include details for each normal form, and the resulting ER Diagram.

3. Compare your ER Diagrams from steps 1 and 2. Comment on any differences and make any changes you consider necessary to produce a final ER Diagram. Should there be no differences, instead discuss what differences there could have been.

4. Following the example from the (PDF file) on databases use your ER Diagram to produce a Relational Database Schema, and include in your report each table complete with a small set of realistic but imaginary sample data: between five and fifteen records per table.

5. Implement your database in Microsoft Office Access, complete with this sample data. Remember to use appropriate data types and to implement necessary relationships.

6. Design, and implement in Microsoft Office Access, forms for the entry of data into the database. Include screenshots of sample forms as an appendix in your report.

7. Design, and implement in Microsoft Office Access 2003, a report that summarizes the number of students on each module. Include a sample report (output) as an appendix in your report.

8. Conclude your work report with a section that evaluates the strengths and weaknesses of the system, how it could be improved and what you would do differently 'next time'.

Posted Date: 3/6/2013 1:46:12 AM | Location : United States







Related Discussions:- First-cut entity relationship, Assignment Help, Ask Question on First-cut entity relationship, Get Answer, Expert's Help, First-cut entity relationship Discussions

Write discussion on First-cut entity relationship
Your posts are moderated
Related Questions
The Clue-Less system shall operate with the following Web browsers: Microsoft Internet Explorer, Mozilla Firefox, Google Chrome, and Safari. OE-2: The Clue-Less system shall

Advantage of microcomputer software packages: i)  compilation and maintenance of reference and fact files;  ii)  compilation of current and retrospective bibliographies

Advantages of incremental Model:- As product is to be delivered in parts, total cost of the project is dispersed. Limited number of persons can be put on to the projec

Describe Equivalence Partitioning Ans) Input data of a program is separated into different categories so that test cases can be developed for every category of input data. The g

Cloud computing is becoming an unrelenting force that is driving competition in the ERP industry and can no longer be ignored by legacy systems, such as Oracle and SAP. Larry Ellis

What is Desk Checking? Ans) A type of manual static analysis usually performed by the originator. Source code documentation, etc., is visually checked against needs and standard

Define Traceability Traceability is the overall property of requirements specification which reflects the easiness of finding related requirements. Three different parts

Write down any four application of a stack. (i)  Conversion of infix to postfix form (ii)  Reversing of a line. (iii) Removal of recursion (iv) Evaluating post fix expression

Question: a) Briefly describe the principles of the DSDM methodology. b) What are the advantages of using the DSDM methodology? c) The MOSCOW technique is used to priori

Question 1 V-Model and Spiral Model, Waterfall Model are of the software development processes. Companies are using these models to have a systematic and defined approach in softw