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

Define the alpha testing and beta testing, Alpha testing and Beta testing ...

Alpha testing and Beta testing Alpha testing is conducting acceptance testing in the environment where the application was formed. It is done by the customer. Beta testing is c

What is a software package, QUESTION a) What is a software package? ...

QUESTION a) What is a software package? b) A lot of data is collected and stored on digital medium today. Organisations rely a lot on the data for their smooth running. Desc

What is the key process areas, What is the Key Process Areas SEI has a...

What is the Key Process Areas SEI has associated key process areas(KPAs) with every maturity level. KPA is an indicative measurement of goodness of software engineering functi

Determine the test cases using boundary value analysis, Q. Consider a progr...

Q. Consider a program which computes the square root of an input integer between 0 and 5000. Determine the equivalence class test cases. Determine the test cases using boundary val

What is the meaning of scm and sci, What is the meaning of SCM? Softwar...

What is the meaning of SCM? Software Configuration Management is termed as a set of actions performed for identifying, organizing and controlling changes throughout the lifecyc

What are dynamic testing tools, What are dynamic testing tools?  Dynami...

What are dynamic testing tools?  Dynamic testing tools:  1: coverage analyzers (execution verifiers 2: output comparators 3: Test data generators: 4:  Test file gen

Define test methodology and test scenario, Define Test Methodology and  Te...

Define Test Methodology and  Test Scenario Testing methodology verifies how an application will be tested and what will be tested. Example of methodologies: waterfall, agile

Define system modeling, Define System Modeling? Explain the processe...

Define System Modeling? Explain the processes that serve requirements of the view under consideration. Shows the behaviour of the processes and the assumptions on which t

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