Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SomeLLC is a company that recycles Electronics . The company wants to design a self-service machine for recycling. The machines will be in Grocery stores.

SomeLLC is a company that recycles Electronics . The company wants to design a self-service machine for recycling. The machines will be in Grocery stores. The main idea is that customers will deposit their Electronics in the machine and get a receipt. Then, customers will use the receipt to buy food. Assume that the machine can process three types of electronics. Your company is working on the development of the system. These are some of the requirements:

The system must record the number of input items .

The system must print a receipt that: Describes what has been deposited, Describes the value of each item, and Indicates the Total

There is an operator that eventually would like to know: Number of items that have been returned in a given day. The operator must also be able to change: information associated with items (i.e. price)

The system should provide an alarm if: Item is stuck. there is no more paper. or other problems

With your knowledge of the case and listing any assumptions:1. Develop an ERD for the systems database. Include Tables names, attributes (PK & FK), and cardinalities (3NF).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

More Books

Students also viewed these Databases questions