create a database

Closed Posted Jan 21, 2014 Paid on delivery
Closed Paid on delivery

Scenario

Title: Allotments

The Allotments Organic Vegetable Society (AOVS) was formed in 2005 by a group of owners who rent out allotments in Kent and East Sussex. These allotments, called plots, are all roughly the same size. The location of each plot is identified by a three character code that starts with either a ‘C’ or a ‘T’ followed by two digits in the range ‘0’ ... ’9’. The vegetables they grow are harvested and sold to local retail outlets. At present each gardener’s produce is sold by only one of these outlets. Each gardener can rent many plots but they cannot rent more than one plot in any particular location.

Each plot can be used to grow a range of vegetables and the total yearly yield for each vegetable per plot is recorded in kg. No more than 4 generic vegetable descriptions can be grown on any plot in any one calendar year.

It is planned to implement a small database to record the activities of AOVS since it was founded: current records are being kept in a mixture of word-processed and spreadsheet files.

The name of each retail outlet, outlet_name, uniquely identifies the outlet and is to be stored as a character string. A typical outlet is CCCU Students Union. Each outlet is to provide at least one of an e-mail address (e_mail) or an 11-digit landline telephone number (tel_no), which must start with a zero.

Each gardener is allocated a unique 4-character code that cannot start with a ‘comma’, or a ‘full stop’ or any of the following characters: !, £, $, *, <, >, ", =. In addition a gardener’s name, address and telephone number are always stored.

Each plot is given a unique identifier, plot#, which comprises 5 digits, the first of which cannot be 0. The rent charged for each plot depends on whether the plot is privately or council owned and on whether or not a shed and/or a convenient water supply is provided.

The plot owner’s name and category Private or Council is to be stored and each owner is identified by a 3-character code where the first character is in the range ‘1’ ... ’9’, and the second/third characters are each in the range ‘A’ ... ’Z’.

The vegetables grown in the plots are identified by the names (veg_id) used in standard Gardening Catalogues (e.g. Maris Piper, Winora, Parmex, etc.) except that they are always stored in upper case. Each of these vegetable names is associated with a generic vegetable description, e.g. potato, leek and carrot (for Maris Piper, Winora and Parmex vegetables respectively), which is always stored.

The annual rent is subdivided into bands, each identified by a single capital letter. The minimum annual rent is currently £75. If the plot owner is a Council and there is no shed then the rent band is ‘A’. If the plot owner is private and there is a water supply then the rent band is ‘D’. If the plot owner is a Council and there is a shed but no water supply then the rent band is ‘B’. Similarly if the plot owner is private and there is no shed and no water supply then the rent band is ‘B’. In all other cases the rent band is ‘C’.

MySQL SQL

Project ID: #5345259

About the project

31 proposals Remote project Active Feb 27, 2014

31 freelancers are bidding on average £133 for this job

urmate

HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Thanks More

£100 GBP in 3 days
(60 Reviews)
5.4
pivn

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

£154 GBP in 4 days
(49 Reviews)
5.2
elboukharimu

Hi, I'm very interested helping you creating your database and provide a good documentation too, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, pleas More

£98 GBP in 3 days
(26 Reviews)
5.1
feninsoftech

HI, I am ready to start on it. Will provide you a single notepad file that will create all entities, relations and constraints. Example: CREATE TABLE SampleTable ( Col1 INTEGER NOT NULL, Col2 INTEGER More

£150 GBP in 10 days
(15 Reviews)
5.1
it2051229

Hi, I am placing my bid on your project because I have read the requirements and I am confident enough with my Database Knowledge and skills. I am focused mostly on doing computer science homework here in [login to view URL] More

£50 GBP in 3 days
(30 Reviews)
4.7
nibiranijum

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 d More

£150 GBP in 3 days
(11 Reviews)
4.6
supportkumar

Hi mate.. Sure I can make you database and good table structures to store and retrieve records... 1. What about interface for upload data? we need to provide forms to add data or yourself ? 2. You need repo More

£111 GBP in 2 days
(17 Reviews)
4.4
Reza2012

Hi I have more than 10 years experience in MSSQL and MySQL database design and administration. Please see my profile. Thanks.

£111 GBP in 3 days
(13 Reviews)
4.2
gkan1234

Hi I have 4+ years experience in MySQL database. If you could share the existing files with me, I can check the same and can get back. Please send me a message so that we can discuss once. Thanks

£150 GBP in 5 days
(13 Reviews)
3.9
rakib062

Hi, I am working as a Database Designer and Developer for 7+ years in Sql Server, Oracle, My Sql and MS Access. Expert in Designing ERD, Database Schema, writing efficient query, stored procedure and triggers, Creati More

£110 GBP in 3 days
(7 Reviews)
3.7
mdakteruzzaman

I have been working as ICT consultant and Database Analyst programmer more than 10 years.I became OCP, CCNP and RHCE 3 years back. Earlier I completed B.Sc. Engg and M.Sc. Engg both in computer engineering. Check More

£77 GBP in 3 days
(6 Reviews)
3.0
pnjadhav

I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, More

£277 GBP in 5 days
(1 Review)
3.0
v86web

Hello Sir. I believe that I can provide you with the specification and the implementation you need in 3 days. Let me know when to start. Thank you. --Vinicius

£88 GBP in 3 days
(1 Review)
2.1
asadrana91

hi this is Asad i have a lot of experience in sql programming ,would surely try to help you out with this ,cheers :)

£66 GBP in 3 days
(0 Reviews)
0.0
ranjan01

I can create mysql database for your project with specified user name. I have 10 years experience in manage servers like web, database, mail dns. i can create database and allow database to a perticular vendor to acces More

£144 GBP in 1 day
(0 Reviews)
0.0
vbsnlslx

My skill set and experience details: • Over 9 plus years of software experience in IT industry including Requirements Analysis, Design, Development, Testing, Maintenance, and Enhancement & Production Support of Busi More

£150 GBP in 3 days
(0 Reviews)
0.0
denis01

I have 3 years experience in MySql and PostgreSql ... i'm expert in optimization and creation databases......................................

£80 GBP in 2 days
(0 Reviews)
0.0
producteyes

Hi, I run a team of 4 experienced MySQL developers and we are confident in doing this for you. A simple web interface will be required in order for you to interact with your database. regards, Dhruv

£150 GBP in 5 days
(0 Reviews)
0.0
palniklaszlo

Még nem kapott javaslatot

£244 GBP in 3 days
(0 Reviews)
0.0
KingOfPhoenix

Hi, Friend. Thank you for your long explain about your database in detail. I can understand all of your needs thanks for this explain. I can do it asap. I'll build the database with mysql and import your data i More

£105 GBP in 1 day
(0 Reviews)
0.0