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

Software requirments, #questionFrame Diagrams We discussed the importance o...

#questionFrame Diagrams 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 thi

Expert Systems, Explain model-based expert systems and frame-based expert s...

Explain model-based expert systems and frame-based expert systems

What is coverage analysis, What is Coverage analysis? Determining and as...

What is Coverage analysis? Determining and assessing calculated associated with the invocation of program structural elements to verify the adequacy of a test run. Coverage anal

Draw an appropriate use-case model, This case-study describes the requireme...

This case-study describes the requirements of an airline travel agency who want to develop a website to allow customers to make online bookings. The outline requirements are descri

The worker pool multi-threading architecture, QUESTION (a) Compare the ...

QUESTION (a) Compare the worker pool multi-threading architecture with the thread-per-request architecture. (b) What thread operations are the most significant in cost? (

State lehman first law, State Lehman's First law A program that is used...

State Lehman's First law A program that is used in real world environment of necessity must change or become progressively less useful in that environment.

What is the objective of regression testing, The aim of regression testing ...

The aim of regression testing is to test that the fixes have not formed any other problems elsewhere. The aim is to ensure the software has remained intact. A baseline set of data

Explain token count, Token count: -  A program is considered to be series o...

Token count: -  A program is considered to be series of tokens and if we count the number of tokens, some interesting results might be emerge. Tokens are classified as either opera

What is user friendly software, A computer program is "user friendly", when...

A computer program is "user friendly", when it is designed with simple of use, as one of the primary purposes of its design.

Explain the difference between latent and masked defect, Explain the differ...

Explain the difference between Latent and Masked Defect. Latent Defect is one which has been in the system for a long time; but is discovered now. I.e. A defect which has been

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