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 black box testing, Define Black box testing Black box testing ...

Define Black box testing Black box testing Black-box test design care for the system as a "black-box", so it doesn't explicitly use knowledge of the internal structure. It ta

What is maintenance, Define maintenance. Maintenance is defined as the ...

Define maintenance. Maintenance is defined as the procedure in which changes are executed by either modifying the existing system's architecture or by adding new mechanism to t

List the guidelines for data design, List the guidelines for data design. ...

List the guidelines for data design. i. Apply systematic analysis on data. ii. Identify data structures and related operations. iii. Establish data dictionary. iv. Use

State in brief about evolutionary prototyping, Explain Evolutionary prototy...

Explain Evolutionary prototyping Objective: The principal objective of this model is to deliver the working system to the end-user. Example-AI systems. Advant

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

XML, Ask Create an XML file with markup tags and some sample data to repres...

Ask Create an XML file with markup tags and some sample data to represent a list of invoices.

What are the problems of prototyping, What are the Problems of Prototyping ...

What are the Problems of Prototyping  In some organisations, theprototyping isn't as successful as anticipated. A common problem with this approach is that people expect much

What is sdlc , Explain  SDLC ? Ans) SDLC-( software development life cyc...

Explain  SDLC ? Ans) SDLC-( software development life cycle) is an acronym.

Illustrate partitioning in stepwise refinement, Q. Illustrate Partitioning ...

Q. Illustrate Partitioning in stepwise refinement? Problems are frequently too large and complex to be understood as a whole. Therefore we tend to partition such problems into

FTR., Formal technical review in railway reservation system

Formal technical review in railway reservation system

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