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 is data binding, What is Data Binding?    The matrix that attempts...

What is Data Binding?    The matrix that attempts to capture the module-level concept of coupling is data binding. Data binding are a calculate that captures the data interacti

State some guidelines for testing, State some guidelines for testing Th...

State some guidelines for testing The below are some guidelines for testing: i)  Test modules thoroughly, cover all the access paths and produce enough data to cover all the

What are the fundamental activities of a software process, What are the fun...

What are the fundamental activities of a software process? Specification Validation Design and implementation Evolution

Define brooks law, Define Brooks law. Software was delivered late, was ...

Define Brooks law. Software was delivered late, was not reliable, cost various times the original estimates and often exhibited poor performance characteristics.

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.

Contrast between project logic evaluation and networking, QUESTION (a) ...

QUESTION (a) Compare and contrast between Project logic evaluation (PLE), Networking and Scheduling (b) Discuss how the true cost of defects can often be higher than the ini

Micro cds-isis application, Micro CDS/ISIS Application: In libraries t...

Micro CDS/ISIS Application: In libraries there are a number of repetitive operations. If one Miens the procedures for ordering, receiving, processing and circulating a book, o

Draw an appropriate use-case model, This case-study describes the requireme...

This case-study describes the requirements of an airline travel agency who want to develop a website to allow customers to make online bookings. The outline requirements are descri

Ecommerce, Ask What are the key elements of Business Model? question #Minim...

Ask What are the key elements of Business Model? question #Minimum 100 words accepted#

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