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 process improvement, What is Process improvement? Understanding...

What is Process improvement? Understanding existing processes and introducing process changes to improve product quality, decrease costs or accelerate schedules. Most proces

Connectivity Issue in Asp.net, Sir, our project is not connecting with SQL ...

Sir, our project is not connecting with SQL server. How to insert own created database in ASP.net

What is the use of a data flow diagram, Q. What is the use of a data flow d...

Q. What is the use of a data flow diagram? Explain the important concepts of data flow diagram. Ans. A data flow diagram is utilized to show the functional view of an applica

Flow chart, desidn a complete flow chart diagram ,which ask the user to inp...

desidn a complete flow chart diagram ,which ask the user to input the rate of diesel and quantity of diesel consumed.after calculate the total amount of diesel consumed and display

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

Software Engineering environments, 1.1 Discuss possible ramifications of th...

1.1 Discuss possible ramifications of these opposing objectives on the project. What would you do if you were the manager?

Legacy Challenge, What is the Legacy Challenge in Software Engineering?

What is the Legacy Challenge in Software Engineering?

Data dictionary, What is data dictionary entry explain

What is data dictionary entry explain

What are the objectives of analysis modelling, What are the objectives of A...

What are the objectives of Analysis modelling? i. To explain what the customer requires. ii. To establish a basis for the creation of software design. iii. To devise a se

SAD Design Phase, describe normalization & its forms? plz i m very thankful...

describe normalization & its forms? plz i m very thankful.......

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