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

Discuss in detail about delphi method, Discuss in detail about Delphi Metho...

Discuss in detail about Delphi Method. Procedure The co-ordinator represents a specification and assessment form to each expert. Co-ordinator calls a group discussion

What is data binding, Q. What is Data Binding? Ans. The matrix that at...

Q. What is Data Binding? Ans. The matrix that attempts to imprison the module-level concept of coupling is data binding. Data binding are a calculate that captures the data in

Analyses the system design process of a project, Write a report which criti...

Write a report which critically analyses the system design process of a project. Projects might include designing a light rail network for a city, more environmentally-conscious bu

What are the testing principles of software testing, What are the testing p...

What are the testing principles the software engineer must apply whereas performing the software testing? i. All tests should be traceable to customer requirements. ii. Test

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

How a prototype can be categorised, How a prototype can be categorised ...

How a prototype can be categorised 1.  A paper prototype which is a model depicting human machine interaction in a form which makes user understand how such interaction, would

Data Flow Diagram, I need help creating a DFD for an assignment. Is there a...

I need help creating a DFD for an assignment. Is there anyway you could help?

What are the elements of design model, What are the elements of design mode...

What are the elements of design model? i. Data design ii. Component-level design iii. Interface design iv. Architectural design

Find the decrement of failure intensity per failure, Q. Assume that a progr...

Q. Assume that a program will experience 200 failures in infinite time. It has now experienced 100. The initial failure intensity was 20 failures/CPU hr. (i) Determine the cur

What do you mean by polymorphism, Q. What do you mean by Polymorphism? ...

Q. What do you mean by Polymorphism? Polymorphism:- Polymorphism includes the ability to use the same message to objects of different classes and have them behave differently.

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