Find Jobs
Hire Freelancers

SQL small project

$10-30 USD

Suoritettu
Julkaistu lähes 5 vuotta sitten

$10-30 USD

Maksettu toimituksen yhteydessä
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
Projektin tunnus (ID): 19149507

Tietoa projektista

8 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
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
Käyttäjän avatar
I can create this database for you in Oracle. Please award the project and I can start working immediately.
$50 USD 1 päivässä
4,9 (20 arvostelua)
5,2
5,2
Käyttäjän avatar
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
$30 USD 2 päivässä
5,0 (4 arvostelua)
2,9
2,9
Käyttäjän avatar
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 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
. . . . . . . . . . . . . .
$25 USD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I am a student..I want to do the task but with your help to understand all
$15 USD 4 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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.
$35 USD 1 päivässä
5,0 (1 arvostelu)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED STATES lippu
port orange, United States
5,0
18
Maksutapa vahvistettu
Liittynyt heinäk. 2, 2015

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.