Käynnissä

Create Oracle database tables

1)

Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in the metadata of Assignment 1. You may need to use a combination of DROP TABLE, CREATE TABLE, and ALTER TABLE SQL statements. Make sure that entity and referential integrity are enforced by declaring a primary key for each table (these may be composite keys) and declaring all appropriate foreign keys. Your CREATE TABLE and ALTER TABLE statements (if desired) must show integrity constraints, as appropriate, for NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, REFERENCES, and CHECK constraints. Be sure to save your SQL script file used to create these tables with a .sql extension and your output SPOOL file with a .lst or .txt extension. You should rerun and test your SQL script file until it runs without any errors (this is why you’ll want to include DROP TABLE statements). Submit your SPOOL file showing that all SQL in your SQL script file worked properly.

2)

Populate each of your tables with at least five valid rows of data each and show the SQL INSERT statements as you executed them. Populate other tables in your database, as necessary, to satisfy referential integrity. Save your SQL script file and SPOOL file with the correct extensions. You should test and rerun your SQL script file until it runs without any error. Submit your SPOOL file showing that all SQL in your SQL script file worked properly.

3)

Develop an SQL script file to perform the following queries and updates. You should test your SQL script file until it runs without any errors.

o Retrieve all of your customers' names, account numbers, and addresses (street and zip code only), sorted by account number.

o Retrieve all of the videos rented in the last 30 days and sort in chronological rental date order.

o Produce a list of your distributors and all their information sorted in order by company name.

o Update a customer name to change their maiden name to a married name. You can choose which row to update. Make sure that you use the primary key column in your WHERE clause to affect only a specific row. You may want to include a ROLLBACK statement to undo your data update.

o Delete a customer from the database. You can choose which row to delete. Make sure that you use the primary key column in your WHERE clause to affect only a specific row. You may want to include a ROLLBACK statement to undo your data deletion.

Taidot: Tietokannan hallinto, tekniikka, Oracle, SQL

Näytä lisää: car rental system database oracle, movie rental database oracle, create database oracle, video rental store database oracle, create database oracle project, oracle mom pop johnson video rental database, create database oracle 10g sql, sqlplus create database oracle, php database results ajax drag sort, create method sort array items name product, example student record database oracle, ranking database oracle sql server db2 postgresql, scripts update tables database, database oracle labview

Tietoa työnantajasta:
( 130 arvostelua ) Alexandria, United States

Projektin tunnus: #13106381

Myönnetty käyttäjälle:

jagdishbhatt38

I am having more than 7 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 Lisää

35 $ USD 1 päivässä
(13 arvostelua)
4.2

12 freelanceria on tarjonnut keskimäärin 37 $ tähän työhön

scorpioangry55

You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.

72 $ USD 1 päivässä
(10 arvostelua)
4.6
CaptainSadaf

I'm Computer Scientist and ready to deal with various projects as technical writing, Java projects, C#/C++, SignalR based applications, MySQL, MS SQL server, Database schema, Image processing, Matlab, MS visual studio, Lisää

23 $ USD 1 päivässä
(6 arvostelua)
4.0
ref2

Hi I have 15+ years of experience in developing applications on oracle database. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. I hav done few of Lisää

35 $ USD 1 päivässä
(19 arvostelua)
4.1
utkarshkatiyar19

Hi. i have a lot of experience in Oracle databases. i can easily complete your project. we can have a chat. thanks.

70 $ USD 1 päivässä
(2 arvostelua)
2.9
30 $ USD 1 päivässä
(12 arvostelua)
2.9
ivivek

Hello, This is in response to your job notification for the position of Professional for your project. I have been working as a Java developer for the last 5+ years with a software firm and mentioned below ar Lisää

25 $ USD 2 päivässä
(1 arvostelu)
1.0
30 $ USD 5 päivässä
(0 arvostelua)
0.0
Beannsofts

Hi, THANKS FOR THE OPPORTUNITY. Check good reviews from customers I have previously worked for. Its my duty, as I have done here before to deliver on this. Kindly let's start work. I have completed projects in so Lisää

30 $ USD 6 päivässä
(0 arvostelua)
0.0
rapidsoft4

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c Lisää

24 $ USD 6 päivässä
(0 arvostelua)
0.0
24 $ USD 6 päivässä
(0 arvostelua)
0.0
shailesh380

I will delivered in 1 day

23 $ USD 1 päivässä
(0 arvostelua)
0.0
younisalsbae

A proposal has not yet been provided

30 $ USD 5 päivässä
(0 arvostelua)
0.0
settconsultant

Greetings from Sett Consultant. Based in Kolkata,India, our team of 8 consists of Oracle Application Express(Oracle Apex) developers,Database designers,DBAs,UI/UX [url removed, login to view] have young,highly-experienced,professiona Lisää

35 $ USD 1 päivässä
(0 arvostelua)
0.0
28 $ USD 1 päivässä
(0 arvostelua)
0.0