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

Illustrate intermediate COCOMO model, Q.Illustrate Intermediate COCOMO mode...

Q.Illustrate Intermediate COCOMO model ? The intermediate COCOMO model approximation the software development effort by using 15 cost drivers' variables besides the size variab

What are the common approaches in debugging, What are the common approaches...

What are the common approaches in debugging? Brute force method: The memory dumps and run-time tracks are examined and program with write statements is loaded to obtain clues t

Define the failure intensity of the basic model, Q Define the failure inten...

Q Define the failure intensity of the Basic model? Ans: The failure intensity of the Basic model is λ (μ) = λ 0 [1 - μ / v 0 ] Where λ 0 is the initial failure inten

Post-production design feedback for future designs, Q. Post-production desi...

Q. Post-production design feedback for future designs ? Post-production design feedback for future designs Implementation it is introducing the designed solution into

Define effector process, Define effector process? The effector process...

Define effector process? The effector process is termed as a process that verifies itself. The  effector process exists in specific criteria.

Explain different type of testing tools, Q. Explain different type of testi...

Q. Explain different type of testing tools? (a) Test Case Generators: These tools produce test cases from SRS program or test design languages. They utilize certain rules cal

Define cohesion & coupling, Define cohesion & coupling? Give suitable examp...

Define cohesion & coupling? Give suitable examples.  Coupling : Coupling refers to the strength of the relationship among modules in a system. Coupling shows how strongly dif

What is software re-engineering, What is software re-engineering? No fu...

What is software re-engineering? No functionality is added to the system. Rather than, the system is modified to compose it easier to understand and change. System re-engineeri

What is volume testing, Testing designed to challenge a system's capability...

Testing designed to challenge a system's capability to handle the maximum amount of data over a period of time. This type of testing also classify a system's ability to handle over

Infomation systems, How can a company improve quality of business informati...

How can a company improve quality of business information?

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