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

When must a function throw an exception, When must a function throw an exce...

When must a function throw an exception? A function must throw an exception when it's not able to fulfil its promise. As soon as function detects a problem which prevents it

Explain incremental testing, Incremental integration testing is permanent t...

Incremental integration testing is permanent testing of an application as new functionality is recommended. This may need that various aspects of an application's functionality are

Case tools, #question2. Explain any ten CASE tools...

#question2. Explain any ten CASE tools...

Product engineering, Product Engineering The Product engineering which ...

Product Engineering The Product engineering which is also called system engineering is a problem solving activity. To function, desired product data, and behaviour are uncovere

List the important properties of a modular system, List the important prope...

List the important properties of a modular system.    Desirable properties are:- Every module is a well defined subsystem useful to others Every module has a well defined single

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

Explain any ten case tools, Question 1 Explain black box and white box tes...

Question 1 Explain black box and white box testing techniques Question 2 Explain different roles of the software development? Question 3 List out different project

What do you mean by static analysers, Q. What do you mean by Static analyse...

Q. What do you mean by Static analysers? Static analysers A static analyser operates from a pre-computed database of descriptive information derived from the source text of t

Draw an entity relationship diagram for the case study, Question: (a) ...

Question: (a) Document the information input and output for the events mentioned in the case study on the basis of facts provided. (b) Comment on the fact that barely any

Demonstrate about analysis and design of a software system, Aim The aim...

Aim The aim of this Assignment is to demonstrate knowledge about the analysis and design of a  software  system  and  understanding  of  the  application  of  an  object-orient

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