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

How to build the structure chart, Q. How to build the Structure Chart? ...

Q. How to build the Structure Chart? Building the Structure Chart Processes in the DFD are liable to represent one module on the structure chart Efferent processes

What are the objectives of analysis modeling, What are the objectives of An...

What are the objectives of Analysis modeling? i. To explain what the customer needs. ii. To establish a basis for the creation of software design. iii. To devise a set of

Transaction mapping, how transaction mapping is done.??clear me with a brie...

how transaction mapping is done.??clear me with a brief example

Discuss the design steps of the transform mapping, Discuss the design steps...

Discuss the design steps of the transform mapping. Re-examine the fundamental model. Re-examine and refine the DFD for the software. Determine the DFD has either the

What is eva, What is EVA? Earned Value Analysis is a process of perform...

What is EVA? Earned Value Analysis is a process of performing quantitative analysis of the software project. It gives a common value scale for each task of software project. It

Name the design phase of SDLC, Name the design phase of SDLC Generally,...

Name the design phase of SDLC Generally, design is performed in the below two steps: i)  Primary Design Phase: In this phase, system is designed at block level. Blocks are

Define about the erroneous data - Test data, Define about the erroneous dat...

Define about the erroneous data - Test data Abnormal/erroneous data  -  This is data outside the limits of validity/acceptability and must cause an error message to be g

What is failure-directed testing, What is Failure-directed Testing Ans) ...

What is Failure-directed Testing Ans) Testing based on the information of the types of errors made in the earlier period that are likely for the system under test.

What is the best effort estimation for software phases?, Hello, I am a CS ...

Hello, I am a CS graduate and i just got a new job in a software development company. My boss assigned me to come up with what he called "the perfect pie chart" basically he says

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