Group Project.doc

Introduction to Managment Information Systems2014-2015 Semester 1Group ProjectCase Study: Creating a Database Management SystemEach group will consist of 5-6 students. As a group, you are required to complete the project . EasyAuto Car RentalsEasyAuto Car Rentals was established in September 2007 and located in Fuzhou. As a car rental service provider, EasyAuto is dedicated to providing customers with superior car rental services including short-term rental, long-term rental, as well as assorted value-added services as roadside assistance, one-way rentals, etc.You have been employed for the last two summers by EasyAuto Car Rentals. Recently there has been an increase in business and the owners need a more accurate way to manage the rental business. You have decided to create a database to help the owners keep track of the car rentals, who the customers are, amount paid, and any damage to the cars when they are returned. Currently EasyAuto Car Rentals owns 15 cars in its fleet of rentals. The cars vary in brand, type and size. When customers rent cars, they are required to leave their drivers license number and to give you a home address, phone number, and credit card number.EasyAuto Car Rentals has the following fee structures for its 15 car rentals:TitleSeatTypeCostPerDayToyota Camry Hybrid H5Auto$32.00Toyota Camry Hybrid H5Auto$32.00Toyota YARIS5Auto$32.00Holden Astra AH5Auto$35.00Holden Astra AH5Auto$35.00Holden Ute VE5Auto$36.00Ford Territory SZ5Auto$40.00Ford Territory SZ5Auto$40.00Ford Territory SZ5Auto$40.00Mazda 3 Maxx Sport5Manual$42.00Mazda 3 Maxx Sport5Manual$42.00Mazda 3 Maxx Sport5Manual$42.00Nissan Navara D407Auto$45.00Nissan Navara D227Auto$45.00Nissan Navara D227Auto$45.00You have designed the entity classes and primary keys for the database as the following. EntityPrimary KeyCarCar_IDCustomerDrivers_LicenceRentalRental_IDHowever one of your tables in the database will need a composite primary key. Think about which above tables primary key needs to be modified. You have also identified the following business rules:1. Rentals can have many customers assigned but must have at least one.2. A car must be assigned to one and only one rental type.3. A customer can rent one or more cars at one time.4. A car can be assigned to one customer but need not be assigned to any customer. Your job is to be completed in the following phrases:1. Develop and describe the entity-relationship diagram.2. Use normalization to assure the correctness of the tables (relations).3. Create the database using Microsoft Access. The database should include:l l3 tables (entity classes). One of your tables will need a composite primary key.l l2 queries, one for inquiring damaged cars, and the other one for generating the report. l lAt least one form to display the rental status.l l1 report like figure 1 blow. You may not be able to develop a report looks exactly like Figure 1. However your report should include the same information. Figure 1Deliverables all of the following files must be submitted. 1. Entity-relationship Diagram (ERD) in world format.2. Access database file3. Peer Evaluation forms. You need to zip all the required files into one file, and name the file like: Project_Group1Submission deadlin