Excel file needs converted to a database with functions. other small assigments sql questions

Cancelled

Needed before 6 pm eastern standard time! 5/6/13 small budget, willing to be fair though This is needed for a project and has a fast approaching deadline

instructor suggested using php but anything will work of your choice.

Use excel file called abclist, convert to database file. needs to do the following functions:

Default Project Description

A owner of a blog that is dedicated to recipe’s , olive oil, vinegars, and wine along with other types of products is wanting to add some flexibility to his website to allow more users to use it. He wants to create a database that other members can use to keep a running inventory of what they have. In implementations the owner would love to eventually have people post items that they have interest in and a particular bottle can be tagged as being available or off the market, or make me an offer. The customer also wants the member to rate his or her own wine. This may include a bottle he/she does not own. The customer wants to start with the wine and spirits database.

The Customer has defined the 'Things of Interest' as follows-

•&νβσπ;Colors

•&νβσπ;Countries

•&νβσπ;Regions

•&νβσπ;Vineyards

•&νβσπ;Years

•&νβσπ;Membership or ownership of a wine

•&νβσπ;Quantity of a particular bottle(s) or case(s)

•&νβσπ;Others to be determined

•&νβσπ;A picture(s) of the wine or case

•&νβσπ;Ratings of wine based on specific characteristics, tannins, sweetness, fruitiness, alcohol, etc.

•&νβσπ;Cost

The Business Rules are as follows:

•&νβσπ;A Region is always in a Country

•&νβσπ;A Wine is always associated with a Country

•&νβσπ;A Wine is sometimes associated with a Region

•&νβσπ;Every Wine has a Color, including Champagne

•&νβσπ;Every Wine has a Year

•&νβσπ;Non-Vintage Champagnes do not have a Year. Therefore the Relationship between Years and

Wine is optional at the Years end

The database should be able to

•&νβσπ;Add users

•&νβσπ;Delete users

•&νβσπ;Create Wines

•&νβσπ;Modify Wines

•&νβσπ;Delete wines

Associate wines to a particular member in the system

Be able to take a particular wine and run a comparison of reviews by multiple individuals.

Screenshots of input screens

Please note this list is NOT EXCLUSIVE…. Doing the above will just meet the bare requirements. If you want to get an exceptional grade on the project, you will have to go above and beyond.

THE OTHER ATTACHMENTS ARE NEEDED WITHIN THE WEEK, BUT THE ABCLIST PROJECT IS AT THE TOP OF THE LIST, THANKS. WILL GIVE MILESTONE AFTER COMPLETION OF THE ABCLIST PROJECT, WILL RELEASE FULL PAYMENT AMONG OTHERS BEING COMPLETED.

Skills: MySQL, PHP, SQL

See more: what business to start using excel, start your small business, start your own small business, sql inventory system, sql database business, ratings country, market needs, inventory system using php, countries ratings, convert excel to website, non exclusive relationship, needs and wants, customer database in excel, wine blog, what is a milestone, sql business, quantity take off, olive oil, excel small work, excel inventory, excel file, delete milestone payment, champagne, add a milestone, small business excel budget

About the Employer:
( 8 reviews ) Jeffersonville, United States

Project ID: #4493552

12 freelancers are bidding on average $195 for this job

gopalvora

Hi ready to start Thanks

$206 USD in 3 days
(155 Reviews)
6.8
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ More

$309 USD in 5 days
(76 Reviews)
6.0
maxpl

I am interested to do job for you. I have seen the specifications of your project. I have 4+ years of experience in webdesign/ development, Mobile Development. I have read your project details. I am interested to More

$189 USD in 5 days
(2 Reviews)
2.9
pmurugan

Hi, I am ready to start...

$110 USD in 3 days
(3 Reviews)
2.6
tourala

I have 3 years experience in MySQL, PHP, SQL I can do this project with your full satisfaction. All of your requirements will be fully met. Before this I have done a lot of projects on these skills to other freelanc More

$74 USD in 3 days
(3 Reviews)
2.1
nyron84

ready to work

$330 USD in 7 days
(1 Review)
2.0
anutiwari

hi, Having 6 years experience in the web development . My web developing expertise includes: Designing, building and maintaining ecommerce websites. Strong database knowledge specifically MySQL. Extensive kn More

$154 USD in 30 days
(0 Reviews)
0.0
SoftwareEng8876

Hello ...i am very much interested in this project.i have to do my best to get good positive feedback from you.you can believe to get good results from me.just give me one chance to prove. Thank u!

$231 USD in 5 days
(0 Reviews)
0.0
tusherity

Let's get it started today.

$165 USD in 4 days
(0 Reviews)
0.0
vandematram01

hello sir, we are done such type of works on past. and ready to do it.

$154 USD in 3 days
(0 Reviews)
0.0
krugner

I have the system and only need to configure the fields.

$105 USD in 3 days
(0 Reviews)
0.0
DenovaGloSoft5

Hi, We are ready to start now. Please check your PMB for details. Thanks Denova GloSoft Limited

$189 USD in 5 days
(1 Review)
0.0
cancerian192

Let me know if you want the Database on Access or Oracle or just SQL commands

$275 USD in 3 days
(0 Reviews)
0.0
Sumitmittal91

happy to work with you...

$154 USD in 3 days
(0 Reviews)
0.0