"DJ" <nospamplease_at_goaway.com> wrote in message
news:ONo4b.2705$c12.33184_at_newsfep4-glfd.server.ntli.net...
>
> "gg70" <Gaseal3_at_aol.com> wrote in message
> news:7915866d.0308310743.1b154907_at_posting.google.com...
> > 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.
>
> you are joking right?
>
>
He wants you to do his homework. I do homework for $150 US per hour minimum
3 hours.
Jim
Received on Sun Aug 31 2003 - 11:07:36 CDT
