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

What is peer reviews, What is Peer Reviews? Ans) A methodical examinatio...

What is Peer Reviews? Ans) A methodical examination of software work products by the producer's peers to recognize defects and areas where changes are required.

Advanced software engineering, Is there ever a case when the generic activi...

Is there ever a case when the generic activities of the software engineering process don’t apply?

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 is data binding, What is Data Binding?    The matrix that attempts...

What is Data Binding?    The matrix that attempts to capture the module-level concept of coupling is data binding. Data binding are a calculate that captures the data interacti

Discuss about service oriented architecture, Question : (a) Discuss ab...

Question : (a) Discuss about Service Oriented Architecture (SOA), in terms of key principles, benefits and applicability. Also include examples of applications suitable for

Use cases, 1. Perform a requirements analysis for the Case Study. Express t...

1. Perform a requirements analysis for the Case Study. Express the results using the following artefacts:     a. A use case diagram for the functional requirements of the entire

Explain about data coupling, Q. Explain about Data coupling? The depend...

Q. Explain about Data coupling? The dependency among module A and B is said to be data coupled if their dependency is based on the fact they communicate by merely passing of da

Illustrate functions that dynamic testing tools supports, Q. Illustrate Fun...

Q. Illustrate Functions that dynamic testing tools supports? Functions that dynamic testing tools supports: 1: input setting it is selecting of the test data that the test

Difference between verification and validation, Difference between Verifica...

Difference between Verification and Validation Verification is Static whereas Validation is Dynamic. This means in Verification the s/w is inspected by looking into the code go

What is test scenario, The terms "test scenario" and "test case" are certai...

The terms "test scenario" and "test case" are certain used synonymously. Test scenarios are test cases or test scripts, and the series in which they are to be implemented. Test sce

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