meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer |
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display
19 Mar | database tools
21 Mar | spreadsheets lab
26 Mar | relational databases
28 Mar | tables
02 Apr |
relationships |
05.02 |
next session
04 Apr | input & output
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 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 graded now, 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