Closed

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

This project received 12 bids from talented freelancers with an average bid price of $168 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
12
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online