PhpMyAdmin Tutor ~ Creating an Online Food Ordering Database
Budget: $15 – $25 USD
I am looking to hire a tutor to help me with a homework assignment. I am creating an online food ordering database and need a tutor to help me with understanding the PhpMyAdmin interface and help me to write SQL code to finalize the database. I estimate that I will need about 6 hours of tutoring. Requirements:
1. Must be competent at speaking English.
2. Must be able to do screen share using skype.
3. Must have experience in PhpMyAdmin and SQL coding
4. Must be available this Sunday or Monday for tutoring (9/25/21, 9/26/21)
5. Must be able to provide 6 to 8 hours of tutoring
The database is almost completed (see attached picture). I need help adding triggers to the_employee_audit table. Here is the description of the assignment:
The Final Project for this course is an accumulation of previous weeks’ assignments in which you will utilize all of the skills you have acquired in this course to implement an Online Food Ordering Database using the latest PHPMyAdmin version. In each week of the course, you performed various tasks toward creating the Online Food Ordering Database. Now you will create SQL scripts that regenerate the tables, relationships, and data of the Online Food Ordering Database.
In Week 1 (Task 1), you defined the system stakeholder, and you recognized the importance of understanding organizational stakeholders for database design success. In Week 2 (Task 2), you provided a complete Chen ER diagram design and corresponding list of tables. In Week 3 (Task 3), you normalized your database to the third normalization form. In Week 4 (Task 4), you used the latest version of MySQL to implement the tables and relationships of the database you normalized in Week 3. Finally, in Week 5 (Task 5), you added “for insert” and “delete” triggers to the “tbl_employee” table to track which employee updated the Online Food Ordering Database.
Now you will incorporate all the feedback you received for the work you created in previous weeks and Provide a MySQL script to recreate the final database you implemented in the previous tasks.
The script should recreate all the tables, constraints, views, and triggers you have implemented. Name the SQL script “CreateDB.sql”
Provide a MySQL script to add several rows to each of the tables you created.
Do your best to use data and formatting that mimics what is used in a real online ordering system (i.e., emails, first name, last name, credit card information, etc.). Name the SQL script “PopulateData.sql”
Create a step-by-step user guide on how to run the above scripts to create the database from scratch using the “CreateDB.sql” and to populate some data into the generated tables using the “PopulateData.sql.”
Title this document “User Guide.” Your user guide should be detailed enough to include your comments describing the SQL functionalities and overall tasks, along with screenshots of all steps and their outputs.
Create a screencast video presentation using Screencast-O-Matic in which you walk the instructor through your Online Food Ordering Database.
(Quick-start guides for Screencast-O-Matic (Links to an external site.) are provided for your convenience.) Be sure to describe the concepts related to the design and management of your database.
Your screencast should be eight to 10 minutes in length. (It is highly recommended that you create a script and/or speaker’s notes to ensure that your screencast will meet the time requirements. This will also allow you to practice your presentation prior to recording it.)
Once your screencast has been created, make sure to include the URL for your screencast at the end of your User Guide.
1. Must be competent at speaking English.
2. Must be able to do screen share using skype.
3. Must have experience in PhpMyAdmin and SQL coding
4. Must be available this Sunday or Monday for tutoring (9/25/21, 9/26/21)
5. Must be able to provide 6 to 8 hours of tutoring
The database is almost completed (see attached picture). I need help adding triggers to the_employee_audit table. Here is the description of the assignment:
The Final Project for this course is an accumulation of previous weeks’ assignments in which you will utilize all of the skills you have acquired in this course to implement an Online Food Ordering Database using the latest PHPMyAdmin version. In each week of the course, you performed various tasks toward creating the Online Food Ordering Database. Now you will create SQL scripts that regenerate the tables, relationships, and data of the Online Food Ordering Database.
In Week 1 (Task 1), you defined the system stakeholder, and you recognized the importance of understanding organizational stakeholders for database design success. In Week 2 (Task 2), you provided a complete Chen ER diagram design and corresponding list of tables. In Week 3 (Task 3), you normalized your database to the third normalization form. In Week 4 (Task 4), you used the latest version of MySQL to implement the tables and relationships of the database you normalized in Week 3. Finally, in Week 5 (Task 5), you added “for insert” and “delete” triggers to the “tbl_employee” table to track which employee updated the Online Food Ordering Database.
Now you will incorporate all the feedback you received for the work you created in previous weeks and Provide a MySQL script to recreate the final database you implemented in the previous tasks.
The script should recreate all the tables, constraints, views, and triggers you have implemented. Name the SQL script “CreateDB.sql”
Provide a MySQL script to add several rows to each of the tables you created.
Do your best to use data and formatting that mimics what is used in a real online ordering system (i.e., emails, first name, last name, credit card information, etc.). Name the SQL script “PopulateData.sql”
Create a step-by-step user guide on how to run the above scripts to create the database from scratch using the “CreateDB.sql” and to populate some data into the generated tables using the “PopulateData.sql.”
Title this document “User Guide.” Your user guide should be detailed enough to include your comments describing the SQL functionalities and overall tasks, along with screenshots of all steps and their outputs.
Create a screencast video presentation using Screencast-O-Matic in which you walk the instructor through your Online Food Ordering Database.
(Quick-start guides for Screencast-O-Matic (Links to an external site.) are provided for your convenience.) Be sure to describe the concepts related to the design and management of your database.
Your screencast should be eight to 10 minutes in length. (It is highly recommended that you create a script and/or speaker’s notes to ensure that your screencast will meet the time requirements. This will also allow you to practice your presentation prior to recording it.)
Once your screencast has been created, make sure to include the URL for your screencast at the end of your User Guide.