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

Explain the software design process, What is the work product of software d...

What is the work product of software design process and who does this? A design model that encompasses architectural, component level, interface and their representations is t

Show the advantages of total quality management, Q. Show the Advantages of ...

Q. Show the Advantages of Total Quality Management? Improves reputation-problems and faults are sorted quicker and spotted (zero defects) Higher employee morale- wo

Explain the software prototyping, What is meant by software prototyping? ...

What is meant by software prototyping? Software prototyping is a process of producing a model for the software product. This is developed based on the recently known requiremen

What is variable trace, 1. "Variable trace" is a (computer) record of the n...

1. "Variable trace" is a (computer) record of the names and the values of variables accessed and/or changed during the implementation of a computer program. 2. "Value trace" is

Different server platforms for erp systems, Question: a. Assume that yo...

Question: a. Assume that you have three similar projects, and, in each, the ratios of problems found during system test versus first year in the field have been 1.5, 1.2, and

Determine the higher order programming languages, Determine the Higher orde...

Determine the Higher order programming languages Higher order programming languages such as COBOL and PASCAL came into existence. Use of these made programming much easier. In

Pl sql, The company wants to offer an incentive of free shipping to those c...

The company wants to offer an incentive of free shipping to those customers who have not returned for two months. Create a procedure named PROMO_SHIP_SP that determines who these c

What is sei capability maturity model, What is SEI capability maturity mode...

What is SEI capability maturity model? Initial Essentially uncontrolled Repeatable Product management procedures explained and used Defined Proc

What are basic key process areas in cmm, Q. What are basic Key process area...

Q. What are basic Key process areas in CMM? Ans) Key Process Areas (KPAs) adds the areas an organization could focus to improve its software process to the next level. Except f

Explain the waterfall model, Explain the waterfall model. Explain why it is...

Explain the waterfall model. Explain why it is more advantageous than adhoc methods. Ans Waterfall Model: 1.The waterfall model is a chronological software development p

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