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

Explain exploratory testing, Explain exploratory testing. - In explorat...

Explain exploratory testing. - In exploratory testing approach testers are included in minimum planning and maximum test execution. - The planning contains creation of a tes

The phases of a problem solving loop, Problem solving is a critical skill f...

Problem solving is a critical skill for success in business—in fact it’s often what you are hired and paid to do. This article explains the five problem solving steps and provides

State the advantages of prototyping, State the Advantages of Prototyping ...

State the Advantages of Prototyping Advantages of prototyping outperform problems of prototyping. Hence overall, it's a beneficial approach to develop prototype. End user can'

What is change management tools, What is Change management tools? Chang...

What is Change management tools? Change management is a process in which it can be modelled and integrated with a version management system. Change management tools Fo

Illustrate evolutionary prototyping, Illustrate Evolutionary prototyping ...

Illustrate Evolutionary prototyping Objective: The main objective of this model is to show the working system to the end-user. Example-AI systems. Advantages

State the cocomo model, What is COCOMO model? COCOMO stands for COnstru...

What is COCOMO model? COCOMO stands for COnstructive COst MOdel. It is used for cost Effort=a * KDLOCb Where a and b are two parameters of the model whose specific values

What does data abstraction contains, What does Data abstraction contains? ...

What does Data abstraction contains? A Data abstraction is a named collection of data that defines a data object Eg: door Attributes: door type, Opening mechanism, Swing di

Explain iso 9000 certification, ISO 9000 certification Quality standard...

ISO 9000 certification Quality standards and procedures should be documented in an organisational quality manual. An external body might be certify that an organisation's qu

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