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

Explain about mutation testing, Q. Explain about Mutation testing? Mut...

Q. Explain about Mutation testing? Mutation testing In mutation testing the software is initial tested by using an preliminary test suite built up from the different white bo

Define the associative memory, Associative Memory:- The time needed to ...

Associative Memory:- The time needed to find an item stored in memory can be decreased considerably if stored data can be identified for access by the content of the data itsel

What is software, What is Software Software is nothing but a collecti...

What is Software Software is nothing but a collection of computer programs that are related documents that are indented to give desired features, functionalities and good per

Transfection and transduction, What is difference among transfection and tr...

What is difference among transfection and transduction? Ans) Transfection: Transmission of naked DNA into eukaryotic cell Transduction: Transmission of genetic material from

What is unit testing explain, Q. What is Unit testing explain ? Unit t...

Q. What is Unit testing explain ? Unit testing: Unit testing is undertaken after a module has been coded and successfully reviewed. Unit testing (or module testing) is the te

Write down short notes on empirical estimation models, Write down short not...

Write down short notes on empirical estimation models ?

Explain fan in and fan-out, Fan in/Fan-out :- Fan-in is a measure of th...

Fan in/Fan-out :- Fan-in is a measure of the number of process or functions that call some other function or process (say X). Fan-out is the number of functions that are known

Distinguish between alpha and beta testing, Distinguish between alpha and b...

Distinguish between alpha and beta testing.  Alpha and beta testing are the types of acceptance testing.  Alpha test: The alpha testing is attesting in which the version o

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.

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