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

SOFTWARE, EXPLAIN COMPONENTS OF DATABASE MANAGEMENT

EXPLAIN COMPONENTS OF DATABASE MANAGEMENT

Use of software package, USE OF SOFTWARE PACKAGE: The concept of appli...

USE OF SOFTWARE PACKAGE: The concept of applications software and were told about software packages and their types. In other words, the discussion implies that instead of wri

Explain the software architecture, What is software architecture? The ...

What is software architecture? The software architecture of a program or computing system is the structure or structures of the system, which comprises software methods, the e

Assignment projects, I want to make assignements regarding software enginee...

I want to make assignements regarding software engineering.

Define software testing, Define software testing? Software testing is a...

Define software testing? Software testing is a critical element of software quality assurance and shows the ultimate review of specification, design, and coding.

Differentiate between smoke testing and sanity testing, Differentiate betwe...

Differentiate between smoke testing and sanity testing. -Smoke testing verifies all areas of application; sanity testing recognizes one or few areas only. -Smoke testing is

What is requirements engineering, What is Requirements Engineering Req...

What is Requirements Engineering Requirements engineering is systematic use of proven techniques, principles and language tools for cost effective analysis, on-going evaluatio

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.

List the process maturity levels in seis cmm, List the process maturity lev...

List the process maturity levels in SEIs CMM. Level 1: Initial - Few processes are explained and individual efforts are taken. Level 2:Repeatable - To track cost schedule an

What are repositories used by qtp to store object properties, What are repo...

What are repositories used by QTP to store object properties? QTP uses two kinds of repositories to store object properties. a.) Shared object repository: A global object

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