Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There are employees who work on a caf shop. Each employee has a name, ID, date of birth, address, sex, and salary. The caf

There are employees who work on a caf shop. Each employee has a name, ID, date of birth, address, sex, and salary. The caf shop offers a menu that includes items IDs and names, a description of those items, and their prices. The employee creates many orders that are requested by customers. Order can include many items and thelitem can be in many orders with keep track the quantity of each item. In each order there are an invoice number, date and time of created this order, and total price. Each customer will give a number to pick up the order by this number. Note that customer can request many orders but each order is requested by one customer and created by one employee. Mark Student of Task Mark outcomes (a)ldentifying the Entities/Relations and their meaningful Attributes. 2 1.1 (b) Relationships between Entities. 2 2.2 (c) drawing an Entity Relationship Diagram with all constraints. 2 2.2

Step by Step Solution

3.35 Rating (167 Votes )

There are 3 Steps involved in it

Step: 1

For the Given Scenario Entiries Employee Menu Order ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managing Supply Chain and Operations An Integrative Approach

Authors: Thomas Foster, Scott E. Sampson, Cynthia Wallin, Scott W Webb

1st edition

132832402, 978-0132832403

More Books

Students also viewed these Accounting questions

Question

finding entry-level positions;

Answered: 1 week ago

Question

Contrast independent and dependent demand.

Answered: 1 week ago