Question: The following tables and attributes exist in a relational database of Quest Inc. Draw a complete ER diagram for this database. You must include cardinalities.

The following tables and attributes exist in a relational database of Quest Inc. Draw a complete ER diagram for this database. You must include cardinalities. Determine the proper cardinalities based on the given design of each table and the additional information E. Table Attributes Vendor Purchases Employee Purchasee Invento Purchase-Cash Disbursement Inventor Cash Cash Disbursement Vendor#, Name, Address, City, State, contact person, Phone, Fax ?.OH, Order date, Amount, Vendor#, Employee# Employee#, Name, Address, Home phone number, Date hired ?.OH, Item, Unit cost, Quantity purchased, Extension ?.OH, Disbursement voucher# Item#, Description, Quantity on hand Bank account#, Bank name, Bank address, Balance Disbursement voucher, Check#, Date, Amount 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 The following tables and attributes exist in a relational database of Quest Inc. Draw a complete ER diagram for this database. You must include cardinalities. Determine the proper cardinalities based on the given design of each table and the additional information E. Table Attributes Vendor Purchases Employee Purchasee Invento Purchase-Cash Disbursement Inventor Cash Cash Disbursement Vendor#, Name, Address, City, State, contact person, Phone, Fax ?.OH, Order date, Amount, Vendor#, Employee# Employee#, Name, Address, Home phone number, Date hired ?.OH, Item, Unit cost, Quantity purchased, Extension ?.OH, Disbursement voucher# Item#, Description, Quantity on hand Bank account#, Bank name, Bank address, Balance Disbursement voucher, Check#, Date, Amount 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
