DATA MODELING ASSIGNMENT MGMT 4013 01, Spring 2018 Your assignment is to create a data model based on the scenario and data below. For your convenience, I have included the steps in the process of creating a data model at the end of this document. Roger is the manager of a car rental company in an area of the country that has many tourist destinations and attracts many visitors who fly into the area at a nearby regional airport. He has a large fleet of vehicles with a wide variety of models of cars, vans, and SUVs to rent to those visitors. He thinks his customers typically rent a vehicle for a long weekend stay, week-long conferences, and two-week vacations. He has been keeping records for his business in Word documents and Excel spreadsheets. He has heard that he could learn more about the patterns in his business if these records were stored in a database. You are interning with his company, and he thinks your up-to-date technology skills would be very useful on this project. Roger tells you that he will be making his fleet composition decisions soon. He wonders whether he should adjust the mix of models that he has to offer customers. His comment and question causes you realize that he needs to keep track of rental transactions as well as vehicles. You understand you need to determine which models are rented most often and which models result in the most profit overall. Calculating profit means that you will need some cost figures Roger is also considering some sort of loyalty plan to increase repeat business and thereby increase the company's revenue. He would like to know which customers he should offer this deal. You realize he needs to be keeping track of his customers, too. Roger also expresses some curiosity about how productive his employees are. He is aware that some of them process more rental agreements than others and some are more persuasive at convincing customers to buy additional insurance with their rental. You realize he needs to keep track of employees You remember from your MIS course that whenever you see multiple themes, you need a database rather than a spreadsheet. Your task in this project is to create a data model. (Eventually, you will use this model to implement a database that will enable Roger to easily produce the reports to answer his ted States DATA MODELING ASSIGNMENT MGMT 4013 01, Spring 2018 Your assignment is to create a data model based on the scenario and data below. For your convenience, I have included the steps in the process of creating a data model at the end of this document. Roger is the manager of a car rental company in an area of the country that has many tourist destinations and attracts many visitors who fly into the area at a nearby regional airport. He has a large fleet of vehicles with a wide variety of models of cars, vans, and SUVs to rent to those visitors. He thinks his customers typically rent a vehicle for a long weekend stay, week-long conferences, and two-week vacations. He has been keeping records for his business in Word documents and Excel spreadsheets. He has heard that he could learn more about the patterns in his business if these records were stored in a database. You are interning with his company, and he thinks your up-to-date technology skills would be very useful on this project. Roger tells you that he will be making his fleet composition decisions soon. He wonders whether he should adjust the mix of models that he has to offer customers. His comment and question causes you realize that he needs to keep track of rental transactions as well as vehicles. You understand you need to determine which models are rented most often and which models result in the most profit overall. Calculating profit means that you will need some cost figures Roger is also considering some sort of loyalty plan to increase repeat business and thereby increase the company's revenue. He would like to know which customers he should offer this deal. You realize he needs to be keeping track of his customers, too. Roger also expresses some curiosity about how productive his employees are. He is aware that some of them process more rental agreements than others and some are more persuasive at convincing customers to buy additional insurance with their rental. You realize he needs to keep track of employees You remember from your MIS course that whenever you see multiple themes, you need a database rather than a spreadsheet. Your task in this project is to create a data model. (Eventually, you will use this model to implement a database that will enable Roger to easily produce the reports to answer his ted States
