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

State the testing and debugging, State the Testing and Debugging Testin...

State the Testing and Debugging Testing is process of verifying if the application matches needs and reporting bugs; Testing is usually done by an independent testing team wher

What is a vertical microinstruction, What is a vertical microinstruction? ...

What is a vertical microinstruction? Ans) A vertical microinstruction is a microinstruction that states one of a sequence of operations required to carry out a machine language

What are the three activities of risk assessment, What are the three activi...

What are the three activities of risk assessment? Ans: The three activities are analyzing, identifying and giving priorities. Risks are able to be identified by a check list

Write the problems with the cmm, Write the Problems with the CMM. Prac...

Write the Problems with the CMM. Practices associated with model levels Companies could be using practices from dissimilar levels at the same time but if all practices

What is iso 9000 certification, What is ISO 9000 certification? Qualit...

What is ISO 9000 certification? Quality standards and procedures should be recognized in an organisational quality manual An external body may confirm that an organisation'

Define software scope, Define software scope. The first software projec...

Define software scope. The first software project management activity is the determination of software scope. Scope is explained answering the following questions. Context:

What is defect analysis, What is Defect Analysis? Ans) Using defects as ...

What is Defect Analysis? Ans) Using defects as data for regularly quality improvement. Defect analysis usually to classify defects into categories and recognize possible causes

Define design process, Define design process. Design process is a sequ...

Define design process. Design process is a sequence of steps carried through which the requirements are translated into a system or software model.

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