Cancelado

Short SQL Database

I have attached all the data that is needed to complete the second part of this project. Please contact me if you have any questions.

Project 2

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.

2. Provide 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.

3. Populate 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.

4. Write 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:

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.

Habilidades: Arquitetura de software, SQL

Ver mais: 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, data entry 10 key test, database entry definition, comments oracle, check point software, at johnson, 10 key data entry test, oracle sql with, oracle sql number, sql script , sql data, sql commands, physical design, oracle queries

Acerca do Empregador:
( 1 comentário ) Washington, United States

ID do Projeto: #5100361

17 freelancers estão ofertando em média $33/hora para este trabalho

leadconcept

Kindly ignore the estimated hours, as we still need to discuss requirements of your project. -------- Dear Sir, I have read your Project Description and checked the attached document, so this initial message is ju Mais

$30 USD / hora
(30 Comentários)
8.0
it2051229

Hi, I am placing my bid on your project because I have read the requirements and I am confident enough with my Database skills. I am focused mostly on doing computer science homework here in [url removed, login to view] and I would Mais

$30 USD / hora
(70 Comentários)
5.3
spcinc

Hello, Sir. SQL expert here. I have many experiences of SQL work. If you choice me, I'll satisfy you. Best regards.

$46 USD / hora
(5 Comentários)
4.7
manhpham

Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. I am interested in your [url removed, login to view] let's me help you.

$41 USD / hora
(18 Comentários)
4.5
rakib062

Hi, I am a graduate in CS and working as a database developer in oracle for 3+ years. I have done lots of assignments both in academic courses and in freelancer.com. I assure you of clean, efficient design and query. Mais

$40 USD / hora
(14 Comentários)
4.5
nibiranijum

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 7 years of experience. I am expert in database design. ERD, DFD, Physical schema, normalization etc. I d Mais

$27 USD / hora
(16 Comentários)
4.3
elboukharimu

Hi, I'm very interested helping you doing your database assignement, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is som Mais

$42 USD / hora
(9 Comentários)
4.1
pivn

let expert do this [url removed, login to view] [url removed, login to view] [url removed, login to view]

$44 USD / hora
(15 Comentários)
3.9
Reza2012

Hi I have more than 10 years experience in Oracle database administration and SQL programming. Previously I have done same type of work. If you want to see my work sample I can provide you. Please communicate with me. Mais

$40 USD / hora
(5 Comentários)
3.8
BhargavaB

Hi this is bhargava expert in bhargava . i am ready to provide quick and efficient solution .please contant me PM for more details .

$25 USD / hora
(3 Comentários)
2.4
choks1991

Hi..here is SQL DBA.I can do ur task very quickly.i can do it in just 3 to 4hours [url removed, login to view] can discuss more hank you

$25 USD / hora
(2 Comentários)
2.2
shehzadwork

I have the skills and expertise. I can do your this project. I have done work in database area and know about the related tasks. Consider me for your this project. I will be waiting for your reply...............

$25 USD / hora
(3 Comentários)
1.9
vivooo

HI, listen, some people bid with $144 or $555 which is default in system and totally a fake estimate and they increase amount after you knock them lol .....Before hiring someone, check completion rate and portfolio fr Mais

$39 USD / hora
(2 Comentários)
1.0
truongnguyen86

i'm oracle expert with 5 years experiences, i have done similar jobs like this before. If you need sample, i can show you. About your project, i have read all about the requirement, project1 have done with entity, this Mais

$25 USD / hora
(1 Comentário)
1.0
mail2vimalarora

I have gone through your requirement of project 2 details (also checked pdf file of project1).. I have professional experience of working in Oracle database and can deliver you out as per requirement in well time frame Mais

$27 USD / hora
(1 Comentário)
1.0
xueming0723

Hi Greetings. As soon as I read your job posting, it seems like you are exactly looking for me. I have rich experience with Database Administration. I have experience working with Oracle, MS SQL, MySQL, PostgreSQL Mais

$35 USD / hora
(0 Comentários)
0.0
suniljainmca2008

I can complete this project within 4-5 hours. I have a great experience in database design and development.

$25 USD / hora
(0 Comentários)
1.0
Rohitkumarsharma

Hello, I found your SQL Database job post and I’m very interested in your project. As a certified Microsoft professional with experience. I think you’ll find I have the skill you’re looking for. Please take a lo Mais

$41 USD / hora
(0 Comentários)
0.0
ajcg

Dear Sir, This should be quite easy to do. I have extensive experience with DDL, DML and SQL. If this is an academic work I could write you a report to accompany the project. Regards

$44 USD / hora
(0 Comentários)
0.0