USE L SYSTEM

Office Agent_id 1 Customer agent table Agent_name Sally Weaver Frank Costlos Xiao Li Greg Lee AWN Brisbane Brisbane Toowoomba Gold Coast 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 Discount Loyalty_id 001 Loyalty level table Loyalty_name Platinum Gold 15% 002 10% 003 Silver 8% 004 Bronze 5% 005 None 0%