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

Illustrate the concept of a software bus in corba, QUESTION (a) Illustr...

QUESTION (a) Illustrate the concept of a software bus in CORBA (b) Taking an example of your own, explain how component-based software engineering can allow very rapid softw

Classify the techniques into dynamic or static, Classify the below techniqu...

Classify the below techniques into dynamic or static. i. Data Flow Analysis. ii. Use Case Testing. iii. Equivalence Partitioning. iv. Exploratory Testing. v. Inspec

Determine the system evolution of life cycle process, System evolution of l...

System evolution of life cycle process The lifetime of verge systems is too long. They must evolve to meet change requests. The evolution may be expensive. Existing sy

Encryption models, Please name some of the best (most successful) encryptio...

Please name some of the best (most successful) encryption models for use in the business community. I need to know the benefits and disadvantages of each, as well as the cost effec

What do you mean by static analysers, Q. What do you mean by Static analyse...

Q. What do you mean by Static analysers? Static analysers A static analyser operates from a pre-computed database of descriptive information derived from the source text of t

Why we use coverage analyzers, Q. Why we use Coverage analyzers? Cover...

Q. Why we use Coverage analyzers? Coverage analyzers (execution verifiers) A coverage analyzer is the most common and important tool for testing. It is often relatively simpl

What does validation represent, What does Validation represent? Validat...

What does Validation represent? Validation show the set of activities that make sure that the software that has been built is satisfying the customer requirements.

What is class level methods, What is Class Level Methods? Ans) A class (...

What is Class Level Methods? Ans) A class (and its operations) is the module mainly concentrated on in OO environments. From here it should increase to other classes and sets of

Produce a use case diagram, ZeroJet, a new low cost airline, wants a brand ...

ZeroJet, a new low cost airline, wants a brand new web-based system to allow people to book seats for flights on-line.  They want an automated check in system which has no staff.

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