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

Realistic approach to the development of large-scale systems, Q. Realistic ...

Q. Realistic approach to the development of large-scale systems? There are a number of advantages of Spiral model that makes it a realistic approach to development of large-sca

Determine the common problems with software automation, Determine the commo...

Determine the common problems with software automation ? The biggest concern is the cost incurred for test automation. Also, often s/w test automation needs skilled personnel an

Determine the various levels of testing, Determine the various levels of te...

Determine the various levels of testing The following are various levels of testing: Large systems are built out of subsystems which are made up of modules, modules of funct

What are the debugging programs, Q. What are the Debugging programs? De...

Q. What are the Debugging programs? Debugging programs:-A program which runs simultaneously with the program under test and provides commands to examine memory and registers st

Explain black box testing and its categories, Black Box Testing :-Black Box...

Black Box Testing :-Black Box Testing is also known as behavioural testing, focuses on the functional requirements of the software. It allows the software engineer to derive sets o

Difference between module coupling and module collection, Q. What is the di...

Q. What is the difference between module coupling and module collection? List different types of coupling and cohesion. Ans : Cohesion is the property of a single module as we

What is the use of cmm, What is the use of CMM? Capability Maturity Mod...

What is the use of CMM? Capability Maturity Model is used in assessing how well an organisation's processes permit to complete and manage latest software projects.

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

What are the benefits of evolutionary prototyping? i. Fast release of the working system. ii. User is engaged while developing the system. iii. More functional system can

What is software testing, What is software testing? The testing process...

What is software testing? The testing process focuses on the logical internals of the software, ensuring that all statements have been tested, and on the functional externals,

Describe the various types of restructuring techniques, Describe the variou...

Describe the various types of restructuring techniques. (a) Code Restructuring: It is performed to yield a design that produces the similar function but with higher quality t

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