2.5 Quest, Inc. The following tables and attributes exist in a relational database of Quest, Inc. First, draw a complete REA diagram for this database. You must include cardinalities. Determine the proper cardinalities based on the given design of each table and the additional information. Next, indicate if any errors exist in the given database design.

Additional information: Quest is a retail company and it often carries new items of inventories. Quest would like to include potential vendors in its vendor table. Most vendors allow credit purchases. Use the same employee table for internal agents.

Transcribed Image Text:

Table Vendor Purchases Employee Purchase-Inventory Purchase-Cash Disbursement Inventory Cash Cash Disbursement Attributes Vendor#, Name, Address, City, State, Contact person, Phone, Fax P.O.#, Order date, Amount, Vendor#, Employee# Employee#, Name, Address, Home phone number, Date hired P.O.#, Item#, Unit cost, Quantity purchased, Extension P.O.#, Disbursement voucher# Item#, Description, Quantity on hand Bank account#, Bank name, Bank address, Balance Disbursement voucher#, Check#, Date, Amount