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 advantages of vertical partitioning, What are the advantages o...

What are the advantages of vertical partitioning? i. These are simple to maintain changes. ii. They decrease the change impact and error propagation.

What is project scheduling, Question 1 What is project management? Explain...

Question 1 What is project management? Explain various activities involved in project management Question 2 Describe the following with respect to Estimation and Budgeting of

What is meaning of attributes, Attributes   Attribute is a characteri...

Attributes   Attribute is a characteristic or property of an entity which is of interest to the organisation. It's represented by oval shaped box with name of attribute writt

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

Whta is boundary value analysis, Boundary Value Analysis:    It's widely ex...

Boundary Value Analysis:    It's widely examined that input values at the extreme ends of input domain cause more errors in system. More application errors happen at the boundaries

Illustrate the concept of hybrid design, Q. Illustrate the concept of Hybri...

Q. Illustrate the concept of Hybrid design? Hybrid design: Pure top-down or else pure bottom up approaches are often not practical so hybrid approach which combines the above

Name the functionality which wasn''t listed in requirements, What do you do...

What do you do if you have provided functionality which wasn't listed in requirements? - If functionality isn't necessary to purpose of the application, it must be removed.

Two software characteristics, Discuss any two software characteristics. ...

Discuss any two software characteristics. Software is not manufactured : The life of software is from method exploration to the retirement of the software product. It is one t

SQA Planning, I want to know that what are the activities, roles,artifacts ...

I want to know that what are the activities, roles,artifacts and goals do a planning phase of SQE encempass? How can we prepare sqa plan for any project?

When must you stop testing, When must you stop testing? It is very diff...

When must you stop testing? It is very difficult to determine as many modern software applications are complex and run in such an interdependent environment that complete testi

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