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

30 60 90 TRIANGLES, Find the length of the hypotenuse. With a short side of...

Find the length of the hypotenuse. With a short side of radical 3 and a long side with 3 radical 2 Simplify the radical if you can.

Layered software architecture, iii. Layered software architectures can be ...

iii. Layered software architectures can be used to reduce coupling between the functions of a system that are closer to the machine and those that are closer to user needs. Why is

What is meant by information flow continuity, What is meant by Information ...

What is meant by Information flow Continuity? When we refine a fundamental model for a system, the information flow continuity must be maintained .ie, input & output to every r

Mention some of the drawbacks of rad model, Mention some of the drawbacks o...

Mention some of the drawbacks of RAD model. Not suitable for largescale projects. Commitment of developers & customers are required. Not appropriate when technical ris

What is boundary value testing, A testing technique using input values at, ...

A testing technique using input values at, just below, and just above, the definite limits of an input domain; and with input values causing outputs to be at, just below, and just

What are the different architectures developed during bpe, What are the dif...

What are the different architectures developed during BPE? Data architecture framework for the information requires of a business. Application architecture incorporates the

Show the advantages of incremental model, Q. Show the Advantages of increme...

Q. Show the Advantages of incremental Model? As product is to be conveying in parts total cost of the project is distributed. Limited number of persons is able to be pu

Give the overview of application software, Question 1 Give the classificat...

Question 1 Give the classification of computers and explain them briefly Question 2 Give the overview of application software Question 3 Explain the three main types of

What are the levels of testing, What are the two levels of testing? i. ...

What are the two levels of testing? i. Component testing Individual components are tested. Tests are produced from developer's experience. ii. System Testing The group

What is black box testing, Write short note on black box testing. The b...

Write short note on black box testing. The black box testing is also known as behavioural testing. This process fully focuses on the functional requirements of the software. Te

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