Prior to beginning work on this assignment, read Chapter 1: Database Systems and Chapter 2: Data Models from the course text. In each week of this course, you will build a component of your Online Food Ordering Database, which is your Final Project for the course, due in Week 5. For this assignment, you will complete the first task of designing the Online Food Ordering Database.

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

  • Must include a completed stakeholders and attributes list.
  • Must include justification for using MySQL that is a minimum of 300 words and be formatted according to APA style as outlined in the Ashford Writing Center (Links to an external site.).
  • 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.
  • Must use at least one scholarly, peer-reviewed, and/or credible sources in addition to the course text.
  • Must document all sources in APA style as outlined in the Ashford Writing Center.
  • Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center.

Note: In preparation for next week’s assignment, it is recommended that you start reviewing the following tools that you will be using to design and develop your database.

  • Microsoft Visio or any other Chen Entity Relationship (ER) Diagram tool
    • These tools will allow you to graphically design schemas for databases and show the relationships between information tables stored in the database. Diagrams help to ensure that the database you are designing is accurate, complete, and efficient.
  • The latest version of PHPMyAdmin.

PHPMyAdmin (Links to an external site.) is a free open source application that is designed to administer the database management system (DBMS) – MySQL. PHPMyAdmin is a web-based interface with which you can administer your server MySQL, run commands, and view the contents of tables and databases through a browser.

Order your Assignment today and save 15% with the discount code ESSAYHELP

X