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

Difference between verification and validation, Difference between Verifica...

Difference between Verification and Validation Verification is Static whereas Validation is Dynamic. This means in Verification the s/w is inspected by looking into the code go

Illustrate partitioning in stepwise refinement, Q. Illustrate Partitioning ...

Q. Illustrate Partitioning in stepwise refinement? Problems are frequently too large and complex to be understood as a whole. Therefore we tend to partition such problems into

Diffrence between functional testing and structural testing, Q. Differentia...

Q. Differentiate between functional testing and structural testing. Ans: Functional testing signifies behavioural testing or Black box testing. In this techniques the teste

Difference between module coupling and module collection, Q. What is the di...

Q. What is the difference between module coupling and module collection? List different types of coupling and cohesion. Ans : Cohesion is the property of a single module as we

Software development, SOFTWARE DEVELOPMENT: Software development is a ...

SOFTWARE DEVELOPMENT: Software development is a human activity. It involves a clear understanding of the field of application, such as library and information science; knowled

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

Determine the aspects of prototyping model., Determine the aspects of proto...

Determine the aspects of prototyping model. Figure below portrays prototyping model. Prototype model has the below aspects: (i)  It helps in determining user requirements

Advantages and disadvantages of size measure, What are the advantages and d...

What are the advantages and disadvantages of size measure? Advantages: Artifact of software development which is simply counted. Many existing methods use LOC as a key input. A

What are the functions of data architecture, What are the functions of data...

What are the functions of data architecture? It gives the information needed for a business function. Recognize the data objects and their relationship. Eg: Custome

Write short notes on quick-fix model, Q. Write short notes on Quick-fix Mod...

Q. Write short notes on Quick-fix Model? Quick-fix Model: This is the simplest model utilized for the maintenance of the software. In this model modification at the code level

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