Completed

Build a website and backend MySQL database.

I need a registration database for a scholastic competition with entries from a number of schools. I will need some security so that they can't see or edit the back end, and different views for different roles (i.e., registration, scoring, personal information for the student entrants -- they're minors, so security is very important there -- and result reporting). Sanity checks against scheduling conflicts would be a HUGE nice-to-have. I can do updating if what we first come up with doesn't work. I'm comfortable in SQL, so I don't mind making it better, but don't have the time to do it from scratch.

There are about 550 students who will attend the annual Junior Classics League event. There are a wide variety of events, including academic and artistic competitions. In total, there are over 100 events. Most will compete in 4-8 of them, and all must compete in at least two academic events. The students themselves should be able to Register to attend and sign up for events online. Each event has a meeting time. The signup sheet needs to include the student's name, age, grade, school and personal information (gender, parent/guardian contact information, health insurace information, allergies/needs, etc.)

The first challenge is this registration page. Ideally, we would like to divide the events up by type of events. Choosing a drop down of one of those should bring up another drop down with the corresponding events. So if I go to sign up, I should be able to choose oratory from a list, and then have the next box populate with the events that fit into that category. (Obviously, I have a spreadsheet with all of the events.) Once I've done that, level should autopopulate (where divided, mostly in academic events, 7th-9th graders compete against each other and 10th-12th graders compete against each other). If needed, I can fix that in the SQL database if, for example, a mentally challenged child is allowed to compete in the lower level. But it should default based on that.

The sanity check I mentioned is just a check that the student did not sign up for two events that meet at the same time. If they do, an error box should pop up saying that the registration is wrong.

Once the students have signed up (there is no need to collect money from the student) we need a report by school. Again, if you don't want to program this as a web page, I can easily enough print out a report grouping by school in MySQL.

The next step is assigning judges for each event. Each judge should have a score sheet with the student's ID number, but NOT the student's name or school, along with the name and level of the event that she or he is judging. Once they've done so, we need a web page to input the scores for each competitor. I think this would be easiest with a different judge's page. The judge inputs his/her judge number, and it pulls up a list of student IDs. The judge then inputs the score for each student s/he saw. This ensures that no judge can input scores for an event s/he didn't see. As such, each judge should also need to sign in and have a password.

Once all the scores are entered, we need two sets of reports. The first is by school. Which school did the best? The second is by student. Which student did the best in each event and overall.

Note that I know how to code some, so I can adjust anything that the schools don't like. (I'm friends with a teacher, but not a teacher myself; she doesn't know I'm paying someone else to get me started out of my own pocket.)

Before I award this, please let me know how these requirements will add to the cost. I understand that they do, but want to know what I'm getting into before I award the job. Thank you.

My proposed schema. I'm not a professional, so I'm not sure, but this is how I think it works: I'm sure I'm missing some things. That's why we HIRE professionals.

STUDENT TABLE (All student fields denoted by S_):
StudentID (Autogenerate)
S_First
S_Last
S_Address1
S_Address2
S_City
S_State
S_Zip
S_Guardian
S_GuardianPhone
S_Allergies
S_SpecialNeeds
SchoolID (Foreign key to school table)

SCHOOL TABLE (Denoted by an L_ to distinguish it from students):
SchoolID (Autogenerate)
L_Chaperone1Name
L_Chaperone1EMail
L_Chaperone1Phone
L_Chaperone2Name
L_Chaperone2EMail
L_Chaperone2Phone
L_Chaperone3Name
L_Chaperone3EMail
L_Chaperone3Phone

JUDGES TABLE (All Judge Fields denoted by a J)
Judge ID
J_Name
J_Phone

EVENT TABLE
EventID
EventType
EventName
EventLevel
EventTime
EventLocation

SCORES TABLE
EventID
JudgeID
StudentID
Score

There are some reports as well.

Compétences : HTML, MySQL, PHP, SQL, Design de site internet

en voir plus : how to build a website using php and mysql, how to create a database driven website, how to create a website with a database, database driven website tutorial, how to create a database for a website in dreamweaver, how to create a web based database, database driven website template, database website examples, designer php website with mysql database, build website php mysql ubuntu, move website files mysql database server, build real estate mysql database, build front end mysql database, build mysql database scratch python, build website backend photograph, multilanguage website php mysql database setup, mysql database scratch, paste website allow mysql database, use button website update mysql database, build website backend

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #17355120

Décerné à:

ferozstk

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on with more than 5 years experience. Please feel free to contact me. I am looking forward to hear from you. Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(86 Commentaires)
6.3

133 freelance font une offre moyenne de $511 pour ce travail

sanjay2004

Hello, My understanding for the project is you are looking out to have a website designed and built where students can register for scholastic activities and records will be kept in backend. Relevant Skills and Experi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(1416 Commentaires)
10.0
thetechie13

Hi there, I am ready to build up registration database using mysql .the backed will be fully secure as you required . is there different log in registration for each students . Relevant Skills and Experience i am e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(512 Commentaires)
9.1
A2Design

Hello! We are A2 Design, a Russian-Canadian web development company. Our team is interested in developing your project. Having the required skills, we will be glad to help you. We have some questions regarding y Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(141 Commentaires)
8.8
RockStone435

i understand that you need a registration database . i have read the details of the requirement of security, sanity checks etc. Relevant Skills and Experience i have built websites and data bases in the past as well. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(568 Commentaires)
8.7
kabirchy

Hi there, I have checked your project brief very carefully and can develop this entry/registration forms with necessary security. Site sections will have access based on roles. Relevant Skills and Experience I have se Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1293 Commentaires)
9.2
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(168 Commentaires)
8.7
monitrix

Hi, You need a website for school competition and school student registration form and other information display like scores etc. Need to discuss design and flow of website. Relevant Skills and Experience assure fast Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(488 Commentaires)
8.9
linuxfreak1985

Hi, I am interested in registration database Scholastic site as I specialise in PHP and Laravel Frameworks, i can do your project and custom PHP tasks listed, Relevant Skills and Experience Some of my past CorePHP / L Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(922 Commentaires)
8.4
Techizer

Hello Sir! With the reference to your description, I would like to inform you that we are the most eligible freelancer here with whom you can discuss this project. Relevant Skills and Experience http://healw Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(196 Commentaires)
8.4
dgapscom

Hello Sir I can design & develop high quality website to fulfill all of your requirements. Our developed cross-browser website would be highly secure from HACKING and spamming. Relevant Skills and Experience I am Fai Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(397 Commentaires)
7.9
extreamcode

HI There, I can assist you Build a website and backend MySQL database. I am very passionate about quality of my work, You will be pleased working with me. Relevant Skills and Experience Let's have a quick chat to disc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(88 Commentaires)
7.7
Risalat1

Ready to work with you, could you please send me some more details about your project so we will estimate it accordingly.... Relevant Skills and Experience Hi there, We are a small team of expert wordpress designers a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(404 Commentaires)
8.0
pointlogic

Hello, I always provide fastest results with quality. I have an experience of more than 10 years in web development and maintenance. Relevant Skills and Experience I have in-depth knowledge of php, mysql, javascript , Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(322 Commentaires)
8.1
petermyvw

My initial estimated approach for this project is as follows : 1) Figure out what each user role can do on the system 2) Build database using (1) 3) Build front end Relevant Skills and Experience Experience at convert Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(221 Commentaires)
7.2
mascotindia123

Hello there, I have gone through your project detail, you need a registration database for a scholastic competition with entries from a number of schools Relevant Skills and Experience We are a 10 year old IT company Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(256 Commentaires)
7.5
usatechsoft

I have read your project detail carefully and i am confident.i will provide [login to view URL] of work. Please check my client reviews .https://www.freelancer.com/u/usatechsoft.html Relevant Skills and Experience https:// Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(155 Commentaires)
7.7
espsofttech

we have build many school website and recently building very big project in dot net application also we are expert to build schooling software and program with php mysql. Relevant Skills and Experience we have build l Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(140 Commentaires)
7.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(28 Commentaires)
7.2
gahisharma

Dear Client, Hope you doing well. I have gone through your requirement and as per my previous work experience i am ready to start work immediately on your project. Relevant Skills and Experience http://www.mytootle.c Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(36 Commentaires)
7.4
contriverz

I am a full stack developer and having expertise to work on this type of projects and always delivered the quality work with full testing on time ( before the deadlines ). Relevant Skills and Experience Being a expert Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(79 Commentaires)
7.2