Find Jobs
Hire Freelancers

Short SQL Database

$25-50 USD / hour

Cancelled
Posted over 10 years ago

$25-50 USD / hour

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.
Project ID: 5100361

About the project

16 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $34 USD/hour for this job
User Avatar
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 just a formal confirmation that we are interested in this Project & technically there are no hurdles but for the price/time-line and overall process, we can discuss, once you drop me a message here. As our first message to you is not formatted in proper paragraph. Please let me know, if you want to see our portfolio, I can then send you our recently deployed projects. Look forward to hearing from you and talking to you further thru' Freelancer message board. Regards, YK LEADconcept
$30 USD in 40 days
5.0 (39 reviews)
8.3
8.3
User Avatar
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 freelancer.com and I would like to help you get this project done if you would give me the opportunity. I am a computer science professor and practitioner and this assignment is one of the fields that I teach very well so I can assure you an accurate result.
$30 USD in 2 days
5.0 (627 reviews)
7.2
7.2
User Avatar
let expert do this https://www.freelancer.com/u/pivn.html https://www.freelancer.com/u/pivn.html https://www.freelancer.com/u/pivn.html
$44 USD in 2 days
5.0 (33 reviews)
5.6
5.6
User Avatar
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. Waiting for your response to start the project. Thanks.
$27 USD in 15 days
4.8 (99 reviews)
5.8
5.8
User Avatar
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 some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. I've attached an example of ERD done here in freelancer.com on my portfoliov section. Please send me all other details about your assignement, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$42 USD in 5 days
4.5 (27 reviews)
5.2
5.2
User Avatar
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. thanks
$40 USD in 2 days
4.6 (16 reviews)
4.9
4.9
User Avatar
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 did lots of similar projects in freelancer. http://www.freelancer.com/u/nibiranijum.html I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq
$27 USD in 10 days
4.8 (28 reviews)
4.8
4.8
User Avatar
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. I am waiting to hear from you. Thanks. Dear sir, I would like to add something: 1. Price is nigotiable 2. Payment is made after your full satisfaction. 3. Please give the opportunity to do the job. 4. I will provide you quality work.
$40 USD in 4 days
4.9 (32 reviews)
4.8
4.8
User Avatar
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 in 15 days
5.0 (18 reviews)
4.3
4.3
User Avatar
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 in 1 day
4.8 (19 reviews)
3.8
3.8
User Avatar
I can complete this project within 4-5 hours. I have a great experience in database design and development.
$25 USD in 20 days
0.0 (0 reviews)
1.6
1.6
User Avatar
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 I can surely satisfy you. Hope to hear from you. Best Regards, Xue Ming
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 8 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Washington, United States
5.0
1
Member since Mar 8, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.