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

Feasibility analysis report, Aim to follow the weekly schedule - some time ...

Aim to follow the weekly schedule - some time in each tutorial class will be devoted to working in your teams of two under the guidance of your tutor on this project.  However, te

Write a valid schema for the container, A storage tank has a container to k...

A storage tank has a container to keep a certain amount of fuel and it also has an indicator to inform about the level of fuel inside the container. The container cannot exceed

Explain the quality assurance, Quality Assurance Quality assurance is a...

Quality Assurance Quality assurance is an activity that establishes and evaluates the processes that produce products. Quality assurance would calculate processes to identify w

What is quality control, What is quality control? Ans) Quality control m...

What is quality control? Ans) Quality control means to preserve the quality of product by measuring their content , different physical parameters.

Explain critical design review, Explain critical design review The purp...

Explain critical design review The purpose of critical design review is to make sure that the detailed design satisfies the specifications laid down during system design. The

Test plan including test cases, This assignment aims to provide the opportu...

This assignment aims to provide the opportunity to integrate and develop your analytical and written communication skills, and speci?cally to:develop your skills at developing test

Define software testing, Define software testing? Software testing is a...

Define software testing? Software testing is a critical element of software quality assurance and shows the ultimate review of specification, design, and coding.

Explain the purpose of checkpoints in winrunner, Explain the purpose of che...

Explain the purpose of checkpoints in Winrunner? Checkpoints help to compare behavior of current application to its previous version. There are total of four types of checkpoin

What is a user guide, The "user guide" is the similar as the user manual. T...

The "user guide" is the similar as the user manual. The user guide is a document that shows information essential to employ a system or component to get the desired results. Typica

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