Find Jobs
Hire Freelancers

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

£20-250 GBP

Κλειστή
Αναρτήθηκε πάνω από 10 χρόνια πριν

£20-250 GBP

Πληρωμή κατά την παράδοση
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.
Ταυτότητα εργασίας: 5210155

Σχετικά με την εργασία

16 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 10 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
16 freelancers δίνουν μια μέση προσφορά £224 GBP για αυτή τη δουλειά
Avatar Χρήστη
Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks
£180 GBP σε 3 ημέρες
4,9 (73 αξιολογήσεις)
5,7
5,7
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.
£166 GBP σε 5 ημέρες
4,9 (27 αξιολογήσεις)
5,6
5,6
Avatar Χρήστη
A proposal has not yet been provided
£263 GBP σε 3 ημέρες
5,0 (37 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
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 is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details about your database project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
£231 GBP σε 7 ημέρες
4,9 (15 αξιολογήσεις)
4,3
4,3
Avatar Χρήστη
A proposal has not yet been provided
£206 GBP σε 3 ημέρες
5,0 (1 αξιολόγηση)
1,4
1,4
Avatar Χρήστη
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 σε 5 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
제안이 아직 제공되지 않았습니다
£150 GBP σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
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 which database can be accessed and manipulated. This project needs technical skill set like Testing, PHP, JS, JQuery CSS, HTML, MYSQL and SQL together with strong algorithmic/logical sense for successful delivery. Perfexus team possesses necessary skill set and is highly interested in doing this project. We are a group of individuals having expertise in diverse sectors like Product Development, IT Services, Finance, Marketing, Sales, etc. We work in field of programming, testing, documentation, and data entry. We can deliver your work as per requirement which will be professional, accurate and presentable. Based on our experience we can also suggest some changes which will add value to your application. If you show interest we can discuss this project further. Thanks Perfexus Team
£277 GBP σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED KINGDOM
Bury, United Kingdom
5,0
1
Μέλος από Δεκ 8, 2013

Επαλήθευση Πελάτη

Άλλες δουλειές από αυτόν τον πελάτη

To develop a MySQL database which can be accessed via a web page.
$250-750 USD
Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.