Question: Assignment Using the data in the Cake Order Database, decide what tables of data could be created, and what fields would be included in the

Assignment

  1. Using the data in the Cake Order Database, decide what tables of data could be created, and what fields would be included in the tables.
  2. Identify what field would serve as the primary key for each table. 5 pts
  3. Create an entity relationship diagram showing the tables (with fields) and relationships among the tables. 15 pts
  4. What other data could be included in this database? What benefits are there from organizing the data this way as opposed to in an Excel file? 5 pts
  5. Assemble into ONE Word document. Professionalism, Neatness and Organization. 5 pts

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Divvy Pricing: Divvy has two primary classes of users: subscribers and customers. Subscribers pay an annual fee of $99 for unlimited rides limited to 45 minutes in duration. Customers may pay either...

Q:

Background: Remington's Steak House is a retail theme restaurant located in a large midwestern city. Its main competitors are Outback Steak House and Longhorn Steak House. In order to better...

Q:

The data are total annual returns for the S&P 500 (net price appreciation plus dividends) from 1928 through 2021. The value is a percent return. (Important note: Percent (%) signs were not included...

Q:

Please help: Module 5 : Activity B Overview This assignment is designed to help you understand how to model a relational database. Assignment Using the data in the Cake Order Database, decide what...

Q:

The purpose of this study is to collect data on people's computer usage habits. The data collected will be both quantitative and qualitative. The quantitative data will include how many hours per day...

Q:

Note: Use the data in the Excel work sheet named 'Mini Assignment 3_data' for this assignment. Using the data in Sheet 1 of the Excel data sheet, estimate the index model,

Q:

Note: Use the data in the Excel work sheet named 'Mini Assignment 3_data' for this assignment. Using the data in Sheet 1 of the Excel data sheet, estimate the index model

Q:

Cost-volume analysis is commonly done in two components: breakeven point and make vs buy. Bothare useful analytical methods to check the economic and capacity feasibility of an aggregate plan. They...

Q:

Answer all FIVE Questions Some critics of television complain that the amount of violence shown on television contributes to violence in our society. Others point out that television contributes to...

Q:

Question 1 , T - tests \ table [ [ , gender,& Age,Height, \ table [ [ { f 2 7 d 5 6 b 2 0 - 9 6 2 9 - 4 7 9 4 - af 4 f - cd 0 1 d 2 3 3 0 a 9 0 } \ table [ [ pre . weig ] , [ ht ] ] ] ] , Diet, \...

Q:

Your company builds a new plant with an investment of $200 million and an expected present value from its future cash flows of $250 million. A year later, it becomes apparent that the new product...

Q:

A restaurant wants to locate themselves somewhere in the NRV. They have identified their four many markets as Radford, Blacksburg, Salem, and Roanoke. They have also determined that each of these...

Q:

10. The element with proton number 12 has similar chemical properties to the element with proton unde (a) 2 (b) 11 (c) 13 (d) 20

Q:

Julian Birkinshaw, James Manktelow, Vittorio DAmato, Elena Tosca, and Francesca Macchi In recent years, one of the most profound transformations in the workplace has been the increase in age...