Assignment 6

Answer the following questions based on your reading of the notes. Use WordPerfect to type up the questions and answers, label clearly and type your name to hand in.

Why relate tables?

Why not create one large table with all the data in it?

What objects can use data from related tables?

How are relationships between tables set up?

We need to keep track of paying the players, keeping game states, making game programs. Make up an example of a one-to-many relationship, that could be made in managing our hockey team. Using the table that we have made in class, include other tables you could make and explain how to relate them.

What is the purpose of a junction table?

A one-to-one relationship is uncommon, because this data con usually be stored in one table. Give reasons for using this relationship.

Do the following using Access:

1. Create a new table called GameInfo. Remember to change the Properties of the fields not the description.

Filename	Type	Properties
ID	AutoNumber	<no changes>
PlayerID	Number	Field Size = Long Integer; Format = Fixed; Decimal Places=0; Required =Yes
GameNum	Number	Field Size = Byte; Forma t= Fixed; Decimal Places=0; Required = Yes
Goals	Number	Field Size = Byte; Format=Fixed; Decimal Places=0
Assists	Number	Field Size = Byte ;Format=Fixed; Decimal Places=0

Click on Tools, Relationships. Add the PlayerInfo table (this is the one relationship), then add the GameInfo table (this is the many relationship). Using the mouse, drag the field PlayerID from the PlayerInfo table onto the PlayerID field of the GameInfo table. Close the relationships dialogue box and save it. It will not get you to name anything.

Create a new Select Query. Add both the PlayerInfo and GameInfo tables. Close the Show Tables window. Add the fields shown from their respective tables. Last and First names should have a sort property added. Save this Query with the name GameScore.
Create a new form. This time choose the Form Wizard and select the GameScore query as the data source. Click OK. Then click on , to select all the fields. Click on Next. Set up the next window as shown on the next page, then click Next.

wpe3.jpg (12181 bytes)

Choose the DataSheet option and click on Next.
Choose the Standard option and click on Next.
Name the Form GameScore and the Subform as GameScore Subform then click on Finish.

Enter the following data using this form. To change the player click on the button at the bottom. Add the data into the grid as shown in the example below:

Record #1 FIRSTNAME Luc LASTNAME Tremblay Goals Assists GAME 1 1 2 GAME 2 0 1 GAME 3 0 1	Record #2 FIRSTNAME Claude LASTNAME Benoit Goals Assists GAME 1 0 0 GAME 2 0 0 GAME 3 1 1	Record #3 FIRSTNAME Jean-Marc LASTNAME Perron Goals Assists GAME 1 2 0 GAME 2 0 1 GAME 3 1 1	Record #4 FIRSTNAME Eric LASTNAME Roy Goals Assists GAME 1 0 0 GAME 2 0 1 GAME 3 0 0
Record #5 FIRSTNAME Yvan LASTNAME Dube Goals Assists GAME 1 0 1 GAME 2 0 0 GAME 3 0 2	Record #6 FIRSTNAME Barney LASTNAME Rubble Goals Assists GAME 1 2 2 GAME 2 3 1 GAME 3 1 1	Record #7 FIRSTNAME Christian LASTNAME Champagne Goals Assists GAME 1 0 0 GAME 2 1 1 GAME 3 0 1	Record #8 FIRSTNAME Fred LASTNAME Flintstone Goals Assists GAME 1 1 0 GAME 2 0 1 GAME 3 0 1
Record #9 FIRSTNAME Luc LASTNAME Charbonneau Goals Assists GAME 1 0 2 GAME 2 0 3 GAME 3 3 2	Record #10 FIRSTNAME Super LASTNAME Man Goals Assists GAME 1 0 0 GAME 2 0 0 GAME 3 0 0	Record #11 FIRSTNAME Craig LASTNAME Stuart Goals Assists GAME 1 1 0 GAME 2 0 0 GAME 3 1 0	Record #12 FIRSTNAME Spider LASTNAME Man Goals Assists GAME 1 0 0 GAME 2 0 0 GAME 3 0 0
Record #13 FIRSTNAME Wayne LASTNAME Gretzky Goals Assists GAME 1 0 2 GAME 2 0 1 GAME 3 6 1	Record #14 FIRSTNAME Brett LASTNAME Hull Goals Assists GAME 1 0 0 GAME 2 0 0 GAME 3 0 0	Record #15 FIRSTNAME this is yours LASTNAME this is yours Goals Assists GAME 1 2 0 GAME 2 0 2 GAME 3 1 0	Record #16 FIRSTNAME this is yours LASTNAME this is yours Goals Assists GAME 1 0 1 GAME 2 2 0 GAME 3 0 3
Record #17 FIRSTNAME Tony LASTNAME Sanduskyt Goals Assists GAME 1 0 0 GAME 2 1 0 GAME 3 0 1	Record #18 FIRSTNAME Conrad LASTNAME Porchenko Goals Assists GAME 1 0 0 GAME 2 0 0 GAME 3 0 0	Record #19 FIRSTNAME Will LASTNAME Nestor Goals Assists GAME 1 0 0 GAME 2 0 0 GAME 3 0 0	Record #20 FIRSTNAME Steven LASTNAME Lofter Goals Assists GAME 1 0 0 GAME 2 0 0 GAME 3 0 0

Design a new report using the Report Wizard, select the GameScore query. Select all the fields. Accept all the defaults given. When you are asked for Style choose Soft Gray. Name the report Game Scoring Summary.