Question

I need help creating an ERD using this information. PURCHASING DATA (Option #1): 1. Purchase Requisition a. Requesting Department Number b. Requesting Manager Employee Number c. Requisition Type (stock / non-stock) d. Date e. Remarks (free-format text) f. Suggested Vendor Name g. Suggested Vendor Contact Name h. Suggested Vendor Contact Phone i. Suggested Vendor E-mail j. Suggested Vendor Address k. Body of the Purchase Requisition (multiple lines): i. Item code (internal) ii. Item code (suggested vendor) iii. Quantity requested iv. Measuring unit

I do not need it in a specific code language but rather find the entities and attributes to create an entity relationship diagram.

Answer 1

ER Diagram for Purchase Request

As per the given information, ER Diagram for Purchase Request has the following entities and attributes:

1. PurchaseRequest
POrderID
Pdatetime
PRequestType
Remarks
SuggestedVendor

2. RequestManager/ Employee (Name can be as per your choice)
EmployeeNumber
EmployeeName
DeptNumber

3. OrderLines
LineID
POrderID
Itemcode
Quantity

4.Items
Itemcode
ItemName
Description
MeasuringUnit
UnitPrice

5. Vendor
VID
VName
VContactname
Phone
Email
Address

Sample Image of Purchase Request ER Diagram

As per the Diagram, Request Manager has the PurchaseRequest with the given details including datetime and suggested vendor, and 1 PurchaseRequest lists the various line items with requested quantity. Orderlines has items which has  various items with item details in Items entity. These items has multiple vendors and a vendor can supply multiple items.