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

Drive an expression for peak manning of a project, Q. Drive an expression f...

Q. Drive an expression for peak manning of a project using Nordes - Rayleigh equation . Ans Norden Rayleigh curve utilized to approximate software project . M(t) =Man powe

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

Write down short notes on empirical estimation models, Write down short not...

Write down short notes on empirical estimation models ?

Calculate the peak manning time, Q. Consider a project for which the manpow...

Q. Consider a project for which the manpower requirement is 200 PY and the development time is 2 years. calculate the peak manning time. Ans Software Project cost K=200 PY

Write definition of software process, Write definition of software process....

Write definition of software process. Software process is termed as the structured set of doings that are required to develop the software system.

Discuss the important issues that a srs must address, Q . Discuss the impo...

Q . Discuss the important issues that a SRS must address. Ans. SRS is the method of establishing the services the system should provide of the system in new it is difficult

What is software maintenance, What is software maintenance? Changes to...

What is software maintenance? Changes to the software are made in response to altered requirements but the fundamental structure of the software remains stable.

Data structure, what do you understand by recursion.explain the simulating ...

what do you understand by recursion.explain the simulating recursion in brief.program of fabinacon series by recursion

Write short notes on estimation models, Write short notes on estimation mod...

Write short notes on estimation models. Empirical estimation models can be used to complement decomposition methods and propose a potentially valuable approach in their own rig

Diff. b/w IT & CSE TRADE, Hello I want to know the actual difference b/w in...

Hello I want to know the actual difference b/w information technology & computer science & engineering ? Thanks

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