Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Assignment help
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
![]() |
![]() |