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

What is equivalence partitioning, What is equivalence partitioning? Equ...

What is equivalence partitioning? Equivalence partitioning is a black box method that separates the input domain into classes of data. From this data test cases can be derived.

Determine the characteristics of software, What are the characteristics of ...

What are the characteristics of Software? Software is engineered or modified; it is not manufactured in the traditional sense. Software is free of wear out. Though the

Explain the relationship between productivity and difficulty, Q. Explain th...

Q. Explain the relationship between Productivity and difficulty? Productivity refers to metrics as well as measures of output from production processes per unit of input. Pr

Define evolutionary prototyping, Q. Define Evolutionary prototyping? Ev...

Q. Define Evolutionary prototyping? Evolutionary Prototyping is also known as breadboard prototyping is quite different from Throwaway Prototyping. The major goal when using Ev

#title.decision table, You are to create a decision table to help you decid...

You are to create a decision table to help you decide what to do for the day. If it is a weekday and it is not a holiday, then you go to work. However, if it is a weekday and it

Determine the principle stages of vord method, What are the principle stage...

What are the principle stages of VORD method? Viewpoint identification: Identify the services provided to each point of view Viewpoint structuring: Sorting related viewpoint

What is meant by throw away prototyping, What is meant by Throw away Protot...

What is meant by Throw away Prototyping? Giving the user a system which is incomplete and then changing and augmenting it as the user requires become clear. The objective

Explain in detail about structural modeling, Explain in detail about Struct...

Explain in detail about Structural Modeling. Structural model having a detail refinement of ERD, data flow model and control flow model. Creating an ERD. Example: Saf

Define a class diagram with example, Q. Define a Class diagram with example...

Q. Define a Class diagram with example? Class diagram: A class diagram in the UML (Unified Modelling Language) is a type of static structure diagram that describes the struct

Explain the difference between latent and masked defect, Explain the differ...

Explain the difference between Latent and Masked Defect. Latent Defect is one which has been in the system for a long time; but is discovered now. I.e. A defect which has been

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