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

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

What is requirement elicitation methods, Q. What is requirement elicitation...

Q. What is requirement elicitation methods? Subsequent to receiving the problem statement from the customer the first step is to arrange a meeting with the customer. During the

Frame diagrams, We discussed the importance of framing a problem in order t...

We discussed the importance of framing a problem in order to understand the problem better and be able to develop a solution more quickly and easily. In this homework, you are ask

What is a user manual, What is A user manual? Ans) A "user manual" is a ...

What is A user manual? Ans) A "user manual" is a document that presents information essential to employ software or a system to get the desired results. Typically, what is expla

Explain object oriented software development, Question: (a) Briefly ex...

Question: (a) Briefly explain the following concepts: (i) Encapsulation and its advantages (ii) Abstract class and its use (iii) Polymorphism and its advantages (b)

Explain the bath tub curve of hardware reliability, Q. Explain the bath tub...

Q. Explain the bath tub curve of hardware reliability? Ans: As indicated in the diagram below there are three phasing in the life of whichever hardware component that is burn

State the software maintenance, What is software maintenance Alters to...

What is software maintenance Alters to the software are made in response to altered requirements but the fundamental structure of the software remains same.

What are quality plans, What are Quality plans? Quality plan structure ...

What are Quality plans? Quality plan structure Product plans; Product introduction; Process descriptions; Quality goals; Risks and risk management.

What is test scenario, The terms "test scenario" and "test case" are certai...

The terms "test scenario" and "test case" are certain used synonymously. Test scenarios are test cases or test scripts, and the series in which they are to be implemented. Test sce

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

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