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

Two software characteristics, Discuss any two software characteristics. ...

Discuss any two software characteristics. Software is not manufactured : The life of software is from method exploration to the retirement of the software product. It is one t

Discrete mathematics, Within the discussion board area, respond to the foll...

Within the discussion board area, respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your fellow clas

What is a process modeling and management tool, What is a process modeling ...

What is a process modeling and management tool? Process modeling and management tools are used to show the key elements of a process so it can be better understood. Such tools

Define the term software architecture, Define the term "software architectu...

Define the term "software architecture." The software architecture of a program or a computing system is the basic structure of the system, which comprises software components

What is gamma testing, Gamma testing is testing of software that does have ...

Gamma testing is testing of software that does have all the needed features, but did not go by all the in-house quality checks.

Explain iterative development model in detail, Problem 1. Explain Itera...

Problem 1. Explain Iterative Development Model in detail 2. Explain the Incremental Development Model in detail 3. What are the major technical and non-technical factors whic

Explain common coupling with example, Q. Explain Common coupling with examp...

Q. Explain Common coupling with example? Common coupling: General coupling is when two modules share the same global data (example a global variable). Changing of the shared

Hello, What is Queue management sysyem? literature review of Queue managem...

What is Queue management sysyem? literature review of Queue management system

Explain the essential api concepts associated with j2me, Question: (a) ...

Question: (a) State and explain the essential API concepts associated with J2ME. (b) Connected Limited Device Configuration provides two types of application security; stat

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