1. Use www.imdb.com (Links to an external site.) to find at least 6 titles for your movies table.
2. Create at least 6 fake records for your customers table.
3. You will add data to the rest of the tables based on what is loaded into customers and movies.

Table name: CUSTOMERS CUSTOMER_ID LAST_NAME FIRST_NAME HOME_PHONE ADDRESS CITY STATE EMAIL CELL_PHONE Column Name Key Type PK NN, U NN NN NN NN NN Not Null = NN Unique = U Data Type NUMBER VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 Length 10 25 25 12 100 30 2 25 12 Sample Data: Make up at least six members, using the sequence to generate the Pks: CUSTOMER_ID LAST_NAME FIRST_NAME HOME_PHONE ADDRESS CITY STATE EMAIL CELL_PHONE 101 Palombo Lisa 716-270-2669 123 Main St Buffalo NY palombo@ecc.edu 716-555-1212 Table Name: MOVIES TITLE_ID TITLE DESCRIPTION RATING CATEGORY RELEASE_DATE Column Name PK Key Type Not Null = NN Unique = U NN, U NN NN Check G, PG, PG13, NC17, M, R DRAMA, COMEDY, ACTION, CHILD, SCIFI, DOCUMENTARY, ROMCOM, WESTERN VARCHAR2 Data Type NUMBER VARCHAR2 VARCHAR2 VARCHAR2 DATE Length 10 60 400 4 20 Sample Data: Add at least six titles, use www.imdb.com for information and the sequence for the PKs: TITLE_ID TITLE DESCRIPTION RATING CATEGORY RELEASE_DATE 1 PG DRAMA 29-SEP-2000 Remember the Titans The true story of a newly appointed African-American coach and his high school team on their first season as a racially integrated unit. Table Name: RENTAL HISTORY MEDIA_ID RENTAL_DATE CUSTOMER_ID RETURN_DATE Column Name KeyType PK, FK1 PK FK2 NN, U NN NN Not Null = NN Unique = U Default Value SYSDATE FK Ref Table MEDIA CUSTOMERS FK Ref Column MEDIA_ID CUSTOMER_ID Data Type NUMBER DATE NUMBER DATE Length 10 10 Sample Data: Add four rows using MEDIA_ID from the MEDIA table and CUSTOMER_ID from the CUSTOMER table: MEDIA_ID RENTAL_DATE CUSTOMER_ID RETURN_DATE 92 19-SEP-2010 101 20-SEP-2010 Table Name: ACTORS Table Definition: ACTOR_ID STAGE_NAME FIRST_NAME LAST_NAME BIRTH_DATE Column Name Key Type PK NN, U NN NN NN Not Null = NN Unique = U Data Type NUMBER VARCHAR2 VARCHAR2 VARCHAR2 DATE Length 10 40 25 25 Sample Data: Add at least 4 rows, using the sequence to generate the Pks : ACTOR_ID STAGE_NAME FIRST_NAME LAST_NAME BIRTH_DATE 1001 Brad Pitt William Pitt 18-DEC-1963 Table Name: ROLES ACTOR_ID TITLE_ID COMMENTS Column Name PK PK Key Type Not Null = NN Unique = U NN NN FK Ref Table ACTORS MOVIES ACTOR_ID FK Ref Column Data Type Length TITLE_ID NUMBER NUMBER VARCHAR2 10 10 40 Sample Data: Add at least 4 rows, using ACTOR_IDs from the ACTORS table and TITLE_IDs from the MOVIES table : ACTOR_ID TITLE_ID COMMENTS 1001 2 Romantic Lead