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

COCOMO MODEL, what is COCOMO model and where it is used also say about COCO...

what is COCOMO model and where it is used also say about COCOMO model when in use then how it act and its characteristtics details

Define the product metrics, Q. Define the Product metrics? (i) Product ...

Q. Define the Product metrics? (i) Product metrics: Explains the characteristics of the product such as complexity, size, design features, performance, efficiency, reliability,

What is software architecture, What is software architecture The softwa...

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

Explain software metric, Software metric Any type of measurement which ...

Software metric Any type of measurement which relates to a software system, process or related documentation Lines of code in a program, the Fog index, number of person-days

What are the characteristics of software measurement, What are the characte...

What are the characteristics of software measurement? Measured property Object of measurement Source of measure Purpose measurement Context of measurement.

Explain the persistent class maps to one relational table, Explain the pers...

Explain the persistent class maps to one relational table In most of cases, persistent class maps to one relational table (keeping aside inheritance issue, for the moment). In

Determine the business process engineering tools, What are business process...

What are business process engineering tools? By modelling the strategic information requirements of an organization, business process engineering tools provide a "meta-model" f

What is the meaning of software, What is the meaning of Software? Softw...

What is the meaning of Software? Software is termed as a set of computer programs that are related documents that are indented to provide required features, functionalities and

Developing conventional, a) Describe refactoring in XP practices. Why refac...

a) Describe refactoring in XP practices. Why refactoring is important for making high quality software systems using agile approach?   b) Can agile approach being used in dev

Explain about the software testing strategies, Explain about the software t...

Explain about the software testing strategies. A method approach to software testing. Verification and Validation. Verification refers to the set of activities that ma

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