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

Define metrics, Define metrics. Metrics is explained as the degree to w...

Define metrics. Metrics is explained as the degree to which a system component, or process possesses a given attribute.

Project requirements, Leader: Aim/vision of project. Business plan, Screenc...

Leader: Aim/vision of project. Business plan, Screencast coordination, lines of communication, feedback, must give updates during  lecture slot. Evaluated, in part, on how well who

Case tools, #question2. Explain any ten CASE tools...

#question2. Explain any ten CASE tools...

What are task regions in the spiral model, What are task regions in the Spi...

What are task regions in the Spiral model. Customer communication - In this region it is recommended to establish customer communication. Planning - All planning doings are

Write definition of state transition diagram, Write definition of state tra...

Write definition of state transition diagram? State transition diagram is mainly a collection of states and events. Due to the events the system has to change its state. It als

Explain horizontal partitioning, Explain Horizontal partitioning 1. Ex...

Explain Horizontal partitioning 1. Explains separate branches of the. 2. Propagaton of fewer side-effects 3. Software is simpler to maintain

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

What is meant by software prototyping, What is meant by software prototypin...

What is meant by software prototyping? Software prototyping is a process of creating a model for the software product. This is developed based on the currently known requiremen

Explain acceptance testing, Testing conducted to verify whether or not a sy...

Testing conducted to verify whether or not a system satisfies its acceptance criteria and to enable the customer to verify whether or not to accept the system. Contrast with testin

What is cocomo, Software project Management & Quality Assurance 1. Brie...

Software project Management & Quality Assurance 1. Briefly explain various activities involved in project management. 2. What is COCOMO? Write necessary steps for cost estim

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