110A Lect 8 relationships

110A Lect 8 relationships - Primary Keys, Foreign Keys,...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Primary Keys, Foreign Keys,  Relationships and Referential  Integrity Use Customer_Orders_In_Class  Database
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Review: Creating a Table  Create a new Access database from start Create 1 table for a library to track its  movies with the following fields MovieID,  MovieName,  Genre,  Rating,  RentalPeriod (1, 3, or 7 day rental) Populate your table with 3 movies.  Use  movie id’s: 1001, 1002, 1003
Background image of page 2
Primary Keys PRIMARY KEY:  It is a field (or combination of fields) that makes each record in a table  unique. Every table must have a primary key and each record must have a unique  value as its primary key. If you don’t specify one, Access will create it for you! Primary  keys
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Preliminary entity diagrams for  invoicing design Relationships depicted: One customer places many orders One order contains many products One product is contained on many orders Orders Products Customers 1 places Contains
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2010 for the course BUS 110A at San Jose State.

Page1 / 12

110A Lect 8 relationships - Primary Keys, Foreign Keys,...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online