Завершено

SQL small project

SUBMIT IN A WORD DOCUMENT FORMAT, DON’T USE SQL CODE

1. Use Oracle Database Management System Interface to create the following tables:

• Customer Table with the following columns:

1. CustomerNumber as number with precision 10 and scale 0 not null

2. CustomerName as a varchar2 with size 30 and not null

3. Address

4. City

5. State

6. ZipCode

7. Phone

With CustomerNumber as the primary key

• Order Table with the following columns:

1. OrderNumber as number with precision 10 and scale 0 not null

2. Date as number not null

3. Subtotal as number with precision of 10 and scale of 3 null

4. Tax as number with precision of 10 and scale of 3 null

5. Total as number with precision of 10 and scale of 3 null

6. CustomerNumber as number with precision of 10 and scale of 0 not null

With OrderNumber as the primary key and CustomerNumber as a foreign key

• Item Table with the following columns:

1. ItemNumber as number with precision of 10 and scale of 0 not null

2. UnitPrice as number with precision of 10 and scale of 3 null

3. Description as varchar2 with size 100

With ItemNumber as the primary key

• Order_Line_Item Table with the following columns:

1. OrderNumber as number with precision of 10 and scale of 0 not null

2. LineNumber as number with precision of 10 and scale of 0 not null

3. Quantity as number with precision of 10 and scale of 0 not null

4. UnitPrice as number with precision of 10 and scale of 3 not null

5. Extended Price as number with precision of 14 and scale of 3 not null

6. ItemNumber as number with precision of 10 and scale of 0 not null

With LineNumber as primary key

ItemNumber and OrderNumber as foreign keys

2. INSERT at least three rows into each table.

3. Add CHECK constraints to limit the City in CUSTOMER table to be within the following group only (Orlando, New York, Atlanta, Charlotte, Detroit)

4. Add a column to the CUSTOMER table called email

5. Use Oracle to create a report about the different columns in the created tables.

Notes:

• You don’t need to write the SQL code for this

• Provide a snapshot from Oracle for (the tables that you created, the tables including the data that you inserted, The tables constraints specially for the customer table after adding the check constraints, the customer table after adding the new column, and the report about the different columns)

• SUBMIT IN A WORD DOCUMENT FORMAT

• To copy paste the snapshots from Oracle use the buttons (Alt) and (Print Screen), simultaneously, on your keyboard then paste into word

Квалификация: Управление базами данных, Разработка баз данных, Программирование баз данных, Oracle, SQL

Показать больше small project language, add project job number email outlook, small project online sql, database project examples, sql projects reddit, sql projects online, sql server projects, sql projects github, sql projects for practice, sql project on banking, sql projects for resume, small project sql, small sql database project, small project sql queries, small project vfp backend sql, oracle sql small project, small microsoft word project, advanced business information technology project word limit, small project using sql server, need small project done sql download

О работодателе:
( 18 отзыв(-а, -ов) ) port orange, United States

ID проекта: #19149507

Поручен:

bhupen2606

Hi, i have good experience with Oracle SQL. i have understood your requirement and can provide the results in word document. Let me know if you would like me to work on this. Thanks.

$25 USD за 1 день
(23 отзывов(-а))
4.2

8 фрилансеров(-а) в среднем готовы выполнить эту работу за $32

hardikshah83

I can create this database for you in Oracle. Please award the project and I can start working immediately.

$50 USD за 1 день
(20 отзывов(-а))
5.2
huseyinaygun

Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 4 Database Systems Course projects which cover: - Conceptual design - Creation of database schema (creat Больше

$30 USD за 2 дней(-я)
(4 отзывов(-а))
2.9
chcoder719

Hi. I always work to get trust from clients. i read your job carefully. backend:ci,node,laravel frontend:angular,react,vue cms:opencart,wordpress I am a mean stack as well as good designer Following are some of Больше

$20 USD за 1 день
(1 отзыв)
1.4
abhimadankr

I read job description and I can do your project.I can even work on urgent basis and complete your project soon..contact me for more information

$55 USD за 5 дней(-я)
(0 отзывов(-а))
0.0
hassanLast

. . . . . . . . Больше

$25 USD за 1 день
(0 отзывов(-а))
0.0
Ranjanbapidas

I am a student..I want to do the task but with your help to understand all

$15 USD за 4 дней(-я)
(0 отзывов(-а))
0.0
akshaykumavat69

I am .NET developer. I have good hands-on experience more than 3.5 yrs in asp.net web and windows application developement with database setup for backend. Wil cmplete this work in one day. Let me know if you want t Больше

$35 USD за 1 день
(1 отзыв)
0.0