To Develop A MYSQL Database Which can be accessed via a webpage - open to bidding

Closed

Description

Aim - To create a database in MySQL that can be accessed via a web page using PHP.

Objectives

To demonstrate understanding of database design and creation.

To show competence in SQL queries for data manipulation and data definition.

To produce an appropriately structured and normalised database from a specified data set.

To develop a web interface capable of interacting with the database.

A university department currently has a spreadsheet which holds timetabling information for staff, in order to keep track of the number of hours that a person teaches and the classes they are associated with. This is not a very efficient solution, and so they would like to move this information to a database. Your job is to create this database from the data given.

The information that the department currently has on file is as follows:

Module codes and titles

Which semester a module is taught in (1 or 2)

Which year of the course the module is taught in (Year 0, 1, 2 or 3)

The name of the staff member teaching each module, and their room number

The number of hours per week that each module is taught for

A member of staff then currently also has to calculate the total number of hours worked by each member of staff, by adding up the hours that they teach for each module they are associated with.

Task 1: creating the database

Create a database using MySQL that stores all the information the department holds. This database should aim to have all the following requirements:

It should be normalised to at least 3rd Normal Form

Foreign keys should be used to link tables, with appropriate referential action being taken

The total number of hours worked by each member of staff should be calculated and stored in either the most appropriate base table or in a view.

This database should then be populated using example data from the document provided. You do not need to enter all the data, but enough should be added that the database can be tested.

Task 2: creating a web interface

You should already be able to access your database using MySQL to run queries and make updates to the data. For ease of use by staff members, it would be better if they could access the data through a web interface.

Using PHP, create a web page that allows users to query and update the database according to likely roles and tasks. These may include the following:

Search for a staff member and return the classes they are teaching

Search for a module and return information about who is teaching it

Display all staff who are timetabled for more than 12 hours a week of classes

Show all modules that do not currently have staff assigned

Add a module, or make changes to any existing modules

Remember that the users will not be expected to have knowledge of SQL queries -- they should be able to query the database by selecting options on the web page, for example using menus or selection boxes.

5. Deliverables

You will need to deliver a short report as part of your assignment. This will include the following:

a definition for each relation, listing the attributes and the primary/foreign keys

for each relation, details of the functional dependencies which exist within it

a short description of how you ensured that the database is normalised

The exported SQL files and PHP files that you created need to be delivered. These will also be demonstrated to your tutor in class so they can test the database and you can explain how it works.

The weekly worksheets for weeks 1-5 should be submitted along with the files and report.

Skills: MySQL, PHP

See more: who is develop php, web page php develop, web page design course description, webpage design codes, web design short course, update data base by form & php, search for a member, primary modules, php mysql query form calculate, php form search mysql database, php codes to create a form, job objectives, how to make a web, how to do a report, how to develop webpage, how to develop php, how to develop database in access, how to design your room, how to design a room, how to create webpage, how to create web design and it codes, how to create a webpage, how to create an web page, how to create a design, how to create a database using php

Project ID: #5210155

16 freelancers are bidding on average £224 for this job

buraqtech

1. Crowd Funding Site In these days we are already near to finish a full CMS based crowd funding site which is a clone of kickstarter but we implemented many unique features in this project to distinguish it from kic More

£242 GBP in 7 days
(78 Reviews)
7.9
AcuityInfotech

Hi, We’ve had a good look at your project description and we’re very interested in providing a solution . We are a professional development company headquartered in Virginia and have more than 600 jobs under ou More

£263 GBP in 3 days
(25 Reviews)
6.7
urmate

Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks

£180 GBP in 3 days
(73 Reviews)
5.7
Churaliya

Hello Sir, I have good experiences in these kind of work. I can do this job for you ASAP. Please check my feedback and award me the project. Thanks.

£166 GBP in 5 days
(27 Reviews)
5.6
evidcomm

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project More

£250 GBP in 7 days
(29 Reviews)
5.5
xplorr007

A proposal has not yet been provided

£263 GBP in 3 days
(37 Reviews)
5.1
mmadi

Hi, I'll be happy to do that for you. Examples of work: http://www.travelfox.com/ http://www.sdcweb.org/ http://www.dcdouglas.com/ I am ready to work with you,kindly waiting for your response.Thank yo More

£242 GBP in 15 days
(17 Reviews)
4.8
rana100

Hi, I am a php mysql expert. I am ready to work in your project. Pls look at some portfolio I am expert in E-commerce http://prepare2win.com/ http://fuzionvapor.com/ http://www.tamilmelisai.com/ http More

£277 GBP in 10 days
(14 Reviews)
4.7
elboukharimu

Hi I'm very interested helping you on your database assignment, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there More

£231 GBP in 7 days
(15 Reviews)
4.3
hashlive1

Hi Thanks for posting the job with a clear requirement.I have read the whole thing very minutely.After reading the description,I have some questions in my mind about the job though I am confident to assuring you th More

£150 GBP in 6 days
(3 Reviews)
3.8
rvtechsolution

Hello, We have reviewed your post and we are confident that we can design and develop a PHP/Joomla/ WordPress/Cakephp/Codeigniter/ajax/css/html website with mysql as backend if required with web2.0 design for you a More

£257 GBP in 4 days
(9 Reviews)
3.5
tanlee

Hello, here with i am explaining what i understood from your requirements. Admin panel: 1.There should be one UI to upload all the users of the university on the whole. these are the users those are being ass More

£250 GBP in 15 days
(2 Reviews)
2.6
abbaspalash

A proposal has not yet been provided

£206 GBP in 3 days
(1 Review)
1.4
alltechinfohub

Dear Hiring Manager, We have gone through your requirements and found that you want someone proficient in data base. As per your requirement we would like to share our past work with you: www.indoreinstitute.com ww More

£144 GBP in 3 days
(0 Reviews)
0.0
rizzie88

i'm experience at web aplication programming, especially using php, jquery and mysql. for your information, i'm working for bank as IT programmer at indonesia.

£244 GBP in 5 days
(0 Reviews)
0.0
Perfexus

Hello Greetings! We went through your project description and came to the conclusion that this project has two parts. First, creation of normalized timetabling database and second, creation of a web front end using w More

£277 GBP in 10 days
(0 Reviews)
0.0
tree1891

제안이 아직 제공되지 않았습니다

£150 GBP in 3 days
(0 Reviews)
0.0