Class Schedule
22 AUG | intro
27 AUG | clients
29 AUG | servers
05 Sep | networks
10 Sep | basics lab
12 Sep | structural layer
17 Sep | presentational layer
19 Sep | working with layers
24 Sep | behavior layer
26 Sep | images & design
01 Oct | website lab
03 Oct | object layers
08 Oct | graphics
10 Oct | document markup lab
15 Oct | spreadsheets
17 Oct | formulas & functions
22 Oct | thoughts about data display
18 Oct | Fall Break
24 Oct | database tools
29 Oct | spreadsheets lab
31 Oct | relational databases
05 Nov | tables
07 Nov | relationships |
05.02 |
next session
12 Nov | input & output
14 Nov | SQL
19 Nov | complex queries
26 Nov | databases lab
21 Nov | Thanksgiving
28 Nov | presentation design
03 Dec | presentation delivery
05 Dec | presentation lab
12 Dec | 0800-1100 | final in class presentation
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
Relate your tables by ensuring referential integrity between Primary Keys and Foreign Keys.
Use the lookup wizard on the Foreign Keys to allow the program to create the relationships for you.
These do not have to be turned in, but they will be needed during the subsequent sessions.
You will need to decide whether or not you need to create a one-to-many or a many-to-many relationship between the Orders table and another table
Let's establish some rules for this database that may assist in deciding the relationships
Mr. Pitt, our client, wants to be involved in every purchase order for his library, but he doesn't like to think about complex things
However, you only have to do this in regards to the Order table. You must decide what field in the Order table is the FK and what PK in another table it should be related to
Your task is to decide on the relationship and link the related fields
but in Access you must create the many-to-many relationship by creating an intervening table and relating the Book and Author tables to it as two separate one-to-many relationships
The intervening table has its own Primary Key for each new record and also contains copies of Primary Keys of the two related tables, inserted in the intervening table as Foreign Keys
this intervening table will allow the two original tables to relate to each other in a Many-to-many relationship