In Progress

Create Oracle database tables using SQL DDL

In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manipulation Language (DML) SQL commands. The ERD and detailed documentation from Project 1 will be supplied for your entry point for those who need it.

Project 2 Details:

1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1. 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 statements must show integrity constraints, as appropriate, for NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, REFERENCES, and CHECK constraints. Be sure to save your script used to create these tables as yournameproject2step1.sql. You should test your script to make sure it runs without error.

[url removed, login to view] two examples of SQL DML (i.e., "INSERT") commands that fail different table integrity constraints you set up in one of your table. Explain why the statements fail. Be sure to save your script used to as yournameproject2step2.sql. You can include comments in the SQL script describing why the insert statements failed.

[url removed, login to view] each of your tables with at least five valid rows of data each and show the SQL you used. Populate other tables in your database, as necessary, to satisfy referential integrity. Be sure to save your script used to create these records as yournameproject2step3.sql. You should test your script to make sure it runs without error.

[url removed, login to view] SQL to perform the following queries and updates. Be sure to save your script used to create these records as yournameproject2step4.sql. You should test your script to make sure it runs without error:

[url removed, login to view] all of your customers' names, account numbers, and addresses (street and zip code only), sorted by account number.

[url removed, login to view] all of the videos rented in the last 30 days and sort in chronological rental date order.

[url removed, login to view] a list of your distributors and all their information sorted in order by company name.

[url removed, login to view] customer names to change their maiden names to married names. You can choose which records to update.

[url removed, login to view] customers from the database. You can choose which records to delete.

Submissions:

[url removed, login to view] should submit your four SQL scripts satisfying each of the steps above. Feel free to compress the files using WinZip

Skills: Database Administration, Oracle, SQL

See more: populate tables valid rows, oracle foreign key definition ddl, sql to oracle, sql code oracle, sorted data set, project mom, pop commands, oracle database company, oracle company name, oracle comments in sql scripts, johnson and johnson, erd documentation, design mom, definition of data entry, data entry test for free, data entry definition, database entry definition, comments oracle, at johnson, oracle sql ddl tables, oracle sql with, oracle sql number, sql script , sql queries, sql data

About the Employer:
( 1 review ) spring lake, United States

Project ID: #2526544

Awarded to:

diegogarcia0531

Hi, I am ready to do this job, just send me the project 1 especification.

$35 USD in 1 day
(12 Reviews)
4.6

16 freelancers are bidding on average $145 for this job

bouslimi1979

Ph D in computer science, please check PM. Thanks

$160 USD in 2 days
(1 Review)
2.9
puneethmech

can start immed

$50 USD in 1 day
(2 Reviews)
2.9
greatwarrior

Hi Bubba We are very confident of doing it as we have done a lot of such assignments Please reply if you are interested in our profile Many a thanks - NAVIN

$45 USD in 0 days
(1 Review)
1.1
devfl

Hi, I have very good experience in Oracle and SQL. I am ready to work on this project. Please check PMB. Thanks

$150 USD in 2 days
(0 Reviews)
0.0
thomasajaionline

Hi, I am an experienced developer in SQL. I would like to know more details.

$200 USD in 10 days
(0 Reviews)
0.0
chaterjeerea91

I am working as a Freelancer from past 5 years, and i am having experience in DBA of 8 years. So your work requirements is very clear to me and it will be deliverd in time.

$200 USD in 2 days
(0 Reviews)
0.0
Prasad08

Greetings, I am ready to do your work on urgent basis & as per your requirement. I understood your steps and provide you required results.

$200 USD in 2 days
(0 Reviews)
0.0
rengrish

Hi I am interested in this project. I have 3.5 years of experience in oracle . Please check your mailbox .

$100 USD in 3 days
(0 Reviews)
0.0
logoDS761

10 years Oracle 11g & plSql experience

$133 USD in 3 days
(0 Reviews)
0.0
hopeful021

If you are agreed please pm me. For further detail check my resume.

$250 USD in 30 days
(0 Reviews)
0.0
kodevtech

Its our pleasure to work for you sir. our team have people who are oracle [url removed, login to view] read the PM for my previous work related to your project. Thanks

$50 USD in 1 day
(0 Reviews)
0.0
sabafreelan

Working on the project will deliver it soon

$100 USD in 3 days
(0 Reviews)
0.0
SahilDoda87

Have worked several times on similar projects. Have 2 years and 7 months of experience in same domain..

$100 USD in 3 days
(0 Reviews)
0.0
kishore2903

Having very strong in database programming, will do it as per your need.

$250 USD in 10 days
(0 Reviews)
0.0
rosdidier

Hi I am an Oracle Certified Professional (OCP) and I work as a DBA in a big Energy Firm. I can help you with your project.

$110 USD in 3 days
(0 Reviews)
0.0
AccuPro

Hello, Easy stuff!

$225 USD in 3 days
(0 Reviews)
2.4