Question: Your client is a local fast - food restaurant - TassieBite. The background story is as below: TassieBite is a beloved local fast - food

Your client is a local fast-food restaurant - TassieBite. The background story is as below:
TassieBite is a beloved local fast-food restaurant nestled in the heart of Tasmania. Recently, TassieBite has set its sights on expanding its presence beyond its flagship location and establishing a chain of restaurants across Tasmania. To support this ambitious growth strategy, TassieBite recognizes the need for a robust database system for internal management. This system will play a crucial role in streamlining operations, managing resources efficiently, and maintaining the high standards of quality and service.
The basic information needed is:
Stores: including ID, name, location, contact information (contacted staff information).
Employees: including ID, SSN, name, gender, DoB, position, salary, AffiliateStore.
Vendors: including ID, name, address, contactInfo
Products: including ID, name, Vendor, price, quantity
Each store has many employees, and each employee works for one store. Additionally, each store can sell many different products, and products can be available in many stores. Furthermore, each vendor provides on specific products.
Based on your understanding so far, what are the entities, attributes, identifiers, and relationships in the Entity Relationship Model? Please create an ER diagram using Lucidchart and present it to your tutor for review.

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