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

Discuss in detail about cocomo model, Discuss in detail about COCOMO model....

Discuss in detail about COCOMO model. Constructive Cost Model. Software cost estimation gives the opportunity to estimate of how much months a man take to develop a softw

What are the task involved in design process of sdlc, What are the task inv...

What are the task involved in design process of SDLC General tasks involved in the design process are the following: i)  Design various blocks for overall system processes.

Patient management system for a hospital, Maintain you are involved in a la...

Maintain you are involved in a large project concerning the development of a patient management system for a hospital. You may opt for one of two plans. The first plan is to start

What are repositories used by qtp to store object properties, What are repo...

What are repositories used by QTP to store object properties? QTP uses two kinds of repositories to store object properties. a.) Shared object repository: A global object

Use case realization, Develop a domain model for the Case Study. Express yo...

Develop a domain model for the Case Study. Express your model with a class diagram, showing any inheritance and compositional relationships. For each of the two selected most es

What is function count, Function count:- It measures the functionality fro...

Function count:- It measures the functionality from the user point of view, that is, on the basis of what the user requests and receives in return. Therefore it deals with the fun

What are the problems in comes in SRS, What are the Problems in comes in SR...

What are the Problems in comes in SRS There are numerous features which make requirements analysis difficult. These are explained below: 1. Complete requirements are diffic

What are the advantages of using testing tools, What are the advantages of ...

What are the advantages of using testing tools? The advantages of testing tools are: They get better the productivity and quality of software development. Help in i

Software Metrics, How to interpret software metrics(any metrics)...i need a...

How to interpret software metrics(any metrics)...i need an example

Concepts of the object-oriented paradigm, To develop software of lasting qu...

To develop software of lasting quality you have to lay down a solid architectural foundation that is resilient to change. Modelling is at the heart of the development of good quali

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