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

Hotel reservation, how to make pseudo code of hotel reservation

how to make pseudo code of hotel reservation

Explain inputs, Products, services, or information required from suppliers ...

Products, services, or information required from suppliers to make a process work.

DAO java, inside a button click can we put following code... Account a = n...

inside a button click can we put following code... Account a = new Account(); a.setAccNo(Integer.parseInt(txtAccNo.getText())); a.setDepositamt(Float.parseFloat(tx

What quality would you look for when hiring a test engineer, What qualities...

What qualities would you look for when hiring a test engineer? - Test to break attitude - Desire for quality and attention to details. - Tact and diplomacy when dealing w

Explain software testing, Define software testing? Software testing is ...

Define software testing? Software testing is a critical element of software quality assurance and shows the ultimate review of design, specification, and coding.

Explain stress testing, Testing conducted to classify a system or component...

Testing conducted to classify a system or component at or beyond the limits of its described requirements.

What is delphi model, What is Delphi model? In Delphi method, a number ...

What is Delphi model? In Delphi method, a number of parameters to be considered based on as experts estimates. The group estimate is taken as on  an average of the weighted

Draw a memory map for a system, Draw a memory map for a system with a memor...

Draw a memory map for a system with a memory capacity of 256MB. Each memory location in the system is 8 bits. Assume the system has one 4 MB memory block used as ROM residing at th

State the software measure, What is software measure? A software measu...

What is software measure? A software measure is a mapping from a set of objects in the software engineering world information a set of mathematical construct like numbers or v

Explain sci, What is SCI? Software Configuration Item is information th...

What is SCI? Software Configuration Item is information that is carried as part of the software engineering process.

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