Draw an entity access matrix for the given case study

Reference no: EM132794

QUESTION 1

(a) Draw a Level 1 Data Flow Diagram for the given Case Study

(b) Cross validate the DFD with the event model and data models given. (Tip: Identify events which are contained in the processes and identify entities contained in the data stores)

QUESTION 2

(a) Draw an Entity Relationship Diagram for the given case study. Show entities and relationships on the diagram (attributes need not be shown)

(b) Describe a redundancy in the given data model. Explain how the information can be obtained in a different way (exclude redundancies which are foreign keys used to implement relationships)

(d) The current case assumes that only one table is allocated to a reservation. Modify the data model to allow for many tables to be allocated to a reservation

QUESTION 3

(a) Draw an Entity Access Matrix for the given case study

(b) Give an example of an entity which seems to have an incomplete life history. Justify your answer

(c) Document ONE new event which might complete the life of the entity mentioned above. Specify what effect the event has on the specific entity mentioned

(d) Give an example of an event which seems to be outside the scope of the system. Justify your answer

(e) Draw an Entity Life History for the Entity E1 Customer

(f) Draw an Effect Correspondence Diagram for the event EV3 New Reservation Processing

Reference no: EM132794

Questions Cloud

Explain the supply chain of milk : Explain the supply chain of milk

Overriding objective of railway management system : Overriding objective of railway management system

What do you understand by the agency problem : (a) What do you understand by the agency problem (b) What is meant by moral hazard and adverse selection (c) How do the terms in (b) above complicate the agency problem

Examine walking is most sustainable form of transport : Examine walking is most sustainable form of transport

Draw an entity access matrix for the given case study : Draw an Entity Access Matrix for the given case study Give an example of an entity which seems to have an incomplete life history. Justify your answer Document ONE new event which might complete the life of the entity mentioned above. Specify ..

How warehouses can add value in the supply chain : How warehouses can add value in the supply chain

Justify component of the recruitment campaign : No errors should be found while testing software. The presence of errors is a proof of the poor quality of the software Devise a recruitment campaign to attract the best talent for the above mentioned job. Use different techniques and justify eac..

Classify logistics : Classify logistics

User Account

All Pages