Find Jobs
Hire Freelancers

Basic SQL/Database

$10-30 USD

Completed
Posted over 10 years ago

$10-30 USD

Paid on delivery
Implementation/SQL The assignment: Create a script like the [login to view URL] file to create your tables and populate the tables. You may find it more convenient to break this up into a creation script to create the tables and a population script to fill the tables with data. The population script requirements will be described more in the 2nd item. Based on what you determined from your earlier assignments, generate the design accordingly. You do not need to follow either the ER or the Normalization assignment 100%, but you should justify your choices if the two assignments were not the same or if you chose yet another way to implement some desired property. Insert data -- insert records for each table. Considering the queries below, make sure to enter enough data to check if your queries are correct. Your data should be from the website when available, but in some cases (like customers or orders), you may need to make up data. For any query where you need to return a result based on only records satisfying some condition, make sure you include both records that satisfy the condition and records that do not satisfy the condition. If the query is an aggregate query, insert different values for the approriate attribute(s) to check if the result is correct. QUERIES -- one basic, one using aggregate operations, one using at least one subqueries (either nested or set operation). The queries should be in a separate file to make it easier to execute them separately from the creation/population statements. Required files are attached. The tables do not have to exactly follow the tables provided but it should be similar and be based on the products on www.vitaminshoppe.com.
Project ID: 5125745

About the project

6 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
Awarded to:
User Avatar
Will use the same Tables (given in your ER and Normalization docs) to write Create Table, Insert Data and given queries. Will deliver within 2 days. You need to confirm what database to use? MySql? or some other. Thanks.
$83 USD in 2 days
4.9 (59 reviews)
5.4
5.4
6 freelancers are bidding on average $148 USD for this job
User Avatar
We intend to work on this project. Can we discuss details? Rehards, Nuprogramer
$368 USD in 10 days
5.0 (34 reviews)
6.0
6.0
User Avatar
Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,
$59 USD in 1 day
5.0 (45 reviews)
5.8
5.8
User Avatar
I could help you. . .
$155 USD in 10 days
5.0 (3 reviews)
2.2
2.2
User Avatar
I m Asad from Pakistan. I m currently in the final year of software engineering. Have worked on sql server ,need some little more details, wont disappoint you :)
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have both the knowledge and experience regarding databases. Both studying, teaching and working on real life projects for years.
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hayward, United States
5.0
42
Payment method verified
Member since Jun 5, 2012

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.