"DJ" <nospamplease_at_goaway.com> wrote in message
news:Y%p4b.2838$bC1.2110_at_newsfep4-winn.server.ntli.net...
>
> "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 :-)
>
>
No takers yet. But they stop posting real fast. I am waiting for one of
them to post with an email address like
joe.schmoe_at_some_college.edu
<grin>
Jim
Received on Sun Aug 31 2003 - 12:37:42 CDT
