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 about token count - software metrics, Q. Explain about token count ...

Q. Explain about token count - software metrics? Token count :- A program is considered to be series of tokens and if we count the number of tokens, some interesting results m

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

Describe various types of cohesion, Describe various types of Cohesion? ...

Describe various types of Cohesion? i. Coincidentally cohesive -The modules in which the set I\of tasks are linked with each other loosely then these modules are called coincid

Describe design walk throughs and critical design review, Q. Describe desig...

Q. Describe design walk throughs and critical design review? Ans. A design walkthrough is a excellence practice that allows designers to acquire an early validation of desig

Product engineering- concept, Product engineering is a system engineering ...

Product engineering is a system engineering approach which starts with system analysis. The system engineer identifies  the customer's requirement, determines economic and econ

Determine the repeatable level of maturity model, Level 2 (Repeatable) ...

Level 2 (Repeatable) Organisation satisfies all the requirements of level-1. At this stage, basic project management policies and associated procedures are established. Insti

State the advantages of prototyping, State the Advantages of Prototyping ...

State the Advantages of Prototyping Advantages of prototyping outperform problems of prototyping. Hence overall, it's a beneficial approach to develop prototype. End user can'

What is oo integration testing, This strategy includes testing the classes ...

This strategy includes testing the classes as they are integrated into the system. The traditional approach would test every operation separately as they are executed into a class.

Software Metircs, I have a comprehensive question in this course need to so...

I have a comprehensive question in this course need to solve

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