Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Reeourcee Rental Inventory = Rental Inventory # (PK). Rental Inventory # , rental Inventory description, rental Inventory hourly charge. Inventory category # (FK) Delivery Trucke

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: Larson Kermit, Tilly Jensen

Volume I, 14th Canadian Edition

71051503, 978-1259066511, 1259066517, 978-0071051507

Students also viewed these Accounting questions