In Progress

Oracle SQL

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....

I have attached all Scenario: Eddie Ford Clinic

Skills: Business Analysis, Oracle, SQL

See more: eddie ford clinic, sql to oracle, sql oracle pl sql, sql in pl sql, sql code oracle, procedures in oracle pl sql, procedures and functions in pl sql, procedures and functions in oracle, print all attachments, pl sql in oracle, pl/sql functions and procedures, pl sql functions and procedures, pl sql and oracle, pl sql and, oracle sql pl, oracle procedures and functions, oracle functions sql, if oracle pl sql, functions and procedures in oracle, for in pl sql, for i in oracle pl sql, for all in pl sql, comments oracle, code pl sql, pl sql oracle

About the Employer:
( 39 reviews ) Newcastle Upon Tyne, United Kingdom

Project ID: #1260329

Awarded to:

rakib062

Hi, I am working as a database admin and designer for 7+ years in oracle. I have hands on experience in oracle 10g and 11g in creating complex database, pl/sql query, stored procedure and triggers. I have gone through More

$50 USD in 1 day
(5 Reviews)
3.3

4 freelancers are bidding on average $38 for this job

hitgon

DBA and Developer

$30 USD in 0 days
(1 Review)
1.0
y2krome1

Hello, Please care to view PMB.

$40 USD in 0 days
(0 Reviews)
0.0
gajera

Hi, I am Oracle certified Programmer and also working as a Pl/Sql developer. I am able to do this project in one day. Hoping for the positive response from your side.

$30 USD in 1 day
(0 Reviews)
0.0