Re: Oracle9i Questions

gg70 wrote:

> Please answer the following if you can.
>
> 1. Given the following Table Name: Publisher and Table Publisher
> Constraint: Pub_ID is a PRIMARY KEY, Pub_ID varchar2(3), Pub_Name
> varchar2(20) and Pub_Phone varchar2(12). What is the command to
> create and insert some information into this table?
>
> 2. Given a Table Name Authors, and Table Authors Constraint -
> Author_Id is a PRIMARY KEY. Author_ID number(3) Auth_Name varchar2(15)
> and Auth_phone varchar2(12). What is the command to create and insert
> some information into this Table?
>
> 3. Given a Table Name Books, and Table Books Constraints:
> ISBN is a PRIMARY KEY
> Pub_id is a FOREIGN KEY AND NOT NULL
> Price should be checked so that its price does not exceed $99.00
> and NOT
> NULL.
> Title should not be NULL
> ISBN Varchar2(13), Title Varchar2(20), pub_id varchar2(3) and Price
> Number(5,2)
> What is the command to create and insert some information into this
> table?
>
> 4. Given a Table Name Bk_Author, and Table Bk_Author Constraints:
>
> ISBN is a foreign key should not be NULL
> Author_ID is a foreign key and should not be NULL
> ISBN Varchar2(13),Author_ID Number(3)
> What is the command to create this table and insert some information
> into this table?
>
> 5. Given the Table Name: Bk_Author and Table Bk_Author Constraints:
> ISBN is a foreign key should not be NULL
> Author _ID is a foreign key and should not be NULL
> ISBN Varchar2(13) and Author_ID Number(3).
>
> What is the command to create and insert some information into this
> table?
>
> Thanks.

Assuming your posting is not a joke it is offensive.

Drop the class and apologize to the instructor for wasting his or her time.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)