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 are the principles of testing, What are the principles of testing ...

What are the principles of testing Below are some of the principles of testing:  i)  All tests must be performed according to user requirements.  ii)  Planning of tests m

Quality control concept, (i) Concept definition of Quality Control and Qual...

(i) Concept definition of Quality Control and Quality Assurance (ii) Tools used in quality control (iii) Acceptance sampling and process control (iv) Statistical tools for

Explain difference between test plan and master test plan, What is the diff...

What is the difference between Test Plan and Master Test Plan. Master Test Plan - i.) It is mandatory in all projects. ii.) It provides strategy to be used to test the

Explain data accuracy, Data accuracy Don't collect redundant data  T...

Data accuracy Don't collect redundant data  The questions to be answered should be decided in advance and the needed data identified. Tell people why the data is being co

What is variable trace, 1. "Variable trace" is a (computer) record of the n...

1. "Variable trace" is a (computer) record of the names and the values of variables accessed and/or changed during the implementation of a computer program. 2. "Value trace" is

What is test schedule, The test schedule is a schedule that signifies all t...

The test schedule is a schedule that signifies all tasks needed for a successful testing effort, a schedule of all test activities and resource needs.

Explain cyclomatic complexity, What is cyclomatic complexity? Cyclomati...

What is cyclomatic complexity? Cyclomatic complexity is software metric that gives the quantitative measure of logical complexity of the program. The Cyclomatic complexity e

What is stepwise refinement, Q. What is stepwise refinement? Stepwise R...

Q. What is stepwise refinement? Stepwise Refinement:-Stepwise Refinement is a top-down design strategy initially proposed by Niklaus Wirth. A program is developed by consecutiv

What is bottom-up strategy, Bottom-up approach, as the name suggests, is th...

Bottom-up approach, as the name suggests, is the differing of the Top-down method. This process begins with building and testing the low level modules first, working its way up

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