The database table structure in the image shows an 'Employee table'r 'Personal trainer table' and a 'Bike table'. Consider the following business rules: 0 As part of a tness campaign, an organisation is assigning each of its employees a personal trainer and a bike. 0 An employee can only have one personal trainer, but a trainer can have many employees (i.e., clients that they train). 0 An employee can only have one bike. Atype of bike can be assigned to many employees (i.e., many staff may choose to have a Mountain bike). amnion-Lid nan- Personal trainer table Traineud 002 003 004 _El IIM_ 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? The table below captures data for a small book exchange and book club that you manager You record the books that members have read as well as the book club that each member belongs to You want to update your records by using a relational database based on the below business rules. 0 A member can borrow more than one book, a book may be borrowed by more than one member. 0 A member can only belong to one book club, a book club can have many members. MemberJD Flrst_mme Address Book_tltie Club_l]) Club_name 001 Michio 500 Belter Av Leviathan Wakes Sl SeiF i 002 Roberto 4 Madrid St The Terror A1 Adventure 002 Roberto 4 Madrid St Project Hail Mary A1 Adventure 002 Roberto 4 Madrid St Pride and Prejudice A1 Adventure 003 James 12 Roch: St Origin T1 Thriller 003 James 12 Rosin St Leviathan Wakes T1 Thriller 004 Avars 88 Earth St The North Waters H1 History 004 Avars 88 Earth St Rendezvous with Rama H1 History 004 Avars 88 Earth St Enemy of All Mankind H1 History 004 Avars Jones 88 Earth St 4567 The Terror H1 History Your task: Based on the table above create a relational database structure in third normal form (the most appropriate database structure). Identify the Entities and their relevant Attributes, Primary Keys and Foreign Keys. Write your answer in a format similar to the example below: Table name: attribute name (primary key). attribute name (foreign key/primary key), attribute, attribute name, etc\