Assignment

Create a data entry for each of the following table:

Database Name: dbInventory

tblProducts
prod_id auto
prod_name text(50)
prod_barcode text(20)
prod_brand int
prod_unit int
prod_category int
prod_supplier int
prod_costPrice currency
prod_sellingPrice currency

tblBrands
brand_id auto
brand_name text(50)

tblUnit
unit_id auto
unit_name text(50)

tblCategory
cat_id auto
cat_name text(50)

tblSupplier
sup_id auto
sup_name text(50)
sup_address text(50)
sup_contactPerson text(50)
sup_contactNumber text(500)

Brands, Unit, CAtegory and Supplier are all lookup tables