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

Explain product and process standards, Product and process standards Pr...

Product and process standards Problems with standards They may not be seen as relevant and up-to-date by software engineers. They often include too much bureaucratic form

Explain the capability maturity model, Explain the CAPABILITY MATURITY MODE...

Explain the CAPABILITY MATURITY MODELS Process models are based on various software development phases while capability models have an entirely different foundation of developm

What is criticality, What is Criticality? The degree of impact that a ne...

What is Criticality? The degree of impact that a necessity, module, error, fault, failure, or other item has on the operation of a system or development.

What is structure chart, Structure chart:  A structure chart is a top-down...

Structure chart:  A structure chart is a top-down modular design tool, constructed of squares representing the dissimilar modules in the system, and lines that connect them. The l

Explain about the spiral model, Explain about the Spiral Model This mod...

Explain about the Spiral Model This model can be considered as the model that combines the strengths of various other models. Conventional software development processes don't

What is stamp coupling, Q. What is Stamp coupling? Stamp coupling: St...

Q. What is Stamp coupling? Stamp coupling: Stamp coupling take places between module A and B when complete data structure is passed from one module to another. Since not ever

Name some common software standards, Name some Software Standards Num...

Name some Software Standards Numerous terms related to software engineering are regularly standardised by organisations like IEEE (Institute of Electrical and Electronics Engi

What is stepwise refinement, What is stepwise refinement? Stepwise Ref...

What is stepwise refinement? Stepwise Refinement:- Stepwise Refinement is a top-down design method originally proposed by Niklaus Wirth. A program is developed by successively

Facilitated application specification technique, Q. Facilitated Application...

Q. Facilitated Application Specification Technique? A team oriented approach is developed for needs gathering and is called facilitated application specification Techniques FAS

Briefly describe what are deployment diagrams, Question: (a) Compare t...

Question: (a) Compare the following pairs of terms as used in object oriented software engineering: (i) Association and Association class (ii) Multiplicity and multiple

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