Closed

Database programing ORACLE

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)

Skills: Database Administration, Database Development, Database Programming, Oracle, SQL

See more: oracle developer course, database programming course, oracle programming for beginners, oracle programming tutorial pdf, oracle programming examples, oracle programming pdf, oracle programming courses, oracle database, oracle sql ddl create table, database hospital using entity relationship diagram, design entity relationship diagram coursework database, oracle sql table ddl, table ddl oracle proc, database programing arabic web, database explorar oracle, database programing excel, database programming oracle web application server, oracle procedure ddl, database excel pivot table, customs clearance database design oracle

About the Employer:
( 2 reviews ) izmir, Turkey

Project ID: #17028671

55 freelancers are bidding on average €131 for this job

truongnguyen86

Hello there, i'm expert on database designing and implementation with Oracle, i've done many project on freelancer, you can check my profile to see. About the requirement i've done some title similar to yours with hosp More

€180 EUR in 3 days
(167 Reviews)
6.6
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
(28 Reviews)
4.9
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
(17 Reviews)
4.9
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
€155 EUR in 3 days
(39 Reviews)
5.2
€66 EUR in 1 day
(57 Reviews)
5.3
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)
4.9
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
(8 Reviews)
3.9
PiasKumarDas

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

€88 EUR in 3 days
(7 Reviews)
3.6
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
(4 Reviews)
3.5
€122 EUR in 3 days
(1 Review)
3.2
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
(5 Reviews)
3.3
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.6
€55 EUR in 2 days
(3 Reviews)
2.4
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
(4 Reviews)
2.4
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
€222 EUR in 2 days
(1 Review)
1.2
€250 EUR in 3 days
(0 Reviews)
0.0