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 a user friendly document, What is a user friendly document? Ans)...

What is a user friendly document? Ans) A document is user friendly, when it is designed and written with simple of use, as single of the primary objectives of its design.

Analyses the system design process of a project, Write a report which criti...

Write a report which critically analyses the system design process of a project. Projects might include designing a light rail network for a city, more environmentally-conscious bu

What are the various categories of software, What are the various categorie...

What are the various categories of software? Application software System software Engineering/Scientific software Web Applications Embedded software Artificial I

Mobile help dack mangmant system, hello there!! I have above subject that I...

hello there!! I have above subject that I have final project and also I required with program

Static single variable model and static multivariable model, Q. Static sing...

Q. Static single variable model and static multivariable model? Static single variable model : Methods using this model utilize an equation to estimate the desired value such

Describe the various types of restructuring techniques, Q.  Describe the v...

Q.  Describe the various types of restructuring techniques? Ans. Software restructuring modifies source code as well as data an effort to make it amenable to future changes

C++, how to save image of a dialog box by using c++

how to save image of a dialog box by using c++

Dfd, online admision application

online admision application

Explain the limitations of testing, Q. Explain the limitations of testing? ...

Q. Explain the limitations of testing? Ans: Though testing is an significant part of system development and leads to a verified, valid and efficient system it as well faces s

Library housekeeping software, Library Housekeeping Software: The mark...

Library Housekeeping Software: The market is flooded with a variety of packages specially designed to support library housekeeping operations such as acquisitions, cataloguing

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