Techarati, Inc., a medium-sized computer retail sales company, and use the follo

Question

Techarati, Inc., a medium-sized computer retail sales company, and use the following summary of the Revenue cycle to complete the requirements below. All customer orders are handled by a sales representative. Once inventory availability is verified, the order is filled and shipped to the customer by a warehouse clerk. If the entire order cannot be filled, the items which are available are shipped to the customer and the remaining items are shipped when they become available. Customers mail in their payment based on an individual invoice received for each shipment which is due 30 days from the date the customer receives the order. Techarati does not utilize monthly statements. All cash receipts are processed by a cash receipts clerk and are deposited on a daily basis in the checking account.

QUESTION02: 2. Convert the conceptual model into a logical level relational database model by deriving a set of relational tables using the following format: the following is the format of the tables

TABLE NAME

Primary key (PK) Attribute 1 Attribute2 Attribute (n) Foreign key (FK)

Explanation / Answer

Customer

(cid, name, address, phno)

SalesRepresentitive

(srepid , name , address, phno, cid)

Order

(oid, ,details, cost, srepid, cid)

Supplier

(supplierid, name, address, phno)

Inventory

(invid , name, category, supplierid)

Payment

(pid, type)

Clerk

(clerkid, type)

Bill

(bid, amount, pid,clerkid)

ShippingDetails

(sid, quantity, oid, invid, cid, bid )

NOTE:

Primary keys are underlined attributes.

Foreign keys are the italic attibutes.

Non underlined and non italic attributes are the normal table specific attribute.

Hope your question has been resloved. Please do not forget to give a positive like to the answer. Thank you.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

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