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 fastfood restaurant TassieBite. The background story is as below:
TassieBite is a beloved local fastfood 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
