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 characteristics of software measurement, What are the characte...

What are the characteristics of software measurement? Measured property Object of measurement Source of measure Purpose measurement Context of measurement.

Ms project, what is meant by gantt chart who gave the name who is the found...

what is meant by gantt chart who gave the name who is the founder

Define process maturity, Define process maturity. In recent years there...

Define process maturity. In recent years there has been a important emphasis on process maturity. The Software Engineering Institute. (SEI) has developed a comprehensive model

Determine the business process engineering tools, What are business process...

What are business process engineering tools? By modelling the strategic information requirements of an organization, business process engineering tools provide a "meta-model" f

What is operational testing, Testing conducted to consider a system or comp...

Testing conducted to consider a system or component in its operational environment. Contrast with development, testing,; testing, acceptance;

Describe the various types of coupling, Describe the various types of coupl...

Describe the various types of coupling? i. Data coupling - The data coupling is possible by parameter passing or data interaction. ii. Control coupling - The modules share c

Define the product metrics, Q. Define the Product metrics? (i) Product ...

Q. Define the Product metrics? (i) Product metrics: Explains the characteristics of the product such as complexity, size, design features, performance, efficiency, reliability,

Explain acceptance testing, Testing conducted to verify whether or not a sy...

Testing conducted to verify whether or not a system satisfies its acceptance criteria and to enable the customer to verify whether or not to accept the system. Contrast with testin

Answer, write a decision table that specifies the rules for the game of che...

write a decision table that specifies the rules for the game of checkers

What do you understand by user-centred design, Problem: (a) What do yo...

Problem: (a) What do you understand by user-centred design and why is it important? (b) Explain how Prototyping and the Participatory Design approach are useful to the d

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