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 what is meant by the term encapsulation, Question: (a)  Explain...

Question: (a)  Explain the difference between a link and an association. Use a simple example to illustrate your answer. (b)  Briefly describe the importance of CRC cards in

Case tools, #question2. Explain any ten CASE tools...

#question2. Explain any ten CASE tools...

Explain test bed, 1) An environment that having the integral hardware, inst...

1) An environment that having the integral hardware, instrumentation, simulators, software tools, and other support elements required to conduct a test of a logically or physically

What are white-box and black-box, What are white-box, black-box and gray-bo...

What are white-box, black-box and gray-box testing? White Box (or glass box) testing is the METHOD of giving i/p to the system and checking how the system processes i/p to prod

What do you mean by the computer based system, What do you mean by  the co...

What do you mean by  the computer based system? The computer based system can be termed as "a set or an arrangement of elements that are managed to accomplish some predefined g

What are the tools of environmental model, What are the Tools of environme...

What are the Tools of environmental  model (i)  Statement of purpose: It indicates basic objectives of system. (ii)  Event list: It describes different events of system

What are command buttons, What are command buttons? How to use command butt...

What are command buttons? How to use command buttons? Command buttons are defines to as controls. The control is capable of implementing a set of instruction when the user clic

What is meant by information flow continuity, What is meant by Information ...

What is meant by Information flow Continuity? When we refine a fundamental model for a system, the information flow continuity must be maintained .ie, input & output to every r

What are the causes behind to perform white box testing, What are the cause...

What are the causes behind to perform white box testing? There are three main reasons behind performing the white box testing. 1. Programmers may have some incorrect assumpt

Draw a class diagram which represents the information, QUESTION Draw a ...

QUESTION Draw a class diagram which represents the information handled by the Online Bakery-equipments Ordering System. Your class should briefly and simply reflect the relatio

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