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 are the objectives of analysis modeling, What are the objectives of An...

What are the objectives of Analysis modeling? i. To explain what the customer needs. ii. To establish a basis for the creation of software design. iii. To devise a set of

Word processing software, Word Processing Software: Word processing is...

Word Processing Software: Word processing is one of the most wide spread applications software types in use today. Developed as a successor to primitive text-editors that re o

Define debugging, Define debugging. Debugging is defined as the process...

Define debugging. Debugging is defined as the process of removal of defect. It occurs as a consequence of successful testing.

Basic cocomo model and the detailed cocomo model, Q. Compare the basic COCO...

Q. Compare the basic COCOMO model with the detailed COCOMO model. Ans. COCOMO contains of a hierarchy of three increasingly detailed and accurate forms. Basic COCOMO i

What is the evolution of software engineering, What is the Evolution of sof...

What is the Evolution of software engineering Any application on computer runs by software. As computer technologies have changed tremendouslyinthe last five decades, consequen

What is architectural transformation, What is architectural transformation?...

What is architectural transformation? This is a more radical approach to software change then maintenance as it involves making significant changes to the architecture of the s

Justify the term software is engineered, Justify the term "Software is engi...

Justify the term "Software is engineered" Software is engineered not manufactured. Although some similarities exit among software development and hardware manufacture, the two

Differentiate between failures and faults, Q. Differentiate between failu...

Q. Differentiate between failures and faults? Ans. Failure: -Failure is the disappearance of external results of program operation from requirements. Consequently failure is

Draw E-R diagram for the given situation, Draw E-R diagram for the followin...

Draw E-R diagram for the following situation An account is a relationship between customer and bank. A customer has a name. A bank has a branch. A customer may have numerous ac

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