"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:c3p4b.140650$2x.39952_at_rwcrnsc52.ops.asp.att.net...
>
> "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
>
>
bargain :-)
Received on Sun Aug 31 2003 - 12:12:21 CDT
