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

Skills: Business Analysis, Oracle, SQL

See more: eddie ford clinic, sql code oracle, procedures oracle sql, procedures functions sql, procedures functions oracle, print attachments, sql functions procedures, oracle procedures functions, oracle functions sql, functions procedures oracle, comments oracle, code sql, oracle sql number, stored procedures, sql code, sql business, oracle pl, oracle data, oracle business, erd, business pl, sql question answers, sql scenario answers, design simple sql, sql required

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