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

Write short notes on estimation models, Write short notes on estimation mod...

Write short notes on estimation models. Empirical estimation models can be used to complement decomposition methods and propose a potentially valuable approach in their own rig

Software development plan , Phone Company (WLPC) is a provider of wireless ...

Phone Company (WLPC) is a provider of wireless phone service in the US with 100,000 customers serving mostly small markets. WLPC has just purchased additional airwaves in the US, C

Driven development, what is driven development?give example what benifit of...

what is driven development?give example what benifit of driven development

What is an update task, What is an update task? It is an SAP given proc...

What is an update task? It is an SAP given procedure for updating a database.

Determine the common problems with software automation, Determine the commo...

Determine the common problems with software automation ? The biggest concern is the cost incurred for test automation. Also, often s/w test automation needs skilled personnel an

Explain the brooks law, Define Brooks law. Software was delivered late...

Define Brooks law. Software was delivered late, was defective, cost several times the original estimates and often showed poor performance characteristics.

Explain in detail about the real time systems, Explain in detail about the ...

Explain in detail about the real time systems. Hard and soft real time systems. Real time and high performance. Real-Time control. Real time software design

What is the aim of testing, In well-run projects, the mission of the test t...

In well-run projects, the mission of the test team is not merely to perform testing, but to help decrease the risk of product failure. Testers look for manifest problems in the pro

Illustrate about the waterfall model, Waterfall Model It is the oldest...

Waterfall Model It is the oldest, simplest and most widely used process model. In waterfall model, every phase of the life cycle is finished before start of a new phase. It's

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