baolam420 posted a question Oct 16, 2013 at 10:13pm
Case Study Assignment 3: The Entity Relationship Diagram The goal of this exercise is for you to begin to understand how the tables in a database relate. For this assignment, you will need to create an entity relationship diagram (ERD) similar to the one in Figure 7.1 in your textbook. Consider the data tables you will need in order to bring the Broadway Cafe into the 21st century. You know you have customers and orders and inventory (you will need to think about more things you will need - be creative!). Each of them may require numerous tables (as per the examples given). Think about the fields needed in each table. For example, your customer database needs: ◦names ◦addresses ◦a customer ID ◦customer status (active, inactive, preferred, etc) ◦what else? How about your orders table? What else might you need? Your ERD must clearly label primary keys and foreign keys, and show their relationships so that they are easy to follow. I recommend creating these tables in Word or Excel or PPT, and then uploading the finished product when done by clicking BROWSE, below, and then submitting your work. You will be graded on the quality and completeness of your submission please look at the attached file ( Figure 7.1 ) as he said .
Attachment Preview:
  • baL76841_ch07_086-097.pdf Download Attachment

    Confirming Pages



    Storing Organizational



    Define the fundamental concepts of the relational
    database model.
    Evaluate the advantages of...
    Show more

Additional Requirements

Min Pages: 1
Max Pages: 2
Level of Detail: Only answer needed
Other Requirements: Semester Case Study Instructions

Please read the following information about your semester case study project on the Broadway Cafe. There are several deliverables associated with this case study, which will be due throughout the semester. All the deliverables for this week are due before midnight the week after they are assigned. (No extensions will be granted!)

Here is background on your case study:

The Broadway Cafe Case Study

You have recently inherited your grandfather's coffee shop, The Broadway Cafe, which is conveniently located in downtown Troy, MI (not far from the Walsh College campus). The cafe offers many different kinds of specialized coffees, teas, a full service bakery, and homemade sandwiches, soups, and salads. Your grandfather first opened The Broadway Cafe in 1952 and it was a local hotspot for many years.

Unfortunately, business has been steadily declining over the last five years. Although your grandfather was an expert at running the coffee shop, it is outdated. There are no computers in the store and all ordering takes place manually. Your grandfather had a terrific memory and knew all of his customers by name, but unfortunately, none of this information is located anywhere in the store.

The family recipes for the baked goods and soups are also stored in your grandfather's memory. Inventory is tracked in a note pad, along with employee payroll, and marketing coupons.

The Cafe does not have a Web site, uses very little marketing except word-of-mouth, and essentially still operates the same as it did in 1952.

Throughout this semester you will "own and operate" The Broadway Cafe, taking advantage of business practices discussed in this text to increase profits, keep the business running, and bring the cafe into the 21st century.

Now that you've read the background information for The Broadway Cafe, visit Case Study Assignment 1 in this module to get an idea what is expected of you. Once you have completed your work, you will upload your work to the form provided on the Case Study Assignment 1 link

answered the question Oct 17, 2013 at 11:56am
Questions Answered: 416
Please find attached doc file, it will open definitely. Let me know in case of any issue.  

Download Preview:

ER Diagram

Note : Used MS access for creating it

"Great Job"