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

State the categories of software maintenance, Categories of software mainte...

Categories of software maintenance There are three categories of maintenance:  i) Corrective Maintenance ii) Adaptive Maintenance iii) Perfective Maintenance

Dfd, explain dfd

explain dfd

What are basic key process areas in cmm, Q. What are basic Key process area...

Q. What are basic Key process areas in CMM? Ans) Key Process Areas (KPAs) adds the areas an organization could focus to improve its software process to the next level. Except f

Determine the meaning of vertical partitioning, Determine the meaning of ve...

Determine the meaning of vertical partitioning? Vertical partitioning often called factoring suggests that the control and work should be distributed top-down in program struct

Stats free, system architecture block diagram

system architecture block diagram

Define capability, Define capability. What are the quantities that determin...

Define capability. What are the quantities that determine the degree of capability of a software reliability model? Capability refers to the ability of the model to calculate w

Describe the various types of restructuring techniques, Describe the variou...

Describe the various types of restructuring techniques. (a) Code Restructuring: It is performed to yield a design that produces the similar function but with higher quality t

Demonstrate the symbol used in data dictionary, Demonstrate the symbol used...

Demonstrate the symbol used in data dictionary A number of the symbols used in data dictionary are as following: X= [a/b]                                   x comprises eithe

How to compute the cyclomatic complexity, How to compute the cyclomatic com...

How to compute the cyclomatic complexity? The cyclomatic complexity can be calculated by any one of the following ways. 1. The numbers of regions of the flow graph correspon

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