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

Numerical analysis, Use the Newton divided-di_erence method to construct in...

Use the Newton divided-di_erence method to construct interpolating polynomials of degree one, two, and three for the following data. Approximate f(0.18) using each of the polynomia

Transform maping., using a dfd and a processing narrative,describe computer...

using a dfd and a processing narrative,describe computer based system that can distinct transform flow characteristics.Define flow boundaries map the dfd into a software architectu

Discuss about rad model, Discuss about RAD Model Rapid Application D...

Discuss about RAD Model Rapid Application Development Model is the one type of incremental model. Gains the high speed development utilising component based construction.

Defining intermediate representation, Problem 1 (i) Define the terms ...

Problem 1 (i) Define the terms Language Grammar Terminal symbols Non-Terminal symbols Alphabets >>Define sub parts (ii) Identify and write what these

What are the various types of system testing, What are the various types of...

What are the various types of system testing? 1. Recovery testing - is planned to check the system's ability to recover from failures. 2. Security testing - determines t

What are decision tables, What are decision tables? Why do we use them? ...

What are decision tables? Why do we use them? - Decision tables are specification-based techniques that are more focused on business rules or business logic. - A decision ta

Explain in detail about data modelling, Explain in detail about data modell...

Explain in detail about data modelling. Data modeling makes use of the ERD. Having of 3 interrelated information. The data object. Attributes.  Relationsh

Explain quality assurance and standards, Quality assurance and standards ...

Quality assurance and standards Standards are the key to effective quality management. They may be international, national, and organizational or project standards. Prod

What is pure and impure interpreter, what is interpreter explain pure and i...

what is interpreter explain pure and impure interpretion

Explain dynamic testing, Verification or validation performed which impleme...

Verification or validation performed which implements the system's code.

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