Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Reeourcee Rental Inventory = Rental Inventory # (PK). Rental Inventory # , rental Inventory description, rental Inventory hourly charge. Inventory category # (FK) Delivery Trucke
Reeourcee Rental Inventory = Rental Inventory # (PK). Rental Inventory # , rental Inventory description, rental Inventory hourly charge. Inventory category # (FK) Delivery Trucke = Dellvery truck # (PK(), delivery truck description, delivery truck charge, delivery truck acquired date Cash = Cash account # (PK), cash account balance Evente Contracts = Contract# (PIC), contract date, contract end date, contract minimum dollar amount, contract standard premium, Customer # (FK). employee # (FK) Rental Reservatione = Rental reservation # (PK). Rental reservation date . customer's credit card for thle rental reservation, Contract # (FKC), customer # (FK). Rental reservation date (FI Rental Tickets = Rental Inventory # (PK), rental ticket date, rental start time, rental end time, dellvery Y/N, rental reservation # (FK). Customer # (FK(), employee # (FK). Rental reservation # (FK(), dellvery truck # (FK) Cash Receipts = Cash receipt # (PK(). cash receipt date, cash receipt amount, Cash account # (FK), customer # (FK(). employee # (FKC) Agents Customers = Customer # (PK), customer name. Customer type (FK(). YTD rentals by this customer Employees = Employee # (PK), employee name, Type Images Inventory Categorlee = Inventory category # (PK), Inventory category description, Rental Inventory hourly charge Customer Typee = Customer type (PK), number of customers of this type Linking Tables Rental Reservation-Inventory | Rental reservation # Category = + Inventory category # (PK) Rental Tickets-Cash Receipts - rental ticket # + cash receipt # (PK)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started