Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


CPT 310 Ashford University Week 5 User Guide for Database Scripts Paper

CPT 310 Ashford University Week 5 User Guide for Database Scripts Paper

Prior to beginning work on this assignment, it is recommended that you review all of your previous readings to better assist you with completing the Final Project.

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 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. 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 style as outlined in the Ashford Writing Center (Links to an external site.).

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Fox Writers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Fox Writers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Fox Writers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Fox Writers, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.