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

Define cardinality and modality, Define Cardinality & Modality. Cardina...

Define Cardinality & Modality. Cardinality: Requirement of the number of occurrences of one that can be linked to number of occurrences of another. Modality: The Modality of

Define the load address for the first word of the program, Define the Load ...

Define the Load address for the first word of the program is known as Load address origin is called as a Load address for the first word of the program

The majority charge carriers in p-type semiconductor, The majority charge c...

The majority charge carriers in p-type semiconductor are?? The majority charge carriers are  holes.

Determine the software testing, What is software testing The testing pr...

What is software testing The testing process focuses on the logical internals of the software, ensuring that all statements have been tested, and on the functional externals, t

What is closed box testing, Closed box testing is similar as black box test...

Closed box testing is similar as black box testing. Black box testing a type of testing that examine only externally visible behavior.

Explain special value testing, Special Value Testing: It is the form of fu...

Special Value Testing: It is the form of functional testing. Special value testing happens when a tester uses his or her domain knowledge, experience with same program and informa

What are the various testing activities, What are the various testing activ...

What are the various testing activities? i. Test planning ii. Test execution iii. Test case design iv. Data collection v. Effective evaluation

What do you mean by reverse engineering, Q. What do you mean by REVERSE ENG...

Q. What do you mean by REVERSE ENGINEERING? REVERSE ENGINEERING:-It is a process of analyzing software with a outlook to understanding its design and specification. In t

What are the aims of analysis modelling, What are the aims of Analysis mode...

What are the aims of Analysis modelling? i. To make apparent what the customer wants. ii. To set up a basis for the creation of software design. iii. To devise a set of v

How is software design different from coding, How is software design differ...

How is software design different from coding ? Points of difference among software design and coding can be laid down as under:  Design : 1. Design is most vital and t

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