Let’s consider an enterprise called BrotherBikes. BrotherBikes manufactures bicy

Question

Let’s consider an enterprise called BrotherBikes. BrotherBikes manufactures bicycles and resells t-shirts. BrotherBikes sells bikes and t-shirts to a network of customers (specialized, dealers throughout the world, individual customers). It procures raw materials for bikes from a variety of suppliers, acquires ready-made t-shirts from a set of sewing labs and it has a network of investors and creditors that allows it to support its finance.

The following figure shows an overall REA business process level model for the BrotherBikes’s acquisition/payment business process.

Give the relational model corresponding to the given entity-relationship diagram.

Brother Bikes inventory Cash account (0,N) stock fllow1 (1,1) Purchase duality PurcDisb Cash Disbursement (1,1) partici partic2 partic partic4 (1,N) Purchasing agent Supplier Accounts payable clerk

Explanation / Answer

Relational Model

BrotherBikesInventory(ItemID,Description,UnitOfMeasure,StandardCost)

Stockflow1(ItemID,PurschaseID,QuantiyRecieved,ActualUnitPrice)

Purchase(PurchaseID,Date,DollarAmount,ItemID)

PurchasingAgent(PurchAgentID,Name,Address,Telephone,DateOfBirth,PurchaseID)

Supplier(SupplierID,Name,Address,Telephone,PerformanceRate,PurchaseID)

CashAccount(CashAccountID,AccountType,Location)

CashDisbursement(DisbVoucherID,VoucherDate,DollarAmount,CheckNumber,PurchaseID,CashAccountID,SupplierID)

AccountsPayableClerk(APClerkID,Name,Address,Telephone,DateOfBirth,DisbVoucherID)

underlined are primary keys and italicised are foreign keys

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.