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

What condition exists after performing validation testing, What are the con...

What are the conditions exists after performing validation testing? After performing the validation testing there two situations arise. The function or performance characterist

Determine the meaning of vertical partitioning, Determine the meaning of ve...

Determine the meaning of vertical partitioning? Vertical partitioning often called factoring suggests that the control and work should be distributed top-down in program struct

What is a test configuration manager, Test Configuration Managers handles t...

Test Configuration Managers handles test environments, scripts, software and test data. Depending on the project, single person may wear more than single hat. For example, Test Eng

What is 4test, What is 4Test? 4Test is a test scripting language which ...

What is 4Test? 4Test is a test scripting language which is used by SilkTest to compose test scripts to perform automated tests. It's an object-oriented fourth-generation langua

what is a user interface, What is a user interface Ans) "User interfac...

What is a user interface Ans) "User interface" is the interface among a human user and a computer system. It access the passage of information among a human user and hardware or

Explain communicational cohesion, Communicational cohesion : Communicationa...

Communicational cohesion : Communicational cohesion is when parts of a module are grouped because they operate on the similar data (e.g. a module which operates on the similar reco

What is equivalence partitioning, Equivalence Partitioning: -Equivalence pa...

Equivalence Partitioning: -Equivalence partitioning is black box testing method that separates the input domain of a program into classes of data from which test cases can be deriv

What is maintenance, Define maintenance. Maintenance is defined as the ...

Define maintenance. Maintenance is defined as the procedure in which changes are executed by either modifying the existing system's architecture or by adding new mechanism to t

What is masm? explain its features, Question 1 What is MASM? Explain its f...

Question 1 What is MASM? Explain its features Question 2 Explain the significance of Lexical analysis and Syntax analysis Question 3 What are macros and macro processors

Operating systems, Compare and contrast two operating systems

Compare and contrast two operating systems

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