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.

AP clerck ID Name Address telephone Date of birth cashAcount ID Account Type Location Disb Voucher ID voucherDate a Dollar Amount g Check Number emID Description unitOfMeasure standard Cost Quantity Received ctual Unitp rice purchaselD Date DollarAmount Supplier ID Purc Agent Name Name Address E Address elephone telephone Date of birth Performance rate

Explanation / Answer

create table BrotherBikes_inventory(
   ItemId number,
   Description varchar2(100),
   UnitOfMeasure varchar2(100),
   StandardCost number,
   PRIMARY KEY (ItemId)
)

Create table Purchase(
   PurchaseId number,
   PurchaseDate date,
   DollarAmount number
)

Create table PurchasingAgent(
   AgentId number,
   Name varchar2(100),
   Address varchar2(100),
   BirthDate date,
   Telephone varchar2(10),
   PRIMARY KEY (AgentId)
)

Create table Supplier(
   SupplierID number,
   Name varchar2(100),
   Address varchar2(100),
   Telephone nvarchar2(10)
   PerformanceRate number,
   PRIMARY KEY (SupplierID)
)

Create table CashDisbursement(
   VoucherId number,
   VoucherDate date,
   DollarAmount number,
   CheckNumber varchar2(10),
   PRIMARY KEY (VoucherId)
)

create table PayableClerk(
   ClerId number,
   Name varchar2(100),
   Address varchar2(100),
   Telephone varchar2(100),
   Birthdate date,
   PRIMARY KEY (ClerId)
)

Create table CashAccount
(
   AccoutnId number,
   AccountType varchar2(100),
   Location varchar2(100),
   PRIMARY KEY (AccoutnId)
)

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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