Completed

Database implementation

You need to convert the entity relationship design into relational tables in the Oracle database environment. Add at least 10 rows of meaningful data into each table. Develop 8 SQL statements to produce meaningful query results from the data in the database to support business operations.

Queries conditions:

- Must use aggregate functions

- Must use ORDER BY

- Must use GROUP BY

- Must use more than tables

- WHERE clause using LIKE, IN, or BETWEEN

- Must use logical operators (AND, OR, NOT)

- Must use INSERT, DELETE, or UPDATE

Database implementation: Create tables, insert data, and create queries (new)

Tables must be in the 3NF.

i. Include data dictionary tables that list table name, attribute names, attribute description, data type, required, and foreign key referenced table.

ii. Include screenshots to show the data in the tables from SQL Developer.

iii. For each query, describe a business purpose of the query and include a screenshot that shows the query and its result.

iv. Attach SQL script files with the full report submission.

Beceriler: Veri Tabanı Yönetimi, Veritabanı Geliştirme, Veritabanı Programlama, Oracle, SQL

Daha fazlasını gör: create contact list access database 2007, create guest list database, create keyword list database, database implementation steps, database design and implementation process, how to implement a database management system, database implementation pdf, database system implementation, database implementation course, database implementation example, database implementation plan, mysql, oracle, create contact list database, create distribution list active directory database, business operations support administrator, create address list fake database, joomla database report, school database report, asp access database report

İşveren Hakkında:
( 1 değerlendirme ) Auckland, New Zealand

Proje NO: #15425732

Seçilen:

pratik123

hi I can surly provide you desired result within timeframe. please share e-r diagram. thanks.

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
0.9

Bu iş için 32 freelancer ortalamada $51 teklif veriyor

fanninson45

I'm a database programmer who can support, develop and administer various databases. I code, update, debug and responsible for the integration of web technologies such as: Apache, PHP, JAVA and ASP Relevant Skills and Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
5.6
it2051229

HI I went through the requirements and I would like to see the database design that needs to be converted to oracle. Let me know if you are interested. Thanks. Relevant Skills and Experience Oracle, SQL, Database Pro Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(90 Değerlendirme)
5.5
prakash2813

Hi there, I have read the details, its an easy job for me. I have strong knowledge in plsql, dynamic sql, pivot tables, normalization (1NF, 2NF, 3NF, BCNF), umls and much more. Message me, Relevant Skills and Experien Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(16 Değerlendirme)
4.9
PATechnology

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde31%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
3.9
whitehorsetechn

Greeting, I have understood your Database implementation task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(1 Yorum)
2.0
asharfraz

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde31%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(2 Değerlendirme)
1.8
ouarkaayoub

Hello Client, i am really interested in your project, i want to discuss with you more details. Expérience et Compétences appropriées Oracle database; Étapes proposées $26 NZD - Complete task please come on chat for Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(2 Değerlendirme)
1.3
asoliman1984

. Relevant Skills and Experience . Proposed Milestones $14 NZD - milestone

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(1 Yorum)
0.4
in %bids___i_period_sub_35% gün içinde27%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)
0.0
mohamedk

Hi, I hope to see my bid. I have more then seven years of experience in Oracle SQL, PL/SQL field, so I can help you to achieve your target. Relevant Skills and Experience Oracle Developer. PeopleSoft Developer. Oracle Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)
0.0
consultkasyap

I am a certified Oracle PLSQL Developer Associate. Relevant Skills and Experience Oracle, SQL, PL/SQL Proposed Milestones $28 NZD - Completing the Job description related queries and screenshots. What is the need by Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)
0.0
anshul27singla

I have been working on database queries from past 7 years. Created a lot of complex queries

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)
0.0
thamer19802

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Aarish92

I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. We are the team of 6 experienced [login to view URL] our team,2 members are OCP certified. Relevant Skills and Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)
0.0
beaiva

Hello. I have a BS in Computer I formation Systems and Orqcle certified DBA.

in %bids___i_period_sub_35% gün içinde777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
shiva31kusuma

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde28%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
avetba

I will deliver this work the next day after you go decision. Relevant Skills and Experience Experienced DB programmer, enterprise level solutions. SQL and Oracle skills. Proposed Milestones $16 NZD - Full work comple Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)
0.0