Find Jobs
Hire Freelancers

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

$250-750 USD

已完成
已发布超过 10 年前

$250-750 USD

货到付款
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.
项目 ID: 5208582

关于此项目

23提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
5.0 (130条评论)
7.1
7.1
23威客以平均价$437 USD来参与此工作竞价
用户头像
homework expert here. homework expert here. homework expert here. homework expert here. homework expert here.
$315 USD 在5天之内
5.0 (467条评论)
7.4
7.4
用户头像
I am willing to discuss further details about the project specifications and deliver the same to your needs.
$631 USD 在6天之内
4.8 (130条评论)
7.4
7.4
用户头像
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 在10天之内
4.6 (199条评论)
7.5
7.5
用户头像
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 在15天之内
5.0 (101条评论)
6.6
6.6
用户头像
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 在4天之内
4.8 (63条评论)
6.5
6.5
用户头像
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 在10天之内
5.0 (44条评论)
6.2
6.2
用户头像
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 在21天之内
4.9 (57条评论)
6.1
6.1
用户头像
A proposal has not yet been provided
$360 USD 在12天之内
4.9 (20条评论)
4.5
4.5
用户头像
A proposal has not yet been provided
$555 USD 在3天之内
4.6 (51条评论)
5.0
5.0
用户头像
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 在20天之内
5.0 (16条评论)
4.4
4.4
用户头像
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 在3天之内
5.0 (3条评论)
2.9
2.9
用户头像
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 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
icannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
$250 USD 在5天之内
0.0 (1条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
Bury, United Kingdom
5.0
1
会员自12月 8, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。