Create Oracle database tables using SQL DDL

In Progress

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:

Part 1

i. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1.

ii. 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.

iii. Your CREATE TABLE statements must show integrity constraints, as appropriate, for NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, REFERENCES, and CHECK constraints.

iv. Be sure to save your script used to create these tables as yournameproject2step1.sql.

v. You should test your script to make sure it runs without error.

Part 2

i. Provide two examples of SQL DML (i.e., "INSERT") commands that fail different table integrity constraints you set up in one of your table.

ii. Explain why the statements fail.

iii. Be sure to save your script used to as yournameproject2step2.sql.

iv. You can include comments in the SQL script describing why the insert statements failed.

Part 3

i. Populate each of your tables with at least five valid rows of data each and show the SQL you used.

ii. Populate other tables in your database, as necessary, to satisfy referential integrity.

iii. Be sure to save your script used to create these records as yournameproject2step3.sql.

iv. You should test your script to make sure it runs without error.

Part 4

i. Write SQL to perform the following queries and updates.

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

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

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

d) Update customer names to change their maiden names to married names. You can choose which records to update.

e) Delete customers from the database. You can choose which records to delete.

ii. Be sure to save your script used to create these records as yournameproject2step4.sql.

iii. You should test your script to make sure it runs without error:

Skills: SQL

See more: oracle create table project, mom pop johnson, sql to oracle, sql code oracle, sorted data set, project mom, pop commands, oracle database company, oracle company name, johnson and johnson, erd documentation, design mom, definition of data entry, data entry definition, database entry definition, comments oracle, at johnson, write ddl sql oracle, oracle ddl language, sql code mom pop johnson, create primary key sql, oracle create table script, erd mom pop video store, oracle sql with, oracle sql number

Project ID: #1511530

Awarded to:

lynwode

Good Evening, Over 15 years Oracle experience in schema creation (DDL)and quering (SQL). I have immediate bandwidth to work on this. Please see PMB for further details. Tim

$50 USD in 1 day
(0 Reviews)
0.0

30 freelancers are bidding on average $107 for this job

eperfections

This project is ready to deliver. Please accept my bid.

$100 USD in 0 days
(65 Reviews)
5.9
snsTechnologies

Please see PM for detailed proposal. Thanks!

$50 USD in 1 day
(6 Reviews)
4.8
it2051229

Hi, kindly check your inbox for my inquiries. Thanks.

$40 USD in 0 days
(11 Reviews)
3.8
ifaisal

Hello I can do this for you. I have over 10 years of oracle experience. Please see my profile and feedbacks. Regards Faisal

$50 USD in 1 day
(3 Reviews)
3.4
rakib062

Hi, I am working as a database admin,designer and developer with 8+ years of experience in ms access,sql server and oracle. My area of expertise is to design,implement database and write query to meet business requi More

$70 USD in 2 days
(5 Reviews)
3.3
Kishoredev

Hello, I have provided detailed 4 scripts in the attached project2.zip as specified in the project description. Please go through and execute the scripts and reply me if you feel i am good enough to fulfill this req More

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

I am a PL/SQL expert. I work with PL/SQL in a daily basis. I have more than 15 years of experience in this technology.

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

I am working on SQL since last 1 year.. I am very good in writing SQL queries. Although I am a new free lancer but given a chance, I would be of great help to you..

$150 USD in 5 days
(0 Reviews)
0.0
sreeku00

Hi, i am interested in this project.please contact me. sreevidya

$100 USD in 1 day
(0 Reviews)
0.0
sushantasahoo

i have understand the project thoroughly whatever the requirement as mentioned.

$50 USD in 3 days
(0 Reviews)
0.0
glare09

PLEASE SEND ME DETAILS OF THE PROJECT . Pls be descriptive in the document.

$200 USD in 60 days
(0 Reviews)
0.0
skibim

7 years of experience

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

I am an experienced professional in ORACLE. Have 8+ yrs of exp on SQL,PL-SQL

$240 USD in 7 days
(0 Reviews)
0.0
SullivanK

Hi, I have 4 years experience in creating oracle tables, erd and developing apex applications. When can I start? Regards, Sullivan

$100 USD in 2 days
(0 Reviews)
0.0
ihassa

Hi, I have worked as database administrator for five years, mainly for financial, telecommunication and trading companies. I hope that that my experience and abilities will meet of your expectations.

$250 USD in 5 days
(0 Reviews)
0.0
anilpaghadal

Hello, We are having a expert team both at technical and management level to handle such projects.. Please let me know if you are happy with the bid and we can discuss further... We are newly registered company but ou More

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

hello sir, I am ready to start the work now. please check the PM for more information. -Jugal Shah

$50 USD in 3 days
(0 Reviews)
0.0
NistorA

Hello I would like to help you with this project I have 4 years exp. with oracle sql (plsql) db. I can deliver all 4 steps probably in 1 working day.

$30 USD in 3 days
(0 Reviews)
0.0
haka77

Please send detailed documentation on my mail. Halyna

$100 USD in 5 days
(0 Reviews)
0.0
Marino4ka

I've been working with Oracle DBMS for 2 years checking data integrity and making sophisticated queries for business intelligence purposes. I wil perform your task in 2 days having been provided with ERD model and deta More

$70 USD in 1 day
(0 Reviews)
0.0