Project Description:
Requirements:
Initial Notes:
** I have attached all Scenario: Eddie Ford Clinic, If you need any information please ask me
** I already design the Entity Relationship Diagram (ERD):
** I have attached a simple assignment
** Works have to done by one day please.
** Must have to use Oracle SQL Plus
** Need create Table with 5 insertion data for each table
** Create table WITHOUT PRIMARY KEY, take screen print and save BEFORE doing the ALTER TABLE code to include the PRIMARY KEY.
** Answers the all questions as number (b) (See the Attachments please.)
b) Appropriate use PL/SQL (Oracle only)
SQL answers/output to the end user's question. Stored procedures, functions, triggers etc, will be required in order to complete the business requirements. Comments should appear in the PL/SQL procedures, functions, triggers or anonymous block'' and will be required.
Snap shots of every PL/SQLs and result must be included.
-------------------------------------------------------------------------------
If you understand the requirements then bid please... otherwise please....
Additional Project Description:
10/23/2011 at 11:54 SAST
I have attached all Scenario: Eddie Ford Clinic