First-cut entity relationship, Software Engineering

Assignment Help:

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'.


Related Discussions:- First-cut entity relationship

What is software life cycle, Software life cycle starts when a software pro...

Software life cycle starts when a software product is first conceived and ends when it is no longer in use. It contains aspects such as initial concept, requirements analysis, inte

Explain structural things using conceptual model, Question: Part of the...

Question: Part of the conceptual model of UML is made up of four "things": "Structural things", Behavioral things", "Grouping things" and "Annotational things". Explain, using

Draw a data flow diagram using srd technique, Consider a program that regis...

Consider a program that registers students for different programs. The students fill up a form and submit it. This is sent to the departments for confirmation. Once it is confirmed

What is review, What is Review? Ans) A method or meeting during which a ...

What is Review? Ans) A method or meeting during which a work product or set of work products, is shown to project personnel, managers, users, customers, or other interested part

What is quality assurance (qa), (1)The planned systematic activities essent...

(1)The planned systematic activities essential to make sure that a component, module, or system conforms to established technical requirements. (2) All actions that are taken to

Path & Path Production, Path & Path Production, Syntax testing, Computer En...

Path & Path Production, Syntax testing, Computer Engineering Take the following flow graph and use the procedure in chapter 8 to derive an equivalent regular expression. Show all i

Software Quality Assurance - Defect Amplification and Remova, Errors from p...

Errors from previous stage Errors passed through Amplified errors Newly generated errors Errors passed to next stage Testing phase of project-A 35 35 0 5 20 Testing phase of Projec

Differentiate between application and system software, Question: (a) Di...

Question: (a) Differentiate between application software and system software. (b) Mr. Smith would like to know which type of computer is more appropriate to process the inf

Given titles IOT/ IOE, Dear Sir/ Madam I have an 8 page essay to be written...

Dear Sir/ Madam I have an 8 page essay to be written how much I pay per page? Thanks

What are repositories used by qtp to store object properties, What are repo...

What are repositories used by QTP to store object properties? QTP uses two kinds of repositories to store object properties. a.) Shared object repository: A global object

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd