Database Management and Design Assignment \#1 Problem One Consider the three reports in the figure above. The dsta sre samples of data thst would appear in the reports like these. of Make a list of as mamy potential entities as the reperts suseest. Coocolidute any paticks that are cynorivens fiment the same thind b) Write cut your assumptions based on the dats and reports presented. c) Canstract an ERD using Cow's Foot technique showing the relationships and cardinalities amore your entities. He sure to indicate all primary and foreien keys. Problem Two The Muhawk College Afte-Schwol program is seekirg to improve their student inflormation. They've captured infomation to date in the following table but have found that the data becomes corrupted due to different team memlaers accessing it at the same time. They have asked how they might better cepture this information. a) Restate the tables in First, Second, and Third Normal Form b] Create an Entily Relationshig Ciagram from your Third Nermal form. Please use Crews feod, Problem Three Your database for the After School program has captured the eye of the Mohawik College Video Game club. They hare asked you to design a database application for their on-campus Game rental kicsk. They want to track cuetomers, rentals, and items. They also want to start a Loyalty program, whereby they will offer s 20 percent docount on every 10th ustomet rental. Problem One Carbider the three reperts in the ligure abeve. The dale are samples of data that wuuld appeor in the reports like these. o) Make a list of as many potential entities as the reports sugnest. Conswivede wny entities thet ore synonyms imeon the some thingl. b) Write out your assumptions based on the data and reports presented. c) Construct an ERD using Crow's foot techrique showirg the relationships and cardinalities. among your entities. Be sure to indicate all primary and foreign keys. Problern Twa The Nohawk Coliege After-Sthool program is seeking to improwe their student informstion. They've captured information to date in the following table but have found that the data becomes corrupted due to different team members accessing it at the same time. They have asked how they might better capture this information. a) Restate the tables in First, Second, and Third Nomal Form b) Creste an Entity Relationship Disgram from your Third Normal form. Piease use Crows Foot. Problem Three Your database for the After School program has captured the eye of the Mohawk Colleee Video 5 ame cub. They have asked you to design a database application for their on-campus Game rental kiask. They want to track customers, rentais, and items. They also want to start a Loyalty program, whereby they will affer a 20 peroent discount on every 1010 custamer rental. Database Management and Design Assignment \#1 Problem One Consider the three reports in the figure above. The dsta sre samples of data thst would appear in the reports like these. of Make a list of as mamy potential entities as the reperts suseest. Coocolidute any paticks that are cynorivens fiment the same thind b) Write cut your assumptions based on the dats and reports presented. c) Canstract an ERD using Cow's Foot technique showing the relationships and cardinalities amore your entities. He sure to indicate all primary and foreien keys. Problem Two The Muhawk College Afte-Schwol program is seekirg to improve their student inflormation. They've captured infomation to date in the following table but have found that the data becomes corrupted due to different team memlaers accessing it at the same time. They have asked how they might better cepture this information. a) Restate the tables in First, Second, and Third Normal Form b] Create an Entily Relationshig Ciagram from your Third Nermal form. Please use Crews feod, Problem Three Your database for the After School program has captured the eye of the Mohawik College Video Game club. They hare asked you to design a database application for their on-campus Game rental kicsk. They want to track cuetomers, rentals, and items. They also want to start a Loyalty program, whereby they will offer s 20 percent docount on every 10th ustomet rental. Problem One Carbider the three reperts in the ligure abeve. The dale are samples of data that wuuld appeor in the reports like these. o) Make a list of as many potential entities as the reports sugnest. Conswivede wny entities thet ore synonyms imeon the some thingl. b) Write out your assumptions based on the data and reports presented. c) Construct an ERD using Crow's foot techrique showirg the relationships and cardinalities. among your entities. Be sure to indicate all primary and foreign keys. Problern Twa The Nohawk Coliege After-Sthool program is seeking to improwe their student informstion. They've captured information to date in the following table but have found that the data becomes corrupted due to different team members accessing it at the same time. They have asked how they might better capture this information. a) Restate the tables in First, Second, and Third Nomal Form b) Creste an Entity Relationship Disgram from your Third Normal form. Piease use Crows Foot. Problem Three Your database for the After School program has captured the eye of the Mohawk Colleee Video 5 ame cub. They have asked you to design a database application for their on-campus Game rental kiask. They want to track customers, rentais, and items. They also want to start a Loyalty program, whereby they will affer a 20 peroent discount on every 1010 custamer rental