Phone number number to contact the customer driver

This preview shows page 7 - 9 out of 10 pages.

Phone Number : number to contact the customer. Driver License Number : To find customer is eligible to drive in the area. 2. Admin system data : This table contains information of the Admin. Following are the attributes and the columns of the table: AdminID : It is the unique key of the patient by which it is recognized in the system. It is the primary key of the table. Admin’s : Username : Name to login in the system. Admin’s: Password : Password to login in and access the system. FirstName : First name of the admin. LastName : Last name of the admin. Email : The information is sent to admin via email. 3. Car Data : This table stores information of the Cars and their rate. The attributes of this table are: Car ID : Unique key to identify car in the system. It is the primary key of the table. Car Name : Name of the car. Car Type : Model of the car. Daily Rate : Rate of the car on daily basis. Weekly Rate : Rate of the car on weekly basis. Hourly Rate : Rate of the car on hourly basis. Kilometer Rate: Rate of car per kilometer it drives. Weekly Insurance : Cost of insurance for the car per week. Daily Insurance : Cost of the insurance for the car each day. Hourly Insurance: Cost of the insurance for the car per hour. 7 | P a g e
Image of page 7

Subscribe to view the full document.

4. Reservation Data : It is the table which contains information about the record of the customer’s reservation. Only admin have access to the customer’s reservation. The attributes of the table are: Reservation ID : Unique key to identify car on reservation in the system. It is the primary key of the table. From Date : Date from which the car has been rented. To Date : Last Date of car for being hold to the reservation. Location ID : Key to find location of the available car to rent. Pickup Time: Time to pick the car. Return Time : Time to return the car. Car ID : Unique key to identify car in the system. Customer ID : Unique key to identify customer (holder of the car) in the system. Confirmation Number : Unique number sent by admin to get access to rent the car. 5. Location Data : Table to identify the available car in the particular location. The attributes of the table are: Location ID : Unique key to identify location of the available cars in the stores. It is the Primary key of the table. City Name : Name of the city in which the car is available to rent. Country Name: Name of the country in which the car is available to rent.
Image of page 8
Image of page 9
  • Fall '19
  • Requirements analysis, Database management system, Software Requirements Specification, Customer System, Admin System

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes