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

Illustrate the process maturity, Define process maturity. In recent ye...

Define process maturity. In recent years there has been a major highlighting on process maturity.  The Software Engineering Institute. (SEI) has developed a widespread model p

Software licesnse, what are the main characteristics of software lease

what are the main characteristics of software lease

Explain iterative enhancement model, Q. Explain Iterative Enhancement model...

Q. Explain Iterative Enhancement model? This model incorporates modification in the software based on the analysis of the existing system. As well the complete documentation of

Difference between module coupling and module collection, What is the diffe...

What is the difference between module coupling and module collection? Cohesion is the property of a one module and can be defined as glue that keeps the data elements within a

Illustrate the symbols of a data flow diagram, Symbols of a data flow diagr...

Symbols of a data flow diagram  1. Data Flow Signifies the connectivity between various processes 2. Process   Performs some processing of input data 3. Ex

The phases of a problem solving loop, Problem solving is a critical skill f...

Problem solving is a critical skill for success in business—in fact it’s often what you are hired and paid to do. This article explains the five problem solving steps and provides

What is meant by system requirements, What is meant by System Requirements ...

What is meant by System Requirements Set out the system constraints and services in well explained. Serves as a contract among the system buyer & the system developer.

When must a function throw an exception, When must a function throw an exce...

When must a function throw an exception? A function must throw an exception when it's not able to fulfil its promise. As soon as function detects a problem which prevents it

What is program control instruction, What is Program Control Instruction ...

What is Program Control Instruction A program control type of instruction, when implemented, may change the address value in the program counter and cause the flow of control t

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