Question: Using Crow's foot notation please help me solve the problem above, this is my second submission request for assistance **Edit** I'm not sure what is


Using Crow's foot notation please help me solve the problem above, this is my second submission request for assistance
**Edit** I'm not sure what is meant by providing the line statement, this is exactly how the problem is presented from my book
11. The administrators of Tiny College are so pleased with your design and implemen tation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows Faculty members may use the vehicles owned by Tiny College for officially sanc tioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by y College's Travel Fa Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required, destination, and name of the authorized faculty member. The faculty member who picks up a vehicle must sign a checkout form to log out the vehicle and pick up a trip completion form. (The TFBS employee who releases the vehicle for use also signs the checkout form.) The faculty member's trip completion form includes the faculty members identification code, the vehicles identification, the odometer readings at the start and end of the trip, maintenance complaints (ifany gallons of fuel purchased (if any), and the Tiny College credit card number used to pay for the fuel. If fuel is purchased, the credit card receipt must be stapled to the trip completion form. Upon receipt of the trip completion form, the faculty mem ber's department is billed at a mileage rate based on the vehicle type used: sedan, station wagon, panel truck, minivan, or minibus. (Hint: Do not use more entities than are necessary. Remember the difference between attributes and entities!)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
