Draw an entity relationship diagram, Software Engineering

Assignment Help:

Problem:

(a) Draw an Entity Relationship Diagram for the given case study. Show entities and relationships on the diagram (attributes should not be shown). Cardinality and optionality of relationships should be shown.

(b) The attribute ‘Mileage at last servicing' of the entity E2 Vehicle is not captured in the given system of events. Make the necessary amendment to the event model to correct this anomaly.

(c) The field ‘Total Value of Spare parts used in servicing' was introduced to track expenditure incurred in servicing of vehicles. Is this field a redundancy? Is it justified?

(d) It was also noted that in order to record all costs incurred in the maintenance of a vehicle, it would be necessary to record cost of labour and also the cost of repairs outside normal scheduled servicing tasks. Modify the given event model and the data model to meet this requirement.


Related Discussions:- Draw an entity relationship diagram

What is coupling, What is Coupling? Coupling is the measure of interconn...

What is Coupling? Coupling is the measure of interconnection among modules in a program structure. It depends on the interface complexity among modules.

What are the fundamental activities of a software process, What are the fun...

What are the fundamental activities of a software process? Specification Validation Design and implementation Evolution

What is meant by system requirements, What is meant by System Requirements ...

What is meant by System Requirements Set out the system constraints and services in well explained. Serves as a contract among the system buyer & the system developer.

Explain process, Explain Process? The work effort that makes a product. ...

Explain Process? The work effort that makes a product. This contains efforts of people and equipment guided by policies, standards, and procedures.

What are the properties of the software, What are the properties of the sof...

What are the properties of the software? Software is engineered, not manufactured. Software is free of wear out. Most software is built as required rather than being asse

Advantages and disadvantages of business intelligence, 1) Case A...

1) Case Analysis (maximum of 6 pages per case, double spaced) The following format may be used as a guideline for Case Analysis: Key Issues Identified in Case Sta

What are assumptions of the execution-time component model, Q. What are the...

Q. What are the assumptions of the execution-time component model? Compare the execution-time component for basic model and the logarithmic Poisson model. Ans. The execution-

Explain acceptance testing and beta testing, Explain acceptance testing and...

Explain acceptance testing and beta testing.  Acceptance Testing and Beta testing : System tests are designed to validate a fully developed system to make sure that it meets

3809ICT, I need help on and assignment that is due on monday can you help ?...

I need help on and assignment that is due on monday can you help ?

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