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

DAO java, inside a button click can we put following code... Account a = n...

inside a button click can we put following code... Account a = new Account(); a.setAccNo(Integer.parseInt(txtAccNo.getText())); a.setDepositamt(Float.parseFloat(tx

Evaluate the usefulness of roce, Present an evaluation of the current perfo...

Present an evaluation of the current performance of your chosen company using ROCE, RI, EVA and SVA.  (All figures employed should be up to date , clearly explained / justified an

What is comparison testing, Comparison testing is testing that evaluate sof...

Comparison testing is testing that evaluate software weaknesses and strengths to those of competitors' products.

Systems Design Lifecycle, What is the development lifecycle? Why is it usef...

What is the development lifecycle? Why is it useful? Describe the activities carried out at each stage Determination of scope Requirements specification Design Coding Testing Maint

What are the advantages of evolutionary prototyping, What are the advantage...

What are the advantages of evolutionary prototyping? i. Fast delivery of the working system. ii. User is included while developing the system. iii. More useful system can

List any characteristics of a good srs, List any three characteristics of a...

List any three characteristics of a good SRS. Ans:The SRS should be: Correct , Unambiguous, Complete 1. Correct: An SRS is correct if each requirement stated therein is on

Write definition of state transition diagram, Write definition of state tra...

Write definition of state transition diagram? State transition diagram is mainly a collection of states and events. Due to the events the system has to change its state. It als

#use case diagram, #use case diagram for car manufactures by considering bu...

#use case diagram for car manufactures by considering build and price of car as use case#

Discuss the problems faced during software maintenance, Q. Discuss the prob...

Q. Discuss the problems faced during software maintenance? The most significant problem during maintenance is that before correcting or else modifying a program the programmer

What are the various testing activities, What are the various testing activ...

What are the various testing activities? i. Test planning ii. Test case design iii. Data collection iv. Test execution v. Effective evaluation

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