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

Illustrate about the managed level of maturity model, Level 4 (Managed) ...

Level 4 (Managed) Organisation satisfies all the requirements of level-3. At this level quantitative standards are set for software processes andproducts. Project analysis is

Write about drivers and stubs, Write about drivers and stubs. Drivers a...

Write about drivers and stubs. Drivers and stub software require to be developed to test incompatible software. The " driver" is a program that accepts the test data and pri

What is recovery/error testing, Recovery/error testing is testing how well ...

Recovery/error testing is testing how well a system recovers from crashes, hardware failures, or other catastrophic problems.

What tasks do checkpoints perform in QTP, What tasks do checkpoints perform...

What tasks do checkpoints perform in QTP? Checkpoints in QTP are used to verify information which is expected to be displayed when running test. Following are 8 types of availa

Explain white-box and black-box testing in detail, Problem 1. Explain w...

Problem 1. Explain why it is necessary to design the system architecture before the specifications are written 2. Explain why it is important to describe software designs 3.

What are the aims of testing, What are the aims of testing? i. T...

What are the aims of testing? i. Testing is a process of executing a program with the target of finding an error. ii. A good test case is one that has high possibilit

Incremental model, four circumstances where incremental model is appropriat...

four circumstances where incremental model is appropriate?

Application design - micro cds-isis software, Application Design: Micr...

Application Design: Micro CDS/ISIS is a text oriented software package. It is a good , ho ice if one wishes to store textual data, retrieve the data by certain criteria, and d

List flaws in waterfall model, List flaws in waterfall model. - The big...

List flaws in waterfall model. - The biggest drawback is that you don't test the application logic until very late in development cycle. - Though a detailed system specifica

Explain in detail the design concepts, Explain in detail the design concept...

Explain in detail the design concepts. Abstraction Functional abstraction Data abstraction Control abstraction Information hiding Every module in

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