ACCT/MIS 437 Project 1 Quandrax Computers
The Quandrax Computers (QC) in Edmonton buys and sells computer components. Each type of components has a unique item #. An individual purchase can consist of multiple component types; each component type is listed as a line item on the receiving report of this purchase. Data about computer components are added to the database when a supplying vendor for the new item can be found to provide a quoted price to QC. Vendors can supply many components and a component is supplied by one vendor. QC has several warehouses in Edmonton.
Upon employment each buyer employee is immediately assigned to a group of vendors. A purchase, or a cash transaction involves just one QC employee. Cashiers handle cash disbursements. Newly opened bank accounts with zero balance are added to the database. Potential vendors are added to the QC’s database and assigned to only one buyer employee even before any transactions with them take place.
Every purchase is paid in full five days before its payment due date with a check drawn on one of its bank accounts. The store does have other expenses that are paid for through these bank accounts.
Required: Create a REA business level model for this store with entities, relationships, and cardinalities specified. 1. Use attribute names provided in ( ) for the following attributes to fill the ERD; do not add or delete any attributes. 2. Use the Skeleton.pdf (found in the same Project 1 folder) as a starting point; Don’t add more entities. 3. No relationship lines should cross each other. 4. Use standard names for events, resources and agents.
-inventory item # (ii#) -item weight (i_w) -item color (i_c)
-receiving report #(rr#) -quantity of an item purchased on this report (q_p)
-purchase $ amount (p_amt) -check #(chk#) -check amount (chk_amt)
-cash account # (c_acct#) -cash account balance (c_acct_bal)
-buyer employee # (b_emp#) -buyer telephone # (b_tel)
-vendor # (v_#) -vendor name (v_name) -vendor’s current price quote for an item (v_quote)
-vendor’s own product number for an inventory item (v_prod#)
-cashier employee #(c_emp#)
-warehouse # (wh_#) -warehouse location (wh_loc)
-quantity of a particular item at this warehouse (q_item_wh)
Submit your project (Filename convention: LastnameFirstName.pdf) on the Due Date. Make a backup copy of your work. For each late day, the project will be deducted 20%.