Question: QUESTION 1 Consider the following three tables from the Microsoft Access database created for the consumer organisation LOYALTY. Assume that Referential Integrity has been enforced

QUESTION 1 Consider the following three tables from the Microsoft Access database created for the consumer organisation LOYALTY. Assume that Referential Integrity has been enforced on the relationships between the tables. McKee Steve 5 Sunline St Seaview 5045 131101198 2 600066 Hamison Mr Steve 6 Crows Cres Croydon 5054 331101199 7568 3 70007? Ponting Fro Ricky 7 Power PI Plympton 5046 221021200 6454 4 800088 Hawn Ms Goldie '8' Hollywood CIHollywoo 407B $103119? 5637 wy 5 900099 Harpy-Williams Ms Kathry 9 Netball Ave Netley n 151031199 5014 8 Tl l-' Adelaide Melbourne 2 5102 F Adelaide - Sydney 1250 3 5103 F Adelaide - Brisbane 2150 4 5104 F IAdelaide - Damin 2350 5 5105 F Adelaide - Hobart 1400 6 5106 F Adelaide Perth 1950 7 5401 R IJclleys Adelaide 800 8 5402 R IGekkos Adelaide 850 9 5901 A Stamford Adelaide 900 A Hilton Adelaide '600066 5402 0210812005 70007? 5105 0210812005 1400 100077 5103 0810812005 2150 '800088 0410812005 900099 0210812005 U'l-hLONH (1) By selecting specic example records in the AWARDS and REDEMPTIONS tables, carefully explain the nature of the relationship between AWARDS and REDEMPTIONS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Use duality theory directly to determine whether the current basic solution remains optimal after each of the following independent changes. (a) The change in part (e) of Prob. 6.7-1 (b) The change...

Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Create the wb.accdb database with the following two tables... To perform the following projects, you will need a computer that has Microsoft Access installed. If you have no experience working with...

Create the WP.accdb database with the following two tables: All the information from the book has been provided. To perform the following projects, you will need a computer that has Microsoft Access...

send me a solution report with Microsoft access and word Introduction Business Description: Baer Belly Bikinis, Inc. (BBB) is a small business located in Santa Monica, California founded by Paige...

ASAP PLS Data Management: Entity Relationship Diagram \& MS Access (50 Marks) a. Draw the ERD of the database that could be used to support the operations of the business described in the case ( 20...

VOIM220 - Office Technology Software III Portfolio Project Directions This Assessment is worth 20% of your overall grade. Completing this Assessment will help you to meet the following: Course...

BAER BELLY BIKINIS SALES TO RETAILERS please help me with my project. check the files attached Introduction Business Description: Baer Belly Bikinis, Inc. (BBB) is a small business located in Santa...

INFO 31787 Accounting Information Systems MS Access Project 1 - Designing and Creating an MS Access Relational Database Baer Belly Bikinis' Value This assignment is evaluated out of 30 marks and is...

Database question Project 1 Objectives : Learn how to design, normalize and implement relational databases. Tools: MS Visio 2013, MS Access 2013. Description: Study Chapters 1-4. Study the following...

Suppose that a family is leaving on a summer vacation in their camper and that M is the event that they will experience mechanical problems, T is the event that they will receive a ticket; for...

D-2 A Local Application of Local Time Most people will have never actually used local time, or even be aware of it. But prior to 1883 when the United States adopted a Standard Time system, most U.S....

Without your calculator, evaluate the following: l n ( 1 ) l o g ( 1 0 ) l n ( e 3 ) The following statements are FALSE. Correct them to make them TRUE. l n ( A * B ) = l n A * l n B l n ( A B ) = l...

Mills Corporation acquired as a long-term investment $240 million of 6% bonds, dated July 1, on July 1, 2018. Company management has the positive intent and ability to hold the bonds until maturity....

Stockholders Equity Section of the Balance Sheet The newly hired accountant at Grain field Inc. is considering the following list of accounts as he prepares the balance sheet. All of the accounts...

On January 1, 2010, Yadier Inc. had the following stockholders equity account balances. Common Stock , no-par value (500,000 shares issued) .... $1,500,000 Common Stock Dividends Distributable...

Alexander Corporation reports the following components of stockholders' equity on December 31, 2015: Common stock-$25 par value, 50,000 shares authorized, 30,000 shares issued and outstanding . . . ....

The following selected transactions relate to liabilities of United Insulation Corporation. United's fiscal year ends on December 31. Required: Prepare the appropriate journal entries through the...

Which of the following statements about cultural differences in negotiations is FALSE? a. Chinese negotiators were less likely to use compromising. b. It is easy for high-context and lo-context...

1. To take in the necessary information,

7. Find four examples that illustrate the statement: Beyond a certain point, open-ness regarding information and communication can become detrimental to relationships.

2. In this chapter, the reader should reflect on the following concepts: