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

Software methodology, how to choose a software methodology for a software p...

how to choose a software methodology for a software project

Software engineering, Software Engineering A  high technology system e...

Software Engineering A  high technology system encompasses a  number of  elements like   people, hardware, software, database, documentation, and process.  System engineering

What are the main objectives of reverse engineering, Q. Define Reverse Engi...

Q. Define Reverse Engineering? What are the main objectives of reverse engineering? Ans: The reverse engineering is the procedure of generating representations that are imple

What is a user friendly document, What is a user friendly document? Ans)...

What is a user friendly document? Ans) A document is user friendly, when it is designed and written with simple of use, as single of the primary objectives of its design.

Describe any types of feasibility study, System Development Life Cycle (SDL...

System Development Life Cycle (SDLC) stages are sometimes known as System Study. System concepts which are important in developing business information systems expedite problem sol

Explain in detail about structural modelling, Explain in detail about Struc...

Explain in detail about Structural Modelling. Structural model contains a detail refinement of ERD, data flow model and control flow model. Creating an ERD. Examp

Explain test case, Documentation verifying inputs, predicted results, and a...

Documentation verifying inputs, predicted results, and a set of implementation conditions for a test item. A test case is a document that explains an input, action, or event and

Final Year Project Help, I am currently working on a project and am far fro...

I am currently working on a project and am far from passing, I need help ASAP! The project task is to create a Decision support system for An Airline. It must predict and make de

What is cocomo model, What is COCOMO model? COnstructive COst MOdel is ...

What is COCOMO model? COnstructive COst MOdel is a cost model, which provides the estimate of number of man-months it will take to make the software product.

Differentiate between object oriented and function oriented, Differentiate ...

Differentiate between object oriented and function oriented design .  Function-oriented design relies on recognizing functions which transform their inputs to make outputs. I

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