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 is regression testing, What is regression testing? Regression test...

What is regression testing? Regression testing is the re-execution of some subject texts that have already been conducted to make sure that changes have not propagated unintend

Explain acceptance testing and beta testing, Q. Explain acceptance testing ...

Q. Explain acceptance testing and beta testing? Acceptance Testing as well as Beta testing: System tests are designed to authenticate a fully developed system to guarantee th

List the pre-requisites for white-box testing, List the pre-requisites for ...

List the pre-requisites for white-box testing Pre-requisites for white-box testing are similar to black-box testing with one key difference: - During white-box testing, test

What do you understand by software quality, What do you understand by "Soft...

What do you understand by "Software Quality"? Quality software means, it's: - Free of bugs - Is easily maintainable - Within the budget - Meets requirements - De

What are documentation standards, What are Documentation standards? P...

What are Documentation standards? Particularly important - documents are the tangible manifestation of the software. Documentation process standards Concerned with how

State lehman first law, State Lehman's First law A program that is used...

State Lehman's First law A program that is used in real world environment of necessity must change or become progressively less useful in that environment.

What are the common approaches in debugging, What are the common approaches...

What are the common approaches in debugging? Brute force method: The memory dumps and run-time tracks are explained and program with write statements is loaded to get clues to

Define behavioral modelling, Define Behavioral Modelling The state tran...

Define Behavioral Modelling The state transition diagram represents the behavior of a system by depicting its states and the events that cause the system to change state.

Explain a variable, Explain a variable? "Variables" are data items in a ...

Explain a variable? "Variables" are data items in a program whose values can change.

Diff. b/w IT & CSE TRADE, Hello I want to know the actual difference b/w in...

Hello I want to know the actual difference b/w information technology & computer science & engineering ? Thanks

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