Database programing ORACLE

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

Table of Contents (ABOUT HOSPİTAL DATABASE)

1. Introduction .......................................................................................................................... Page# 1.1. Project Scenario ......................................................................................................................

2. Entity Relationship Diagram.........................................................................................................

3. Relational Model .............................................................................................................................

4. SQL ...................................................................................................................................................

4.1. Create table statments .............................................................................................................

4.2. Insert statements......................................................................................................................

4.3 Update statements ...................................................................................................................

4.4. Delete statements.....................................................................................................................

4.5. Alter table statments................................................................................................................

4.6. Drop table statments...............................................................................................................

4.7. SQL Queries.............................................................................................................................

5. Conclusion..........................................................................................................................................

6. References ........................................................................................................................................

You are to create a script that will include all SQL (DDL, DML, DCL, TCL) commands that should cover the following:

 Drop table statements

 Create table statements (all tables should be created)

 Alter table statements (3 – 5)

 Insert statements (at least 3 into each table)

 Update statements (at least 3)

 Delete statements (at least 2)

 SQL Queries (at least 3)

Database Administration Database Development Database Programming Oracle SQL

Project ID: #17028671

About the project

51 proposals Remote project Active 5 years ago

51 freelancers are bidding on average €134 for this job

prakash2813

Hi there, I have strong expertise in Oracle plsql, procedures, functions, pivot tables, dynamic sql, umls, normalization and more. I just read the details and its an easy job for me. Message me, I would like to disc More

€180 EUR in 3 days
(23 Reviews)
5.3
nyarOnyari

Hello, I have read your project description about Database programing ORACLE and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have al More

€99 EUR in 3 days
(37 Reviews)
5.0
point5nyble

Hello, I have been working as an IT BI DWH Professional since last ~ 7 years and have very vast experience around all its 3 layers (ETL, DWH & Reporting) including ER Dimensional Modelling. Below are some key are More

€111 EUR in 3 days
(49 Reviews)
5.2
jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili More

€100 EUR in 2 days
(30 Reviews)
4.9
mdakteruzzaman

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here More

€111 EUR in 3 days
(26 Reviews)
5.0
ashwanii

Hello Project Owner, Greetings of the day! I am interested to work on the Project! Please can you share more details. Regards, Ashwani

€111 EUR in 1 day
(2 Reviews)
4.1
diegofpr

Hello, could you share the full document of what you are requiring? Is it just the coding of the SQL instructions, or do you need the modelling part and such? Thanks.

€50 EUR in 1 day
(9 Reviews)
3.9
minorsamwah

Hello, I am a Data Scientist who has over three years experience in Data Analytics Using SQL, Excel and Power BI. I have a Background in Database, Economics and Statistics. I do deliver the projects on time based o More

€166 EUR in 3 days
(6 Reviews)
3.9
PiasKumarDas

....................................................................................make milestone..............................................................................................make milestone............ More

€88 EUR in 3 days
(11 Reviews)
4.1
asif2478

hi there! I am an expert in oracle database programming and design. I have already completed similar projects here. You can check my profile reviews for proof. I shall provide you the MOST OPTIMIZED DATABASE DESIGN More

€155 EUR in 2 days
(5 Reviews)
3.3
Appsdbatalha

A proposal has not yet been provided

€277 EUR in 3 days
(5 Reviews)
2.6
rutahgandhi

Hi I am an oracle developer in an mnc. I have experience with database and I can do it in a day and without any errors. The work seems quite easy.

€50 EUR in 1 day
(2 Reviews)
2.7
pratik123

Hey hi looking forward to contact you soon.

€277 EUR in 3 days
(1 Review)
1.6
ellenutza

Hello, My name is Elena and I am a certified Oracle developer. If you need more information regarding my work or experience please let me know. Hope to hear from you soon. Have a nice day, Elena

€155 EUR in 2 days
(3 Reviews)
1.7
KashifAlei

Hi there i would like to do your task, i have vast experience in Database design and development of arround 2 to 3 years if given chance i am sure i won't let you down.

€100 EUR in 2 days
(0 Reviews)
0.0
irfanzafar1

Hi there I will make Database with ORACLE as you explained here. I will do this work within 3 days. I am an MSc degree holder in IT with over 7 years of development experience. If you want to ask any question, kind More

€175 EUR in 3 days
(0 Reviews)
0.0
zmp85

Hi, I am interested in the project. I have experience with Mysql, MS sql server,oracle, mongodb, dynamodb. I have 5+ years of experience in Java/J2EE, Spring, JQuery, AngularJS, HTML, CSS, Microservices, Hibernate More

€250 EUR in 20 days
(0 Reviews)
0.0
loyel

Hello, This is in response to your job notification for the position of Professional for your project. I have been working as a developer for the last 6+ years with a software firm and mentioned below are som More

€50 EUR in 2 days
(1 Review)
0.0
SundariSakthi

Having 15+ years of experience in Oracle SQL & PL/SQL. Have created complex queries and implemented complex logic in PL/SQL. Created multiple re-runnable scripts for projects.

€100 EUR in 4 days
(0 Reviews)
0.0
sanjeevbehera88

I have a extensive experience working with databases, i have good knowledge of writing complex queries, procedures, functions, triggers in SQL/PL SQL, i am also aware of the SQL language basics along with good grasp in More

€77 EUR in 3 days
(0 Reviews)
0.0