Design and implement a database for a new online

Assignment Help Computer Engineering

Reference no: EM133626678

Question: 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 450 wor ds.)

Reference no: EM133626678

Questions Cloud

What type of printer are you maintaining : You are adding paper to a printer that uses tractor-feed paper, which requires lining the holes up with pins on the paper-forwarding mechanism

Why do you think that major requires the class : You may wish to write about how this class fits into your academic and career goals. What is your major? Why do you think that major requires this class?

What is significance of including a strong right-to-audit : What is the significance of including a strong right-to-audit clause in a vendor contract for a technology company?

Nursing interventions for each SMART goal : What are 3 SMART goals for each diagnosis with nursing rationale. What are 6 nursing interventions for each SMART goal?

Design and implement a database for a new online : 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

What is a software vulnerability that allows unauthorized : What is a software vulnerability that allows unauthorized access to or control of computer systems?

What is the population-sample of the study : What is the population/sample of the study? Is this an observation or an experiment? How do you know? List one thing you found interesting in the study.

Develop patient teaching plan : You take any of the case studies we did this semester and develop a patient teaching plan to manage the actual or anticipated side effects.

Write a query that returns a list of sub_categories : Write a query that returns a list of sub_categories along with their average quantity and average cost, both rounded to 2 decimal places

User Account

All Pages