Create an Entity Relationship Diagram (preferably with the free website ERDPlus) for the following business.

Various types of entities, attributes, and relationships will be added to an Entity-Relationship Diagram.

Bibitor, LLC is a retail wine and spirits company, with 79 or 80 locations (depending on the year-end) within the fictional state of Lincoln. Depending on the year-end, sales can range from 420-450 million dollars and cost of goods sold can range from 300-350 million dollars. The total number of records in the dataset is 15 million. This includes sales transactions (12.5 to 13 million records) purchase transactions (2.3 to 2.5 million records) and inventory.

Datafield Names and Descriptions BegInvFINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number, Store The client numbers their stores from 1 - 79 City Each store is located in a city within the State of Lincoln Bibitor creates their own Brand Numbers for each liquor or wine purchased. Brand Description This is the description of the product This is the size of the product Size OnHand This is the amount On Hand at a point in time. Price This is the Sales Price of the Inventory startDate This date signifies that Inventory listed is the balance of items at the beginning of the day. EndInvFINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number. Store The client numbers their stores City Brand Each store is located in a city within the State of Lincoln Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Size onHand This is the description of the product This is the size of the product This is the amount On Hand at a point in time. This is the Sales Price of the Inventory This date signifies that Inventory listed is the balance of items at the end of the day. Price endDate Purchases FINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number. Store The client numbers their stores Brand Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Size Vendor Number This is the description of the product This is the size of the product Bibitor assigns a Vendor Number to each supplier Supplier nome Purchase Order Number provided to the Vendor Date Central Purchasing issued the Purchase Order Number to the Vendor. Vendor Name PONumber PODate Receiving Date Date of receipt of the Vendor drop shipment at the respective Store Invoice Date PayDate PurchasePrice Date the Vendor Invoice was received. Date Accounting Poid the Vendor Invoice Purchase Price of an Inventory item Quantity received on the receiving date Purchase Price multiplied by the Quantity received Products are classified as either Spirits (I) or Wine (2) Quantity Dollars Classification SalesFINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number. Store Brand The client numbers their stores Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Size Sales Quantity Sales Dollars Sales Price This is the description of the product This is the size of the product Quantity sold on the Sales Date Quantity multiplied by the Sales Price Sales price charged to consumers Date of the sale to the consumer Numeric size of the product Products are classified as either Spirits (I) or Wine (2) Sales Date Volume Classification Excise Tax Amount of excise tax collected from the consumer to be remitted to the State of Lincoln Vendor No Bibitor assigns a Vendor Number to each supplier Supplier name Vendor Name 20XXPurchase Prices Month.csv Brand Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Price This is the description of the product This represents the highest sales price during the year. It does not represent the average sales prices or the last sales price, Size Volume Classification Purchase Price This is the size of the product Numeric size of the product Products are classified as either Spirits (I) or Wine (2) Purchase Price for each product. Bibitor assigns a Vendor Number to each supplier Supplier nome Vendor Number Vendor Name Invoice Purchases MMDDYYY.csv Vendor Number Vendor Name Invoice Date Bibitor assigns a Vendor Number to each supplier Supplier name Date the Vendor Invoice was received. Date Central Purchasing issued Purchase Order Number to the Vendor. PONumber PODate Date of receipt of the Vendor drop shipment at the respective Store Pay Date Quantity Date Accounting Paid the Vendor Invoice Total Quantity Drop Shipped by the Vendor to the various retail locations Dollars Freight Approval Total Purchase Amount for the Quantity Drop Shipped Freight Charges for each purchase order. Identified name of approving individuals for purchases without freight charges FinalPayrollMonth YYYY.csv PayPeriod There are 24 consecutively numbered pay periods each year. Beg Date For each pay period, this is the first day in the pay period EndDate For each pay period, this is the last day in the pay period ID Employee IDs are assigned to each employee. The first two digits signify the type of employee. 00- Retail Store Managers 01- Full l'ime Retail Employees (Clerk II and III) 02 - Full and Part Time Retail Employees (Clerk I) 03 - Retail Store Receivers 04 - Corporate Office Employees FirstName First name of the employee LastName Last name of the employee Store The client numbers their stores Tide Employee's job title Rate PerHour For hourly employees, the amount of money earned for each hour worked Salary For salaried employees, the annual salary SalaryWagesPerPP For both hourly and salaried employees, the amount of gross pay Hours For hourly employees, the number of hours worked in a pay period Fed Tax Federal tax withholding each pay period Strax State tax withholding each pay period FICA Social security tax withholding each pay period Em Fica Employer matching of social security tax each pay period Medicare Medicare tox withholding each pay period Em Medicare Employer portion of Medicare tax each pay period Month YYYYPeriodExpense.csv Date Date the expense was incurred Vendor Name Goods or service supplier nome Account General Ledger Account in Netsuite.com Amount Dollar amount of the expense incurred Datafield Names and Descriptions BegInvFINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number, Store The client numbers their stores from 1 - 79 City Each store is located in a city within the State of Lincoln Bibitor creates their own Brand Numbers for each liquor or wine purchased. Brand Description This is the description of the product This is the size of the product Size OnHand This is the amount On Hand at a point in time. Price This is the Sales Price of the Inventory startDate This date signifies that Inventory listed is the balance of items at the beginning of the day. EndInvFINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number. Store The client numbers their stores City Brand Each store is located in a city within the State of Lincoln Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Size onHand This is the description of the product This is the size of the product This is the amount On Hand at a point in time. This is the Sales Price of the Inventory This date signifies that Inventory listed is the balance of items at the end of the day. Price endDate Purchases FINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number. Store The client numbers their stores Brand Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Size Vendor Number This is the description of the product This is the size of the product Bibitor assigns a Vendor Number to each supplier Supplier nome Purchase Order Number provided to the Vendor Date Central Purchasing issued the Purchase Order Number to the Vendor. Vendor Name PONumber PODate Receiving Date Date of receipt of the Vendor drop shipment at the respective Store Invoice Date PayDate PurchasePrice Date the Vendor Invoice was received. Date Accounting Poid the Vendor Invoice Purchase Price of an Inventory item Quantity received on the receiving date Purchase Price multiplied by the Quantity received Products are classified as either Spirits (I) or Wine (2) Quantity Dollars Classification SalesFINALMMDDYYY.csv Inventoryld The client created unique inventory IDs for these files. The variable is a concatenation of Store Number, City, and Brand Number. Store Brand The client numbers their stores Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Size Sales Quantity Sales Dollars Sales Price This is the description of the product This is the size of the product Quantity sold on the Sales Date Quantity multiplied by the Sales Price Sales price charged to consumers Date of the sale to the consumer Numeric size of the product Products are classified as either Spirits (I) or Wine (2) Sales Date Volume Classification Excise Tax Amount of excise tax collected from the consumer to be remitted to the State of Lincoln Vendor No Bibitor assigns a Vendor Number to each supplier Supplier name Vendor Name 20XXPurchase Prices Month.csv Brand Bibitor creates their own Brand Numbers for each liquor or wine purchased. Description Price This is the description of the product This represents the highest sales price during the year. It does not represent the average sales prices or the last sales price, Size Volume Classification Purchase Price This is the size of the product Numeric size of the product Products are classified as either Spirits (I) or Wine (2) Purchase Price for each product. Bibitor assigns a Vendor Number to each supplier Supplier nome Vendor Number Vendor Name Invoice Purchases MMDDYYY.csv Vendor Number Vendor Name Invoice Date Bibitor assigns a Vendor Number to each supplier Supplier name Date the Vendor Invoice was received. Date Central Purchasing issued Purchase Order Number to the Vendor. PONumber PODate Date of receipt of the Vendor drop shipment at the respective Store Pay Date Quantity Date Accounting Paid the Vendor Invoice Total Quantity Drop Shipped by the Vendor to the various retail locations Dollars Freight Approval Total Purchase Amount for the Quantity Drop Shipped Freight Charges for each purchase order. Identified name of approving individuals for purchases without freight charges FinalPayrollMonth YYYY.csv PayPeriod There are 24 consecutively numbered pay periods each year. Beg Date For each pay period, this is the first day in the pay period EndDate For each pay period, this is the last day in the pay period ID Employee IDs are assigned to each employee. The first two digits signify the type of employee. 00- Retail Store Managers 01- Full l'ime Retail Employees (Clerk II and III) 02 - Full and Part Time Retail Employees (Clerk I) 03 - Retail Store Receivers 04 - Corporate Office Employees FirstName First name of the employee LastName Last name of the employee Store The client numbers their stores Tide Employee's job title Rate PerHour For hourly employees, the amount of money earned for each hour worked Salary For salaried employees, the annual salary SalaryWagesPerPP For both hourly and salaried employees, the amount of gross pay Hours For hourly employees, the number of hours worked in a pay period Fed Tax Federal tax withholding each pay period Strax State tax withholding each pay period FICA Social security tax withholding each pay period Em Fica Employer matching of social security tax each pay period Medicare Medicare tox withholding each pay period Em Medicare Employer portion of Medicare tax each pay period Month YYYYPeriodExpense.csv Date Date the expense was incurred Vendor Name Goods or service supplier nome Account General Ledger Account in Netsuite.com Amount Dollar amount of the expense incurred