BMGT402 Fall 2022 Homework \#1 Due by 11:59pm, Wednesday, February 22th,2023 Assume you are the Data Architect for a financial technology startup XYZcom offering its' users the services of buying products online on select websites now and paying the amount over a 6-month period interest free and without collateral. Consider a simplified relational schema for the company (consisting of 4 relations): - User (Userid, FName, bastName) - User table with user ID, first name and last name as attributes - Product (URL, Dame,price) - Table listing the product - Usage (Userld, URL, ParchaseDate) The following conditions are satisfied: - Every User and Website has exactly one unique id. - A user can visit multiple websites and purchase multiple products. - A product can be listed on multiple websites - A website can have multiple products listed on it - A user cannot buy the same product from the same website on the same day. Sneak peak of the data: - There are two different users named "John Smith" in the database. - An example of URL is "www.amazon.com/inhene" 5 times in the past one month using XYZ's service Assignments: 1. (18pts) What are the super keys for each of the relations: User, Product and Usage? 2. (10pts) What are the candidate keys for each of the relations: User, Product and Usage? 3. (8pts) What is the primary key for each of the relations: User, Product and Usage? 4. (4pts) What are the foreign keys for the relations: User, Product and Usage? 5. Can you list some real-world companies which provide such service