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 reasons behind to perform white box testing, What are the reas...

What are the reasons behind to perform white box testing? There are three main reasons behind performing the white box testing.  1. Programmers may have some incorrect assum

Explain the activities of software maintenance, The activities of software ...

The activities of software maintenance Software maintenance is a broad activity that contains error correction, increasing of capabilities, deletion of obsolete capabilities an

Mention some of the design principles, Mention some of the Design principle...

Mention some of the Design principles. The design process should not vary from tunnel vision. The design should not reinvent the wheel. The Design should exhibit unifo

Explain communicational cohesion, Communicational cohesion : Communicationa...

Communicational cohesion : Communicational cohesion is when parts of a module are grouped because they operate on the similar data (e.g. a module which operates on the similar reco

Advantages of incremental model, Advantages of incremental Model:- ...

Advantages of incremental Model:- As product is to be delivered in parts, total cost of the project is dispersed. Limited number of persons can be put on to the projec

Explain throw-away prototyping, Throw-away prototyping Objective: ...

Throw-away prototyping Objective: The principal objective of this model is to validate or to derive the system requirements. It is developed to reduce requir

How print statements used in software testing, Q. How Print statements used...

Q. How Print statements used in Software testing? Print statements:-The standard print statement in the language being utilized is sprinkled throughout the program to output va

Write down the concept of functional independence, Write down the concept o...

Write down the concept of Functional independence.  a. Functional independence is gained by developing modules with "single minded" function and an "aversion" to extreme intera

Illustrate about the software process technology, Illustrate about the  SO...

Illustrate about the  SOFTWARE PROCESS TECHNOLOGY   Software industry considers software development like a process. According to Rumbaugh and Booch, "A process defines who is

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