Draw an entity access matrix for the given case study

Assignment Help Other Subject
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)

(c) Discuss the merits of not including the price of the item in Entity 5 Order Line

(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

Reviews

Write a Review

 

Other Subject Questions & Answers

  Prepare a poster about auditing for casemix

Prepare a poster about Auditing for Casemix

  What is the importance of the toe board

What is the importance of the toe board What are the main Personal Protective Equipment that are usually required in a construction site, stating the purpose of each one

  Uses of ionising radiation

What are the main differences between ionising radiations and non-ionising radiations. Uses of ionising radiation

  What is meant by health risk assessment

What is meant by health risk assessment Describe the different ways in which chemical hazards may exist Describe the main types of hazard which arise from the use of chemicals

  Agents that can cause respiratory problems at the workplace

Name five agents That can cause respiratory problems at the workplace What can you derive from the history of the worker on the nature of the responsible agent

  What do you understand by workers compensation

What do you understand by Worker's compensation Social and economic problems which led to the passage of the first Worker's compensation laws

  How legal concepts interact

Explain whether Australian contract law should or should not provide greater clarity as to what is or is not sufficent consideration.

  Describe the various costs associated with inventory control

Describe the various costs associated with inventory control Define Economic Order Quantity (EOQ) and outline the assumptions of the basic EOQ Model

  How would you go about measuring the level of radiation

What do you understand by the term external and internal radiation? List down the health effects associated with each of them How would you go about measuring the level of radiation

  State the purpose of a fire log book

Describe the typical content of a fire safety training session for the employees State the purpose of a fire log book

  Case study using rationale diagram

Use information from the article/case study, other sources discovered during your research, and your own reasoned arguments

  Execution of a simple marie program

Complete a similar example for a different program n particular, for the MARIE program.

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