JUST DO PART 1 AND IF YOU CAN BOTH. THANK YOU.

Rental Rep 1 - sells damage waiver - 30% of the time Rental Rep 2 - sells damage waiver -50% of the time SUVS are rented 100% of the time. - 2 are rented out for the whole week, 2 are rented out for 3 days and then 4 days to different customers. You can choose any configuration of days that satisfies this condition. Premium cars are rented out 95% of the time - At least one premium car must be rented out for more than the week. At least one must be rented out for four days and at least 2 must be rented out for a 2-day period. (These can be rented out gain - your choice) Compact and midsize cars are rented out 80% of the time. Vary the number of days the cars are rented out. There is no requirement as to how you may choose to do this. Everyone will have a different answer for this. Tip for simulating data: You should create your own phantom data in excel and import it into Access. Hint: You can use a random number generator in Excel to simulate data. However, this not a requirement. You can create the data however you wish. What You Will Submit You will hand in ONE Word Document or PDF (Part 1 and Part 2 will be on that same document), screenshots of: HW 4 Part 1 1) A complete data dictionary (created in Excel) See chapter 11 or 12 slides for an example 50 points 2) A relational schema from Access (with cardinalities) 30 points 3) A screenshot of each table in your Access database 20 points HW 4 Part 2 (or you can call it HW5) 4) A data form for entering the rental contracts created in Access 40 points 5) An example rental contract generated from Access 30 points 6) The manager's weekly revenue report from Access 30 points Rental Rep 1 - sells damage waiver - 30% of the time Rental Rep 2 - sells damage waiver -50% of the time SUVS are rented 100% of the time. - 2 are rented out for the whole week, 2 are rented out for 3 days and then 4 days to different customers. You can choose any configuration of days that satisfies this condition. Premium cars are rented out 95% of the time - At least one premium car must be rented out for more than the week. At least one must be rented out for four days and at least 2 must be rented out for a 2-day period. (These can be rented out gain - your choice) Compact and midsize cars are rented out 80% of the time. Vary the number of days the cars are rented out. There is no requirement as to how you may choose to do this. Everyone will have a different answer for this. Tip for simulating data: You should create your own phantom data in excel and import it into Access. Hint: You can use a random number generator in Excel to simulate data. However, this not a requirement. You can create the data however you wish. What You Will Submit You will hand in ONE Word Document or PDF (Part 1 and Part 2 will be on that same document), screenshots of: HW 4 Part 1 1) A complete data dictionary (created in Excel) See chapter 11 or 12 slides for an example 50 points 2) A relational schema from Access (with cardinalities) 30 points 3) A screenshot of each table in your Access database 20 points HW 4 Part 2 (or you can call it HW5) 4) A data form for entering the rental contracts created in Access 40 points 5) An example rental contract generated from Access 30 points 6) The manager's weekly revenue report from Access 30 points