Course start date
Course end date
a. Describe the characteristic of second normal form in a normalization process
A relation is said to be in Second Normal Form (2NF) if and only if it is already in first normal …show more content…
I would like to conduct an interview regarding Easy Drive car rental system to model the data objects.
Admin Staff: Good Afternoon, it’s my pleasure to help you.
WIC Representative: How would you like to describe Easy Drive daily routine?
Admin Staff: Basically our daily routine is to record customer booking information and assign the booking to the car that we have. It is crucial for us to have timely and accurate information about our customer booking and number of cars that are available. We would like to record customer personal information, customer booking information, car information, and information of our staff.
WIC Representative: What information you would like to capture regarding your customer personal information?
Admin Staff: We would like to capture our customer name, address, and their phone number.
WIC Representative: What about car and staff information?
Admin Staff: We would like to capture our car type, colour, seating, capacity, availability and rent price. For staff, we would like to capture our staff name, address, phone number, salary, working hours, and rate per hour.
WIC Representative: Is there any specific information you would like to capture regarding customer booking besides booking start date and end date?
Admin Staff: No, we only need to know the booking start and end date.
WIC Representative: That is all for my interview. Thank you for your time.
Admin Staff: It’s my pleasure to help you.