Online Food Ordering Database – Task 1
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 pape
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 UAGC's The Writing Center.
Must include a separate title page with the following:
Title of pape
Student’s name
Course name and numbe
Instructor’s name
Date submitted
Must document all sources in APA style as outlined in the UAGC Writing Center.
Must use at least one scholarly, peer-reviewed, and/or credible sources in addition to the course text.
The Scholarly, Peer Reviewed, and Other Credible Sources table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
Must document all sources in APA style as outlined in the UAGC Writing Center.
Must include a separate references page that is formatted according to APA style as outlined in the UAGC Writing Center.