Test week 8: Due SUNDAY 06/02/2013

Name: ______________________________________

Using Word Table creation function, define the table description for the following SQL Scripts.
This is reverse of what we did in week 7. In week 7, you had the table description, then you created the table, now you have the script and you are required to write down the table description including table name and ALL its attributes (name, format, type, key, …) in a simple word Table format, like the ones I have given in the Table file in Week 7.

Each one the following is for 10 points, for total of 50 points.

Describe the table for each scrip under that script in the given space.

*** You DO NOT need to run script from SQL >, just review the Code, and define the corresponding Table description. Use word table. Please make sure that you have identified the keys, format of the fields, and constraints in your table description. No Code execution is requited for this task. ****

I suggest look at the Table file from week 7, and try to write your tables similar to those. Use Word Table to show your table description.

Question # 1 for 10 points:

CREATE TABLE MEMBER(
member_id NUMBER (10)
CONSTRAINT member_id_pk PRIMARY KEY,
last_name VARCHAR2(25)
CONSTRAINT member_last_nn NOT NULL,
first_name VARCHAR2(25),
address VARCHAR2(100),
city VARCHAR2(30),
phone VARCHAR2(25),
join_date DATE DEFAULT SYSDATE
CONSTRAINT join_date_nn NOT NULL)
/

Question # 2 for 10 points:

CREATE TABLE TITLE(
title_id NUMBER(10)
CONSTRAINT title_id_pk PRIMARY KEY,
title VARCHAR2(60)
CONSTRAINT title_nn NOT NULL,
description VARCHAR2(400)
CONSTRAINT title_desc_nn NOT NULL,
rating VARCHAR2(4)
CONSTRAINT title_rating_ck
CHECK (rating IN (‘G’,’PG’,’R’,’NC17′,’NR’)),
category VARCHAR2(20) DEFAULT ‘DRAMA’
CONSTRAINT title_categ_ck
CHECK (category IN…