Q2 Functional Dependencies For the attributes in your design, list all the functional dependencies (as we do in slide 217 and 220) that include LNum (location number) on either the left or right-hand side of the dependency. Again, your answer should be consistent with a design that is in Boyce-Codd normal form. Create and upload a PDF or image file of your answer to Crowdmark. When naming attributes use names that come directly from the Requirements for New Database description. If you have to create any new ones, use meaningful names. [5 points] Requirements for New Database AAS wants to create a database to track the following data. For each Customers they want to track CNum (a customer number which is unique for each customer), CName, CPhone, CEmail. They have grown to over 14 locations in Southwester Ontario and the data they want to track for each location is LNum (a location number which is unique for each location), LMgr (the location manger's name) LAddress, LPhone and LEmail. Brands have a BName (brand name) and a BNum (brand number). Each brand comes in many shoe styles: SName and SNum. And because sizes are different for men's, women's and children's shoes, styles also come with a SType which could be either men's, women's or children's size. Also each style may have a different price but all sizes of that style have the same price. Different brands are guaranteed to have different SNums. When a customer makes a purchase, AAD wants the database to create a unique PNum (purchase number) and also track the customer who made the purchase, the date, the location, the items the customer purchased (including style and size) and the quantity of each pair of shoes purchased (the customer could buy two or more of the same brand, style and size). AAS also want to keep track of the inventory levels of each item at each location so customers can check if a particular shoe style is available in their size at a nearby store. When customer makes a purchase online, the items can only come from one location. The customer would have to make two separate purchases to get shoes from two separate locations. Other than what is listed and needed above, the database should not store any additional data. Q2 Functional Dependencies For the attributes in your design, list all the functional dependencies (as we do in slide 217 and 220) that include LNum (location number) on either the left or right-hand side of the dependency. Again, your answer should be consistent with a design that is in Boyce-Codd normal form. Create and upload a PDF or image file of your answer to Crowdmark. When naming attributes use names that come directly from the Requirements for New Database description. If you have to create any new ones, use meaningful names. [5 points] Requirements for New Database AAS wants to create a database to track the following data. For each Customers they want to track CNum (a customer number which is unique for each customer), CName, CPhone, CEmail. They have grown to over 14 locations in Southwester Ontario and the data they want to track for each location is LNum (a location number which is unique for each location), LMgr (the location manger's name) LAddress, LPhone and LEmail. Brands have a BName (brand name) and a BNum (brand number). Each brand comes in many shoe styles: SName and SNum. And because sizes are different for men's, women's and children's shoes, styles also come with a SType which could be either men's, women's or children's size. Also each style may have a different price but all sizes of that style have the same price. Different brands are guaranteed to have different SNums. When a customer makes a purchase, AAD wants the database to create a unique PNum (purchase number) and also track the customer who made the purchase, the date, the location, the items the customer purchased (including style and size) and the quantity of each pair of shoes purchased (the customer could buy two or more of the same brand, style and size). AAS also want to keep track of the inventory levels of each item at each location so customers can check if a particular shoe style is available in their size at a nearby store. When customer makes a purchase online, the items can only come from one location. The customer would have to make two separate purchases to get shoes from two separate locations. Other than what is listed and needed above, the database should not store any additional data