The administrators of Tiny College want to expand their database to include tables for their motor vehicle pool. A brief description of operations follows:
A brief description of operations follows:
• Faculty members may use the vehicles owned by Tiny College for officially sanctioned 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 Tiny College’s Travel Far But Slowly (TFBS) Center.
• 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 arriving to pick 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 member’s identification code, the vehicle’s identification, the odometer readings at the start and end of the trip, maintenance complaints (if any), 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 faculty trip completion form, the faculty member’s department is billed at a mileage rate based on the vehicle type (sedan, station wagon, panel truck, minivan, or minibus) used. (Hint: Do not use more entities than are necessary. Remember the difference between attributes and entities!)
• All vehicle maintenance is performed by TFBS. Each time a vehicle requires maintenance, a maintenance log entry is completed on a prenumbered maintenance log form. The maintenance log form includes the vehicle identification, a brief description of the type of maintenance required, the initial log entry date, the date on which the maintenance was completed, and the identification of the mechanic who released the vehicle back into service. (Only mechanics who have an inspection authorization may release the vehicle back into service.)
• As soon as the log form has been initiated, the log form’s number is transferred to a maintenance detail form; the log form’s number is also forwarded to the parts department manager, who fills out a parts usage form on which the maintenance log number is recorded. The maintenance detail form contains separate lines for each maintenance item performed, for the parts used, and for identification of the mechanic who performed the maintenance item. When all maintenance items have been completed, the maintenance detail form is stapled to the maintenance log form, the maintenance log form’s completion date is filled out, and the mechanic who releases the vehicle back into service signs the form. The stapled forms are then filed, to be used later as the source for various maintenance reports.
• TFBS maintains a parts inventory, including oil, oil filters, air filters, and belts of various types. The parts inventory is checked daily to monitor parts usage and to reorder parts that reach the “minimum quantity on hand” level. To track parts usage, the parts manager requires each mechanic to sign out the parts that are used to perform each vehicle’s maintenance; the parts manager records the maintenance log number under which the part is used.
• Each month TFBS issues a set of reports. The reports include the mileage driven by vehicle, by department, and by faculty members within a department. In addition, various revenue reports are generated by vehicle and department. A detailed parts usage report is also filed each month. Finally, a vehicle maintenance summary is created each month.
Given that brief summary of operations, draw the appropriate (and fully labeled) ERD. Use the Crows methodology to indicate entities, relationships, connectivities, and cardinalities.
我给你们翻译了，
Tiny College 的管理员希望扩展他们的数据库以包括他们的机动车辆池表。操作的简要说明如下：
操作的简要说明如下：
• 教职员工可以使用 Tiny College 拥有的车辆进行官方批准的旅行。例如，教师可以使用这些车辆前往校外学习中心、前往提交研究论文的地点、将学生运送到官方批准的地点以及为公共服务目的而旅行。用于此类目的的车辆由 Tiny College 的 Travel Far But Slow (TFBS) 中心管理。
• 使用预订表，每个部门都可以为其教职员工预订车辆，教职员工负责在行程结束时填写相应的行程完成表。预订表包括预计出发日期、所需车辆类型、目的地和授权教职员工的姓名。到达取车的教员必须签署结账表以注销车辆并领取旅行完成表。 （放行车辆使用的 TFBS 员工也签署了结账表。）教员的行程完成表包括教员的识别码、车辆识别、行程开始和结束时的里程表读数、维修投诉（如果任何）、购买的加仑燃料（如果有），以及用于支付燃料费用的 Tiny College 信用卡号。如果购买燃油，信用卡收据必须装订在行程完成表上。收到教员旅行完成表后，教员所在部门将根据所使用的车辆类型（轿车、旅行车、平板卡车、小型货车或小巴）按里程收费。 （提示：不要使用过多的实体。记住属性和实体之间的区别！）
• 所有车辆维修均由TFBS 执行。每次车辆需要维护时，都会在预先编号的维护日志表格上填写维护日志条目。维护日志表包括车辆标识、所需维护类型的简要说明、初始日志输入日期、维护完成日期以及将车辆重新投入使用的机械师的标识。 （只有获得检查授权的机械师才能将车辆重新投入使用。）
• 一旦启动日志表单，日志表单的编号就会转移到维护详细信息表单；日志表格的编号也会转发给零件部门经理，他填写零件使用表格，在表格上记录维护日志编号。维护明细表包含单独的行，用于显示执行的每个维护项目、使用的部件以及执行维护项目的机械师的标识。完成所有保养项目后，将保养明细表装订在保养日志表上，填写保养日志表的完成日期，由将车辆恢复使用的技工在表上签字。然后将装订好的表格归档，稍后用作各种维护报告的来源。
• TFBS 维护零件库存，包括各种类型的机油、机油滤清器、空气滤清器和皮带。每天检查零件库存以监控零件使用情况并重新订购达到“现有最低数量”水平的零件。为了跟踪零件使用情况，零件经理要求每个机械师签出用于执行每辆车维护的零件；零件经理记录使用零件的维护日志编号。
• 每个月，TFBS 都会发布一组报告。报告包括车辆、部门和部门内教职员工的行驶里程。此外，车辆和部门会生成各种收入报告。每个月还会提交一份详细的零件使用报告。最后，每个月都会创建一份车辆维护摘要。
鉴于操作的简短摘要，绘制适当的（并完全标记）ERD。使用 Crows 方法来指示实体、关系、连接性和基数。
Tiny College de guǎnlǐ yuán xīwàng kuòzhǎn tāmen de s