create a database
£20-250 GBP
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’.
Project ID: #5345259
About the project
31 freelancers are bidding on average £133 for this job
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
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
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
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
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
Hi I have more than 10 years experience in MSSQL and MySQL database design and administration. Please see my profile. Thanks.
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
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
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
hi this is Asad i have a lot of experience in sql programming ,would surely try to help you out with this ,cheers :)
I have 3 years experience in MySql and PostgreSql ... i'm expert in optimization and creation databases......................................
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
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