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, What is Software? Software is nothing but a collectio...

What is Software? Software is nothing but a collection of computer programs that are related documents that are indented to give desired features, functionalities and improved

Activity and use case diagram, The Application You should develop your p...

The Application You should develop your program using incremental development. Develop your program a little bit at a time and keep testing it. Save a working version before mak

Define software design, Define Software design. Software design is a...

Define Software design. Software design is an iterative process by requirements are translated into a "blue print" for constructing the software. The blue print dep

Explain in detail about black box testing, Explain in detail about Black bo...

Explain in detail about Black box testing. Black box or behavioural testing focuses on the functional needs of the software. It is applied during the last stage of testing.

What is architectural transformation, What is architectural transformation?...

What is architectural transformation? This is a more radical approach to software change then maintenance as it involves making significant changes to the architecture of the s

What are the important points to do software design, What are the important...

What are the important points to do software design The below points must be kept in mind when performing the design:  i) Practicality: This ensures that system is stable

What is process and product quality, What is Process and product quality? ...

What is Process and product quality? The quality of a developed product is influenced by the quality of the production process. This is significant in software development

Stat352-13a - minitab analyses, TASK A: Minitab analyses for Case Study tas...

TASK A: Minitab analyses for Case Study task 3 (robustness for the filler flap design; TASK3.MTW) Describe an 8-run 2-level fractional factorial experiment to check the robustne

Short note on class, Class A class is a template that states the proper...

Class A class is a template that states the properties of objects. Classes have an interface which having of the operation, a body which executes the operations and instance va

Network Technology, How can you create a file named -i? Which techniques do...

How can you create a file named -i? Which techniques do not work, and why do they not work? How can you remove the file named -i?

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