CSC 436 - Assignment #2
PostgreSQL
Humungo Video Stores Database Relations
FILM(FNUM, TITLE, OPENED, LENGTH, BUDGET, DIRECTOR, SNUM,
RATING, WRITER)
- SNUM is a foreign key to STUDIO
ACTOR(ANUM, FNAME, LNAME, BDATE, GENDER)
ROLES(FNUM, ANUM, PART, SALARY)
-
FNUM is the film number - foreign key to FILM
-
ANUM is the actor number - foreign key to ACTOR
STUDIO(SNUM, NAME, ADDRESS, WEBSITE)
ITEM(INUM, FNUM, PRICE, RELEASE, FORMAT, BONUS, INVENTORY)
-
FNUM is a foreign key to FILM
SHOPPER(SHNUM,FNAME, LNAME, SHIPADDR, CRCARD)
CART(SHNUM, INUM, QUANTITY)
-
SHNUM is a foreign key to SHOPPER
- INUM is a foreign key to ITEM
Primary keys are underlined.