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
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 päivässä
5,0 (23 arvostelua)
4,2
4,2
8 freelancerit tarjoavat keskimäärin $32 USD tätä projektia
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 (creating tables, constraints)
- Writing simple and complex SQL queries including nested queries.
I am sure that I am a good fit for your project. Hope to hear from you soon.
Best Regards
Huseyin Aygun
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 to start it now.
Thank you.