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

Why we use coverage analyzers, Q. Why we use Coverage analyzers? Cover...

Q. Why we use Coverage analyzers? Coverage analyzers (execution verifiers) A coverage analyzer is the most common and important tool for testing. It is often relatively simpl

Explain the types of software testing, Explain the types of software testin...

Explain the types of software testing. Unit testing Integration testing System testing User-acceptance testing End-to-End testing Exception testing

Why winrunner may fail to identify an object on a gui, Why WinRunner may fa...

Why WinRunner may fail to identify an object on a GUI? WinRunner may fail to recognize an object in a GUI in below cases: - If it isn't a standard windows object - If the

What are the types of software system requirements, What are the types of S...

What are the types of Software system requirements? Functional requirements: Services the system should give. Non-functional requirements: Constraints on the services.

Layered software architecture, iii. Layered software architectures can be ...

iii. Layered software architectures can be used to reduce coupling between the functions of a system that are closer to the machine and those that are closer to user needs. Why is

State both verification and validation, Define Verification &Validation. ...

Define Verification &Validation. Verification : The set of actions that make sure software correctly implements a particular function. Validation : The set of actions that

What tasks do checkpoints perform in QTP, What tasks do checkpoints perform...

What tasks do checkpoints perform in QTP? Checkpoints in QTP are used to verify information which is expected to be displayed when running test. Following are 8 types of availa

Describe in brief about the elementary process, Elucidate elementary proces...

Elucidate elementary process. Software applications are a combination of various elementary processes. Various elementary processes come together to form an application. Ele

What are the elements of design model, What are the elements of design mode...

What are the elements of design model? i. Data design ii. Architectural design iii. Interface design iv. Component-level design

What are the benefits of incremental model, What are the Benefits of increm...

What are the Benefits of incremental model This model is acceptable when there is less number of person involved in the project. Technical risks can be handle with every

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