Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Assignment help

Re: Assignment help

From: EdStevens <quetico_man_at_yahoo.com>
Date: 2 Dec 2005 09:42:54 -0800
Message-ID: <1133545374.883597.128290@g49g2000cwa.googlegroups.com>

Thomas wrote:
> Need help on my assignment.... I have finished all ecept the sqlquestion. I
> have created an ms access tables but need it in Oracle SQL. Please help
>
> The question is as below
>
> 6. Define normalised relations as SQL tables enforcing all apllicable
> integrity constraints ans populate the tables with relevant data. The
> following is required:- SQL code + final data Set (Presented in an appendix)
>
> 7. Design the transaction "remove driving licence categoray X from the
> system" and code it in SQL
>
> 8.Design and code the query " Find out the details of the candidte who have
> yet to pass the test (i.e Persons repeating the test and without positive
> result)
>
> For 6,7&8 Implementation on oracle database is COMPULSORY: Therefore screen
> dump must be added in appendix.
>
> For 6&8 the following are required
> a. specification of pre and post conditions
> b. definition of input and output
> c. processing logic and the SQl code
> d. illustrative test run
>
>
> Please help i have the database in Ms access

What kind of help are you asking for? No one is going to do your homework for you. If you have a specific question about a specific problem, post it. Received on Fri Dec 02 2005 - 11:42:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US