cpt310week1

docx

School

University Of Arizona *

*We aren’t endorsed by this school

Course

CPT310

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

5

Uploaded by AdmiralElephant282

Report
Denise Smith Week 1 Assignment: Online Food Ordering CPT 310: Database Systems & Management Professor Lisa Sims 05/19/2022
DATABASE: Online food ordering for restaurants delivery STAKEHOLDER/ENTITIES : Customer. Restaurants, Menu/Ordering, Delivery Service/Person, Payment Details ATTRIBUTES: Customer info= This section or area of my database provides users with client details such as a created username, password for future orders, and pertinent info such as the clients name and contact info, and wht that customer has ordered. (C_id,C_Uname,C_pword,c_address,c_firstname,c_lastname,c_mobile,c_email,c_phnec_address ,c_ordered_items)
Restaurants info= This section or area of my database provides users, delivery person, and customers the restaurants details such as an address, contact, menu, and coupons or offers. (R_id,R_address,telephone_no,menu,offers) DeliveryService/Person= This section or area of my database provides users, and customers the delivery service or persons information such as address, items ordered, delivery address and contact details (D_id,D_name,address,mobile,delivery_address,item,c_id,R_id) Payment= This section or area of my database provides users, customers pay details and secure methods of payment for receipts for the customer and the restaurants. (P_id,invoice,P_method,amount,C_name,R_name)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
  MySQL is the best choice over other database management systems   because it is completely user-friendly. It is also an Open source and is cost effective, great performance abilities, and impressive features full of relational database management. It doesn’t rely on database administrator because it is that simple to operate for someone like myself and most users. Another benefit of using MySQL is also a client/server system that serves well for my online food ordering and many other types of businesses. Another important feature is that it takes security and handling sensitive information very seriously. MySQL is known around the country as a secure dependable database management system and used today in many popular and highly renown web-based applications. It is also designed to handle very high demand projects and applications at optimal speed with accuracy and has a variable memory cache that further enhances it overall performance. It is also worth noting that MySQL is extremely convenient because it can be used on many different operating systems and create databases supported by other languages. Another fact is now it has joined into cloud services which allows a user more options with multiple projects it can complete in a timely fashion. The DBMS supports foreign key constraints and all character sets even Latin-1, Latin-2, and Unicode. There are a plethora of different reasons why I would choose MySQL but overall compared to other database management systems that are available and it ranks the highest all of my most important and essential needs in the areas of effectiveness, functionality, speed, and price point. References: Coronel, C., & Morris, S. (2019). Database systems: Design, implementation, and management (13th ed.). Retrieved from https://www.vitalsource.co
Gravelle, R. (2018, August 09). The Best (and Worst) Cloud Services for MySQL. Retrieved October 30, 2020, from https://www.databasejournal.com/features/mysql/slideshows/thebest- and-worst-cloud-services-for-mysql.htm

Related Documents

SYST26671 Assignment 1.docx
DePew Assignment 8.docx
ENV:430 week 4 discussion.docx
CYB_100_Project_One_Fabian_Richards.docx
6-2 Project One Submission- Network Modification Brief- Fabian Richards.docx
cpt307 weekone assignment .docx
cpt week 2 assignment.docx
Workbook for Fordney's Medical Insurance - Assignments Chapter 15.docx
Exam Notes (2).docx
SYLLABUS- COMS 2200.docx
SU_NSG6601_W2_A3_Sornoza_S.docx
SU_NSG6601_W4_A2_Sornoza_S.docx
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS