Online Food Ordering Database

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.
Once you have completed the final database with all associated scripts, save them into a zip folder, and submit it to the Week 5 Zip File Submission page. Your zip folder should include two SQL scripts (CreateDB.sql and PopulateData.sql). If you need more guidance, review the Zip File Quick Start Guide Download Zip File Quick Start Guide. Next, submit your User Guide through the Waypoint grading system. Your instructor will run your SQL scripts following your instruction to ensure that the SQL scripts you provided generate the Online Food Ordering Database and populate data in its tables.
The Online Food Ordering Database Final Project:
Must include CreateDB.sql and PopulateData.sql scripts.
Must include a User Guide with the URL for the screencast video presentation.
Must include a Screencast that is eight to 10 minutes in length.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must document all sources in APA
Below are the weekly assignments that i had to do
week 1
You are hired by a software company to design and implement a database for a new online food ordering website. As an expert in MySQL, you suggest building the new database using MySQL. Your project manager has agreed and requested an initial list of at least three to four types of stakeholders (entities) and their related initial list of at least four to five attributes to be included in your design of the database. To assist you, the project manager shared with you the following list of similar information (that was previously generated for a clinic management system) to help you compile and organize your list of defined stakeholders and their attributes:
Doctor (d_id, d_username, d_password, d_firstName, d_lastName, d_email, d_phone)
Nurse (n_id, n_username, n_password, n_firstName, n_lastName, n_email, n_phone)
Patient (PID, PFirstName, p_lastName, p_email, a_phone, p_adddress)
Diagnostic (DiagID, NID, NurseComment, DID, Diagnostic, Medicine, DiagDate)
In your paper,
Create a completed list of stakeholders and attributes for your Online Food Ordering database in a Word document.
Justify why MySQL is the best choice over other database management systems (DBMS) for your Online Food Ordering database on a separate page. (Your justification should be a minimum of 300 words.)
The Online Food Ordering Database – Task 1 paper
week 2
Create a complete Chen ER diagram design for the entities and attributes you have identified in Week 1. Include a screen shot of your diagram in your paper.
Create tables in Word that corresponds with the entities and attributes in your ER diagram. Your tables should include fields and data types for attributes, as well as the relationships between entities.
Describe the advantages and concepts of your Chen ER diagram and how the diagram will help shape the overall relationship between tables. Your description should be a minimum of 300 words.
week 3
If you designed separate tables for employee and department in your Week 2 assignment, you will want to combine the employee and department tables before you begin this assignment. Your combined table should be called tbl_employee. The tbl_employee contains information about the employee and its department, and it contains the following fields (you may also include other missing fields from your Week 2 design): employee_id, employee_gender ,employee_salary, employee_annual_sallary, department_name, department_location, department head.
For this assignment, you will make use of the database normalization skills you have learned to normalize your database to the third normalization form. You will need to organize your columns and tables to reduce data redundancy and arrange attributes based on the relationships.
In your paper,
Provide a screen shot of the database design before the normalization. Create a heading titled “Database Before Normalization.”
Provide a screen shot of the database design after the normalization. Create a heading titled “Database After Normalization.”
Describe the three normalization forms and the guidelines for transforming from lower normal forms to higher normal forms. Your description should be a minimum of 300 words.
week 4
For this assignment, you will use PHPMyAdmin to implement the normalized database you did in the Week 3 assignment including the following:
Implement all tables, fields, and relationships, and add appropriate constrains on some of the fields (e.g., numbers cannot be negative; dates cannot be in the future unless the requirement specify otherwise).
Assign primary and foreign keys to ensure data integrity and perform faster queries.
Generate an ER diagram from the implemented database.
Write SQL queries to add some data into the implemented tables.
Once you have completed Task 4, you must provide the following in a Word document and submit through the Waypoint grading system:
A screen shot of all developed tables in your database
A screen shot of the ER diagram
A screen of the SQL queries you used to populate data. Be sure also to provide a screen shot for the tables after the data is populated. Note: You should use “Select * from table_name” to view the content of the table
In addition to the screen shots,
Describe Data Definition Language (DDL) insert, update, delete. Your description should be a minimum of 600 words.
Provide at least one example.
Describe inner join, sum, and ordered by. Your description should be a minimum of 600 words.
Provide at least one example.
The Online Food Ordering Database – Task 4 paper

Last Completed Projects