Cancelled

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

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.

NOTE:::: DEADLINE NOT UNTIL 5/12/13 11:59 PM EASTERN STANDARD TIME

Skills: MySQL, PHP, Software Architecture, 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: #4496694

11 freelancers are bidding on average $174 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$138 USD in 5 days
(235 Reviews)
7.8
srinichal

I can make the changes and deliver the project

$272 USD in 5 days
(92 Reviews)
7.0
zeke

Dear Customer! I am an expert web developer with over 6 years of experience and very interested in this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service More

$257 USD in 3 days
(145 Reviews)
6.8
mauryacravings

hello mam, i have gone through your requirement i can do this let me know more details thanks of possible try to contact me through private message.

$151 USD in 3 days
(25 Reviews)
6.2
ielkfarna

Please, See my private Message.

$147 USD in 3 days
(20 Reviews)
5.2
coolrankit

------ 3YEARS EXPERIENCED PHP, MySQL, WORDPRESS, HTML, CSS & WEB DEVELOPING EXPERT ------

$100 USD in 3 days
(22 Reviews)
5.2
ajay192

Details are given in PMB.

$166 USD in 5 days
(1 Review)
3.0
osnofasl

Good evening. I am computer engineer, so I am ready and able to do the job. I still have a doubt, though: as far as I understood you want the database and function/queries, so why the PHP? You wanting a frontend too? More

$166 USD in 15 days
(1 Review)
1.5
guangzhen122

Dear, sir. I am expert of database programming. I completed ABCLIST project. Please check my pmb.

$100 USD in 3 days
(1 Review)
0.0
franceson2it

Kia ora! [url removed, login to view] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$257 USD in 10 days
(0 Reviews)
0.0
patelwebtech

hello respected , we have experienced in SQL and related technology . we can do your job as per your requirement and within deadline. can we talk about it? thank you

$150 USD in 5 days
(0 Reviews)
0.0
ebin123456

i am ready to do your work

$111 USD in 4 days
(0 Reviews)
0.0