Oracle9i Questions

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. Received on Sun Aug 31 2003 - 10:43:29 CDT