XYZ Video Database System


Entity Relationship Diagram
ERD

Table Selections

Category Table - Movie Table - Zip Table - Member Table - Store Table - Inventory Table - Employee Table - Rental Table Rental Line Table


Database Queries
Zip Code Query Searches for members in the 43203-1214 zip code

 

Store 211 Query Searches for all employees employed at Store 211

 

Action Movie Query Searches for movies with an "Action" Description

Manager Report

Inventory on Hand Report


Database Views

Manager View Displays number of videos on hand by store id

 

 Data Entry View Displays members with an outstanding balance by member id
XYZ Video Database System. Red Team: Amy DeLong & Chris Lhamon for COMP281- Winter 2011.