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

Database mapping, database mapping from class to database

database mapping from class to database

Differentiate between object oriented and function oriented, Differentiate ...

Differentiate between object oriented and function oriented design .  Function-oriented design relies on recognizing functions which transform their inputs to make outputs. I

Calculate the development time, Q. Assuming the Putnam model and given S = ...

Q. Assuming the Putnam model and given S = 100,000 C = 5000 and D 0 = 15 calculate the development time t d.  Ans: In Putnam model (S/C ) 3 = D 0 t d 7 lhs = 20

Whta is boundary value analysis, Boundary Value Analysis:    It's widely ex...

Boundary Value Analysis:    It's widely examined that input values at the extreme ends of input domain cause more errors in system. More application errors happen at the boundaries

What are the principle stages of vord method, What are the principle stages...

What are the principle stages of VORD method? Viewpoint identification: Identify the services given to each viewpoint. Viewpoint structuring: Grouping linked viewpoints in t

Explain the throw away prototype, Explain the Throw away prototype I...

Explain the Throw away prototype In this technique, prototype is discarded once its purpose is fulfilled and final system is built from scratch. Prototype is built quickly t

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

Applicability with reference to software reliability models, Q. Applicabili...

Q. Applicability with reference to software reliability models? Applicability : It is another important characteristic of a model. The model must be judged by its degree of a

How the case tools are classified, How the CASE tools are classified? C...

How the CASE tools are classified? CASE tools can be classified by A. By function or use B. By user type(e.g. manager,tester),or C. By stage in software engineering pr

Explain productivity and difficulty, Productivity and difficulty Produ...

Productivity and difficulty Productivity refers to metrics and measures of output from production processes, per unit of input. Productivity P may be conceived of as a metric

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