Question: The database table structure in the image shows a 'Customer table', 'Loyalty level table' and a 'Customer agent table'. Consider the following business rules: A

The database table structure in the image shows a 'Customer table', 'Loyalty level table' and a 'Customer agent table'. Consider the following business rules: A customer can only have one loyalty level, but a loyalty level can have many customers. Each loyalty level must have one agent who will manage customers that have that level (an agent can look after many loyalty levels). Your task: What are the most appropriate Foreign Key(s) and where should we place the Foreign Key(s) in this table structure so that we can link the tables? (100 words maximum) *The image is labelled "Question 1 image" in the Exam PDF (for students that can't see images) Customer table Customer_id 245 Business_name Pure N Clean Mao Cleaning Kwiatkowski Cleaning Address 52 Eros St, Brisbane 21 Mars St, Brisbane 1 Belt St, Brisbane 265 987 Loyalty level table Loyalty_name Discount Loyalty_id 001 Platinum 15% 002 Gold 10% Silver 8% 003 004 Bronze 5% 005 None 0% Office Agent_id 1 Customer agent table Agent_name Sally Weaver Frank Costlos Brisbane 2 2 Brisbane 3 Xiao Li Toowoomba 4 Greg Lee Gold Coast
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
