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

Determine the structure of design concepts, Structure of design It ...

Structure of design It allows the decomposition of a large system into smaller, more manageable units with well explained relationships to the other units in a system. N

What does validation represent, What does Validation represent? Validat...

What does Validation represent? Validation show the set of activities that make sure that the software that has been built is satisfying the customer requirements.

CRT, EXPLAIN THE WORKING OF CRT?

EXPLAIN THE WORKING OF CRT?

What is software requirement specification, What is Software requirement Sp...

What is Software requirement Specification (SRS)? Software Requirement Specification Document is the output of requirement examines stage of the software development life cycle

What are the characteristics of software, What are the characteristics of S...

What are the characteristics of Software Software is engineered or formed; it is not manufactured in the classical sense. Software doesn't wear out. Although the indu

Explain about the software metrics, SOFTWARE METRICS Measurement is fun...

SOFTWARE METRICS Measurement is fundamental to an engineering discipline and software engineering is no exception. Software metric is a quantitative measure which is derived fr

What is change management, What is Change management? Software systems ...

What is Change management? Software systems are subject to continual change requests; From users; From developers; From market forces. Change management is

Use of test file generators in software engineering, Q. Use of Test file ge...

Q. Use of Test file generators in software engineering? Test file generators This creates a file of information that is used as the program and does so based on comments give

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

What are the benefits of prototyping, What are the benefits of prototyping?...

What are the benefits of prototyping? i. Prototype uses as a basis for deriving system specification. ii. Design quality can be better. iii. System can be handled efficie

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