Question: For our semester project for IS3280, we will be utilizing SQL RDBMS through MS Access to help solve problems relating to inventory and resource management

For our semester project for IS3280, we will be utilizing SQL RDBMS through MS Access to help solve problems relating to inventory and resource management for GameStopSign. Specifically, we will be helping the fictional video game retailer GameStopSign. Currently, GameStopSign is rapidly growing, and has seen rapid appreciation in its stock market valuation. As a result, GameStopSign is in dire need of an automated method to keep track of their ever increasing number of records related to their sales, inventory, membership roster, etc., as their current method of recording info on the back of game cases is insufficient for their growth trajectory.

Accordingly, GameStopSign has contracted (blank) to design a database system to manage their records relating to revenue, expenses, taxes, net profits, customer memberships, and their various product inventories. Additionally, GameStopSign has also demanded that customers are able to view their products and see how much inventory is currently in stock. Furthermore, {blank} would like for customers to be able to see their membership status on demand, and update their information if necessary. However, only employees of GameStopSign will be able to create and delete member accounts.

Please create an ERD model for the above scenario.

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 Databases Questions!