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 to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Managerial Accounting For Dummies

Authors: Mark P Holtzman, Karen Schoenebeck

1st Edition

1118116429, 978-1118116425

More Books

Students also viewed these Accounting questions