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 throw-away prototyping, Throw-away prototyping Objective: ...

Throw-away prototyping Objective: The principal objective of this model is to validate or to derive the system requirements. It is developed to reduce requir

What are quality management activities, What are Quality management activit...

What are Quality management activities. Quality assurance Establish organisational process and standards for quality. Quality planning Select applicab

Illustrate key process areas of cmm, Q. Illustrate key process areas of CMM...

Q. Illustrate key process areas of CMM? The key process areas of CMM are 1. Requirements management that establishes a common relationship between the customer and developer

Pl sql, The company wants to offer an incentive of free shipping to those c...

The company wants to offer an incentive of free shipping to those customers who have not returned for two months. Create a procedure named PROMO_SHIP_SP that determines who these c

What are the virtues of incremental model, What are the virtues of incremen...

What are the virtues of incremental model? i. The incremental model can be adopted when there are less number of persons associated with the project. ii. Technical risks can

Aggregation between objects, Aggregation between objects Aggregation am...

Aggregation between objects Aggregation among objects shows a relationship. It is a whole/part relationship. Aggregation might be implying containment.

Explain the difference between latent and masked defect, Explain the differ...

Explain the difference between Latent and Masked Defect. Latent Defect is one which has been in the system for a long time; but is discovered now. I.e. A defect which has been

Explain rad model, RAD Model Rapid Application Development Model is...

RAD Model Rapid Application Development Model is the part of incremental model. Achieves the high speed development using component based construction. Phases

What does verification represent, What does Verification represent? Ver...

What does Verification represent? Verification shows the set of activities that are carried out to confirm that the software correctly executes the specific functionality.

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