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

Explain cocomo model with its applicable equations, Q. Explain COCOMO model...

Q. Explain COCOMO model with its applicable equations. Describe various attributes of cost drivers used in COCOMO model. Ans. COCOMO denotes for constructive cost model -

Define graph matrix and connection matrix, Define graph matrix and connecti...

Define graph matrix and connection matrix.      Graph matrix: A graph matrix is a square matrix whose size (i.e., number of rows and columns) is equivalent to the number of n

What is stepwise refinement, Q. What is stepwise refinement? Stepwise R...

Q. What is stepwise refinement? Stepwise Refinement:-Stepwise Refinement is a top-down design strategy initially proposed by Niklaus Wirth. A program is developed by consecutiv

Illustrate the relationship between time and cost, Q. Illustrate the relati...

Q. Illustrate the relationship between Time and cost? In software projects, time cannot be freely exchanged against cost. Such a trade off is limited by the nature of the softw

Discuss about service oriented architecture, Question : (a) Discuss ab...

Question : (a) Discuss about Service Oriented Architecture (SOA), in terms of key principles, benefits and applicability. Also include examples of applications suitable for

How lru technique is implemented, How LRU technique is implemented The ...

How LRU technique is implemented The LRU policy is more difficult to execute but has been more attractive on the assumption that the least recently used page is a better candid

Define the system requirements, What is meant by System Requirements? ...

What is meant by System Requirements? Place the system services and constraints in detail. Serves as a link between the system purchaser & the system developer.

State the coding standards, State the Coding standards Coding standar...

State the Coding standards Coding standards normally give the guidelines about following: i)  Name of the module ii)  External and Internal documentation of source code

Calculate the information flow index of individual modules, Q. For the stru...

Q. For the structural chart given in fig.1 calculate the Information Flow index of individual modules as well as whole software. Total information flow = IF (main) + IF (A

When we require to re-engineer, When to Re-Engineer? When the syst...

When to Re-Engineer? When the system alter are mostly confined to part of the system then re-engineer that part. When hardware or software support becomes obsolete.

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