SCENARIO: Cougar Pizza Pies is a new concept in pizza delivery. Dylan and Samant
ID: 3919026 • Letter: S
Question
SCENARIO:
Cougar Pizza Pies is a new concept in pizza delivery. Dylan and Samantha Morgan have been serving high-class pizzas for over 20 years but have decided to take a new direction with their next pizza concept. Instead of focusing on an ever-increasing variety of specialty pizzas, the Morgans have decided to turn the value concept toward the high-volume, late-night pizza-delivery business. Certainly, being close to Atlanta United University, home of the Cougars, and its 38,000 students provides a deep and growing market for their business. As such, the Morgans are creating Cougar Pizza Pies to sell and deliver pizzas only between midnight and 4:00 a.m. A view of the current competitive landscape shows that no other business is currently targeting that same market.
The Morgans believe that the simplest business model will bring them the best success in their desired market. As such, the new restaurant will not have any seating (as most orders will be delivered), but it will allow for pickup of pizzas if needed. It will also have a limited menu of pizza types (thin, regular, or pan) and a limited topping list (pepperoni, sausage, ham, and extra cheese) in order to facilitate the high sales volume expected. Also, to coordinate special instructions from customers (delivery access, cooking preferences, etc.), the Morgans would like to have an area where they can add customer notes to orders.
Following their simplicity model, the Morgans have fixed their prices as follows:
? Thin and Regular Crust: $13.00
? Pan Pizza: $15.00
? Toppings: $2.00 each
Furthermore, for marketing outreach and research purposes, they would like to track orders by phone number, street address, city, state, and zip code.
The Morgans would like to determine and validate that their new business is profitable and businesssavvy. Thus, they have hired you to design a database that supports the validation of the late-night pizza-delivery business. Along with any considerations mentioned above, they know they need to be able to track the following details in a database:
· Pizza orders, including toppings added.
· Customer who ordered pizza.
· Address pizza was delivered to.
· Name and phone number of employee who delivered pizza.
· Name of employee who took pizza order.
· Sales per hour, day, week, and month.
· Delivery status details at various points in the night. Each order should have a status along with the order date and time and the delivery date and time. Note that if a customer picks up the pizza, the pickup time is the delivery time.
Some other considerations for the ordering process include the following:
? A customer can certainly order more than one pizza.
? Customers move often and may order from different locations (a friend’s house ,for instance), so address details may also change often. However, each customer would have one preferred address.
? Most orders need to be completed and delivered within an hour.
? The Morgans envision opening other stores in other college towns if this venture is successful, so they would like this database to handle multiple stores.
The Morgans are hoping to implement the database very soon, most certainly within the next few months.
PROJECT
Overview: Database design is an integral step in the overall development of a database solution; a bad design can lead to many issues and problems with queries and potential expansion for any database. Getting the database design right is the first and most important step in creating a successful database.
Prompt: In Milestone One, you read the final project scenario and then gathered the business requirements based on the goals, objectives, and user and business needs.
For this milestone, you will frame the entity relationship model (ERM) and define the entities and attributes for the business. Your next steps will be to normalize your entities, define primary and foreign keys, and finally, draft an initial entity-relationship diagram (ERD).
Specifically, the following critical elements must be addressed:
II. Conceptual Design: Using your analysis of the provided scenario, address the following in order to determine an appropriate entityrelationship model (ERM) that will inform your final design:
Assess various ERMs for their design applicability to your database design.
Hint: In this section, define the process you have used, and note several considerations you have made in your choice of specific entities and attributes. Be sure to list the various entities and attributes that are of interest based on the scenario. Some entities and attributes may not ultimately be included in your initial or final design and ERD.
Determine the appropriate ERM and explain your choice.
Hint: Describe the appropriateness, reason, or basis for why certain entities and attributes would be included in your design and others would be left out.
Identify the data sets for the database, including all entities and attributes.
III. Design Revision: During this stage, you will draft your entity-relationship diagram (ERD), addressing the following elements:
A. Construct your ERD, utilizing your identified entities and attributes.
B. Determine appropriate primary and foreign keys for each entity and note them on your ERD.
C. Determine table relationships and note them on your ERD.
D. Determine appropriate data types and sizes for each attribute and note them on your ERD.
E. Complete the normalization process utilizing dependency diagrams in order to prove tables are in third normal form (3NF), and adjust your ERD if necessary.
Hint: For each entity and table, complete dependency diagrams proving the table is in 3NF. If a table is in 3NF, only one diagram is needed; if it is not in 3NF, progress through the normalization process, breaking up tables as necessary. Additionally, revise your ERD based on the results of your normalization process.
Explanation / Answer
ANSWER:
A cloud database is a scalable content database running on a cloud computing platform that could be private, public or hybrid.
There are two cloud database environment models, namely, Traditional cloud model and Database-as-a-service (DBaaS).
In the Traditional cloud model, the content database will be run on the particular enterprise’s infrastructure and any oversight will fall into the shoulders of IT staffers of the company.
On the other hand, DBaaS runs on the service provider’s infrastructure and they (the vendor) would be responsible for any hitches or glitches should they occur.
The service provider assumes the full responsibility of handling client database leaving them to focus on operations and business goals.
X
Here are the main advantages of cloud databases:
1. Getting rid of physical infrastructure?—?It is the responsibility of the cloud service provider to maintain the database, provide storage and other infrastructure.
2. Scalability?—?Contracting with DBaaS, allows for automatic scalablilty most of the time, during peak business hours or unexpected spikes during festivals and special days.
3. Cost effectiveness?—?Reduced capital expenditure for enterprises is another advantage, because they no longer have to worry about operational costs or upgrading the infrastructure because all this will be handled by the cloud vendor.
4. Latest technology availability?—?Enterprises no longer have to worry about shelling money on buying new technologies because updated infrastructure is the headache of the cloud vendor.
5. Usability: All cloud storage services reviewed in this topic have desktop folders for Mac’s and PC’s. This allows users to drag and drop files between the cloud storage and their local storage.
6. Bandwidth: You can avoid emailing files to individuals and instead send a web link to recipients through your email.
7. Accessibility: Stored files can be accessed from anywhere via Internet connection.
8. Disaster Recovery: It is highly recommended that businesses have an emergency backup plan ready in the case of an emergency. Cloud storage can be used as a back?up plan by businesses by providing a second copy of important files. These files are stored at a remote location and can be accessed through an internet connection.
Disadvantages of Cloud Storage
1. Usability: Be careful when using drag/drop to move a document into the cloud storage folder. This will permanently move your document from its original folder to the cloud storage location. Do a copy and paste instead of drag/drop if you want to retain the document’s original location in addition to moving a copy onto the cloud storage folder.
2. Bandwidth: Several cloud storage services have a specific bandwidth allowance. If an organization surpasses the given allowance, the additional charges could be significant. However, some providers allow unlimited bandwidth. This is a factor that companies should consider when looking at a cloud storage provider.
3. Accessibility: If you have no internet connection, you have no access to your data.
4. Data Security: There are concerns with the safety and privacy of important data stored remotely. The possibility of private data commingling with other organizations makes some businesses uneasy. If you want to know more about those issues that govern data security and privacy, here is an interesting article on the recent privacy debates.
5. Software: If you want to be able to manipulate your files locally through multiple devices, you’ll need to download the service on all devices.
Recommended CLOUD DATABASE
AMAZON WEB SERVICES:
Amazon Web Services has a variety of cloud-based database services, including both relational and NoSQL databases. Amazon Relational Database (RDS) run either MySQL, Oracle or SQL Server instances, while Amazon SimpleDB is a schema-less database meant for smaller workloads. On the NoSQL side, Amazon DynamoDB is its solid-state drive (SSD)-backed database that automatically replicates workloads across at least three availability zones. AWS CTO Werner Vogels says DynamoDB is AWS's fastest growing service in AWS history. Amazon also offers a variety of auxiliary data management services, such as its newly announced data warehouse named Redshift, as well as Data Pipeline, which helps users integrate data from multiple sources for easier management.
Amazon RDS:
Amazon RDS provides three storage types: General Purpose (SSD), Provisioned IOPS (input/output operations per second), and magnetic. They differ in performance characteristics and price, which means that you can tailor your storage performance and cost to the needs of your database workload. When using the Provisioned IOPS and General Purpose (SSD) storage types, you can create MySQL, MariaDB, Microsoft SQL Server, PostgreSQL, and Oracle RDS DB instances with up to 16 TiB of storage.
PERFORMANCE Metrics of Amazon RDS:
COST For AMAZON RDS:
Amazon RDS is free to try. For commercial use Pay only for what you use. There is no minimum fee. You can pay for Amazon RDS using On-Demand or Reserved Instances.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.