Sari-Sari Store Database System

DATA DICTIONARY. FIELD NAME DATA TYPE SIZE CONSTRAINT DESCRIPTION ­BarcodeNo int 20 Not Null Product Barcode Name Varchar 100 Null Name of the Product Variation Varchar 100 Null Variation of the Product Price Decimal 10,2 Null Price of Product Quantity int 11 Null Quantity of the product ExpirationDate Date Null Expiration Date of the Product DatePurchased Date Null Purchased date of the Product.

DATA DICTIONARY. FIELD NAME DATA TYPE SIZE CONSTRAINT DESCRIPTION ­ItemID int 11 Not Null Item id Price Decimal 10,2 Null Price of the Item ProducID int 11 Null Product Id TransactionID int 11 Null Transaction Id Quantity int 11 Null Quantity of the items.

DATA DICTIONARY. FIELD NAME DATA TYPE SIZE CONSTRAINT DESCRIPTION ­TransactionNo int 11 Not Null Transaction id TransactionDate DateTime Not Null Date of the Transaction AmmountSold Decimal 10,2 Null Total amount sold of the transaction PaymentMethod Varchar 50 Payment.

DATA DICTIONARY. FIELD NAME DATA TYPE SIZE CONSTRAINT DESCRIPTION CustomerID int 20 Not Null Customer id FName Varchar 100 Not Null First name of the customer LName Varchar 100 Not Null Last name of the customer.

DATA DICTIONARY. FIELD NAME DATA TYPE SIZE CONSTRAINT DESCRIPTION CreditID int 20 Not Null Credit id TransactionID int 20 Not Null Transaction id CustomerID int 20 Not Null Customer id.

ENTITY RELATIONSHIP DIAGRAM.

DATA FLOW DIAGRAM LEVEL 0.

LEVEL 1.

LEVEL 2.

HIERARCHAL DIAGRAM.