Database designed
- or -
Post a project like this2752
£150(approx. $187)
- Posted:
- Proposals: 16
- Remote
- #1272307
- Completed
Web Designer, Web Developer - Expert in Prototyping, HTML5, CSS3, Bootstrap, jQuery, PHP, Drupal
Dubai
Design and Build Turnkey Data based business solutions and process streamlining for SME's
Birmingham
1108984558551279261122769412181611189697109763110337899763217423832258
Description
Experience Level: Intermediate
General information for the website: Design Database
Database management system (DBMS): MySQL
Description of requirements/features: Just need the databse design
The database is to show the results of dog shows. The idea is to list the results of each show on a website, also where one can search for how times a certain dog has won or show how often a judge has picked a certain kennel affix. The following is my idea of what the database should include. I also need it to be able later on to cross reference data such as what dog has most wins, what dog has shown most etc. Also need to know when data has been created, updated etc.
Rough outlay of Database, tables.
dogs - kc_name (Dogs Kennel Club Name)
- kc_number (Dogs Kennel Club Number)
- date_of_birth (Dogs Date of Birth)
- bred_by_first (Who bred the Dog, first, last name)
- bred_by_last
- sired_by (Dogs Father)
- dam (Dogs Mother)
shows - show_id
- show_name (Name of Dog Show)
- type_show (There are four types of dog shows)
- classes (there are about 14 types of classes liste directly below, the dogs cabn be placed 1-5 withing any class)
- Minor Puppy Dog
- Puppy Dog
- Junior Dog
- Open Dog
- Graduate Dog
- Postgraduate Dog
- Limit Dog
- Minor Puppy Bitch
- Puppy Bitch
- Junior Bitch
- Open Bitch
- Graduate Bitch
- Postgraduate Bitch
- Limit Bitch
- Veteran
- awards (this is where the database will show if the dog has won best in show etc)
judges - judge_id
- judge_type (There are two types of judge)
- judge_first (Judge First and last Name)
- judge_last
- judge_affix (This is the kennel affix that the judge owns)
Extra services needed: Installation
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/features: Just need the databse design
The database is to show the results of dog shows. The idea is to list the results of each show on a website, also where one can search for how times a certain dog has won or show how often a judge has picked a certain kennel affix. The following is my idea of what the database should include. I also need it to be able later on to cross reference data such as what dog has most wins, what dog has shown most etc. Also need to know when data has been created, updated etc.
Rough outlay of Database, tables.
dogs - kc_name (Dogs Kennel Club Name)
- kc_number (Dogs Kennel Club Number)
- date_of_birth (Dogs Date of Birth)
- bred_by_first (Who bred the Dog, first, last name)
- bred_by_last
- sired_by (Dogs Father)
- dam (Dogs Mother)
shows - show_id
- show_name (Name of Dog Show)
- type_show (There are four types of dog shows)
- classes (there are about 14 types of classes liste directly below, the dogs cabn be placed 1-5 withing any class)
- Minor Puppy Dog
- Puppy Dog
- Junior Dog
- Open Dog
- Graduate Dog
- Postgraduate Dog
- Limit Dog
- Minor Puppy Bitch
- Puppy Bitch
- Junior Bitch
- Open Bitch
- Graduate Bitch
- Postgraduate Bitch
- Limit Bitch
- Veteran
- awards (this is where the database will show if the dog has won best in show etc)
judges - judge_id
- judge_type (There are two types of judge)
- judge_first (Judge First and last Name)
- judge_last
- judge_affix (This is the kennel affix that the judge owns)
Extra services needed: Installation
Extra notes:
Gary F.
100% (29)Projects Completed
17
Freelancers worked with
8
Projects awarded
61%
Last project
14 Feb 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Are you in a rush or flexible on deadline?
-
I can think of a few changes to your tables. Do you want the Database actually setting up or is it just the Table Design that you want and you are going to set it up yourself? I presume the CMS will be a separate Job from what you have mentioned
-
Gary
i. Do you have a website, can i see the url
ii. Do you have example search form or i have to design search form fields
iii. Do you example format of how search result will be display
Do get in touch
Regards
136287136125136049
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies