Find Jobs
Hire Freelancers

To develop a MySQL database which can be accessed via a web page.

$250-750 USD

Completed
Posted over 10 years ago

$250-750 USD

Paid on delivery
2. Aim and Objectives 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. 4. Instructions 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.
Project ID: 5208582

About the project

23 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear sir, I have read the requirements, and I am confidently guarantee to deliver it with the best quality. Thanks and regards, Yasser
$300 USD in 1 day
5.0 (130 reviews)
7.1
7.1
23 freelancers are bidding on average $437 USD for this job
User Avatar
homework expert here. homework expert here. homework expert here. homework expert here. homework expert here.
$315 USD in 5 days
5.0 (467 reviews)
7.4
7.4
User Avatar
I am willing to discuss further details about the project specifications and deliver the same to your needs.
$631 USD in 6 days
4.8 (130 reviews)
7.4
7.4
User Avatar
Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service exciting my customers. Please contact in PMB to discuss details. Best Regards, Zeke
$515 USD in 10 days
4.6 (199 reviews)
7.5
7.5
User Avatar
Hello, I am very much interested to work on your project. I have a lot of knowledge about PHP and MySQL. I did Masters in Software Engineering. I know all this inside out :) I will create a Normalized database for you and also a web page from where user will be able to use it easily. A Friendly Interface :) Lets discuss it in more detail, and get it done as soon as possible. Thanks
$578 USD in 15 days
5.0 (101 reviews)
6.6
6.6
User Avatar
Hi, I am interested to work on this project. Please Start discussion with me. I am waiting for your reply. So lets begin. Thanks, Swapnil
$500 USD in 4 days
4.8 (63 reviews)
6.5
6.5
User Avatar
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.
$500 USD in 10 days
5.0 (44 reviews)
6.2
6.2
User Avatar
Hello There I think i can help you out to achieve this task However as the system demands we need to interact before we start. so hoping for ur quick reply thanks
$333 USD in 21 days
4.9 (57 reviews)
6.1
6.1
User Avatar
A proposal has not yet been provided
$360 USD in 12 days
4.9 (20 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$555 USD in 3 days
4.6 (51 reviews)
5.0
5.0
User Avatar
Sir, I have read the project details clearly and I am ready for it. I can assure you of perfection in my work and the work will be of high accuracy. Eagerly waiting for your reply. Thank you. Why you select me? 1. Almost worked on 50+ project. 2. Worked on the many CMS based project. 3. Worked on various JS, JQuery Plugin. 4. Worked on various Multi Language website. 5. Oracle Certified Professional 6. Problem Solving Skill 7. Passionate Developer I can assure you quality output. Please provide me a opportunity to work with you. You will definitely enjoy it.
$277 USD in 20 days
5.0 (16 reviews)
4.4
4.4
User Avatar
Sir, Is the project cost range really $250 - $750? I can do this job easily. Please see my freelancer profile. I will be waiting for further communication from your end. Thanks, Lalith
$277 USD in 3 days
5.0 (3 reviews)
2.9
2.9
User Avatar
Hi ! I have a strong expertise in Website development using HTML, Wordpress,Joomla, Magento, CodeiIgniter, PHP, MySQL. I have also handled lots of project with Graphic Desgining with 100 percent accuracy. Please let me know if u want to see my previous work samples!
$350 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
icannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
$250 USD in 5 days
0.0 (1 review)
0.0
0.0
User Avatar
Hello sir, I totally understand what you want. I've experience in this type of work. So hire me and than I'll show you my work.. I'll provide you what ever you want... Hire me.............. I'm waiting for your response.........
$250 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir/Madam, We are team of 10 years of average experience in MNCs where we have delivered many complex projects on time with high quality. We have experience in handling multiple databases Mysql, Oracle, DB2 etc. with extensive knowledge on SQL and PL/SQL programming languages. We also have good exposure on web technologies and hands on experience in PHP, HTML5 etc. For this requirement we would follow a systematic approach starting from strategy through design, development and implementation, keeping in mind the considerations of all the mentioned requiremnts and thus enabling a rich, robust and scalable solution. Below is our high level plan for delivery Day 1- Database and Web Interface Design Day 2- Developement of Web interface, Database and SQL queries. Day 3- Integration, Testing, Release. We would like to get in touch with you to have detailed discussion for this particular project. Thanks. Best regards, Lortech
$333 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Bury, United Kingdom
5.0
1
Member since Dec 8, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.