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 acceptance testing, Testing conducted to verify whether or not a sy...

Testing conducted to verify whether or not a system satisfies its acceptance criteria and to enable the customer to verify whether or not to accept the system. Contrast with testin

Automobile mgmt. system, How do i create the automobile management system p...

How do i create the automobile management system project?

What is the use of user interface prototyping, What is the use of User Inte...

What is the use of User Interface prototyping? This prototyping is used to pre-specify the look and feel of user interface in an effective way.

What does the insert statement in extract datasets do, What does the insert...

What does the insert statement in extract datasets do? It describes the fields of a field group.

Structured analysis and structured design, Differentiate between structured...

Differentiate between structured analysis and structured design.  The aim of structured analysis is to transform the textual explanation of a problem into a graphic model. Duri

Write definition of state transition diagram, Write definition of state tra...

Write definition of state transition diagram? State transition diagram is mainly a collection of states and events. Due to the events the system has to change its state. It als

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

Explain the software life cycle model, Q. Explain the software life cycle m...

Q. Explain the software life cycle model that incorporates risk factor. Ans. The problem with traditional software process models is that they don't deal sufficiently with th

Explain equivalent size measure software metrics, Q. Explain Equivalent siz...

Q. Explain Equivalent size measure software metrics? Equivalent size measure:- Models makes no distinction between a new software and the portion being reused. The equivalent

What are version management tools, What are Version management tools? ...

What are Version management tools? Version and release identification Systems assign identifiers automatically when a new version is submitted to the system. St

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