Identify what issues in the database dimEmployee Employee_key Employee ID Employee_name Number_years_service dimCustomer 8 Customer_key Customer_ID Customer_fullname Customer phone Customer_email

Identify what issues in the database dimEmployee Employee_key Employee ID Employee_name Number_years_service dimCustomer 8 Customer_key Customer_ID Customer_fullname Customer phone Customer_email

Question:

 Identify what issues in the database 

Transcribed Image Text:

dimEmployee
Employee_key
Employee ID
Employee_name
Number_years_service
dimCustomer
8 Customer_key
Customer_ID
Customer_fullname
Customer phone
Customer_email
dimLocation
Location_Key
Location ID
City
State
Zip
Location manager
District
District manager
factReservations
Reservation_key
Order_key
Employee_key
Location_key
Customer_key
Day_key
Frequent customer
Valet parking
Visit_duration
Number_of_guests
Quantity_ordered
Discount percent
Taxes
Tip
Total_bill
Special requests
Location_type
dimReservation
Reservation_key
Reservation_number
Table_occupancy
Table_number
8
dimOrder
Order_key
8
Order_description
Menultem_name
Menuitem_number
dimDate
8 Date_key
Full_Date
Full Time
Weekday_flag
Weekend flag
Holiday_flag
Day_number
Month_number
Year_number

Expert Answer:

Answer rating: 100% (QA)

There are some missing Entities or Relationships e g billing and the special requests The
View the full answer