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

Determine the steps of structured requirements definition, Determine the di...

Determine the different steps of Structured Requirements Definition Step 1: Make a user level data flow diagram. This step is meant for gathering requirements with intera

What does modularity concept mean, What does Modularity concept mean? S...

What does Modularity concept mean? Software architecture embodies modularity; ie, Software is named in to addressable components called as modules that are integrated finally.

What is ripple effect, Q. What is ripple effect? How does it affect the sta...

Q. What is ripple effect? How does it affect the stability of a program? Ans. The ripple effect is a term used to explain a situation where like the ever expanding ripples

What is software risk, A measure of the severity and probability of undesir...

A measure of the severity and probability of undesired effects. Often taken as the easy product of probability and consequence.

What are the properties of srs, What are the properties of SRS? i. Corr...

What are the properties of SRS? i. Correct - The SRS must be built up to date while  appropriate requirements are identified. ii. Unambiguous - When the requirements are pro

Draw a flowchart for pay no tax, A town comprise 5000 houses. Every house o...

A town comprise 5000 houses. Every house owner should pay tax based on the value of house. Houses over $200 000 pay 2% of their value in tax, houses over $100 000 pay 1.5% of their

What are quality reviews, What are Quality reviews? This is the princip...

What are Quality reviews? This is the principal method of validating the quality of a process or of a product. A group examines part or all of a process or system and its do

Software metrices, 1. Take a look at the code and try to understand the lo...

1. Take a look at the code and try to understand the logic, particularly, the way scrambled words are disambiguated, i.e.., whether they are matched successfully against a correct

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