Redcat Shoes

Database Schema for Redcat Shoes Data

customer customer.customerid customer.firstname customer.lastname customer.streetaddress customer.city customer.state customer.postalcode customer.country customer.phone manufacturer manufacturer.manufacturerid manufacturer.manufacturername manufacturer.address1 manufacturer.address2 manufacturer.city manufacturer.state manufacturer.postalcode manufacturer.phone manufacturer.fax manufacturer.contact manufacturer.url product product.productid product.productname product.manufacturerid product.composition product.listprice product.gender product.category product.color product.description sale.saleid sale.saledate sale.customerid sale.tax sale.shipping saleItem saleItem.saleid saleItem.productid saleItem.itemsize saleItem.quantity saleItem.saleprice inventoryItem inventoryItem.productid inventoryItem.itemsize inventoryItem.qtyonhand itemSize itemSize.itemsize purchaseItem purchaseItem.productid purchaseItem.itemsize purchaseItem.purchaseid purchaseItem.quantity purchaseItem.purchasePrice purchase purchase.purchaseid purchase.purchasedate purchase.employeeid purchase.expecteddeliverydate purchase.manufacturerid purchase.shipping employee employee.employeeid employee.firstname employee.lastname employee.address employee.city employee.state employee.zip employee.phone employee.managerid employee.ssn employee.emailaddress employee.hiredate wageEmployee wageEmployee.employeeid wageEmployee.wage wageEmployee.maxhours salaryEmployee salaryEmployee.employeeid salaryEmployee.salary customer JOIN sale ON customer.customerid = sale.customerid sale JOIN saleItem ON sale.saleid = saleItem.saleid saleItem JOIN inventoryItem ON saleItem.productid = inventoryItem.productid AND saleItem.itemsize = inventoryItem.itemsize purchaseItem JOIN inventoryItem ON purchaseItem.productid = inventoryItem.productid AND purchaseItem.itemsize = inventoryItem.itemsize inventoryItem JOIN itemSize ON inventoryItem.itemsize =itemSize .itemsize purchaseItem JOIN purchase ON purchaseItem.purchaseid = purchase.purchaseid employee JOIN purchase ON employee.employeeid = purchase.employeeid employee JOIN wageEmployee ON employee.employeeid = wageEmployee.employeeid employee JOIN salaryEmployee ON employee.employeeid = salaryEmployee.employeeid product JOIN manufacturer ON product.manufacturerid = manufacturer.manufacturerid inventoryItem JOIN product ON inventoryItem.productid = product.productid manufacturer JOIN purchase ON manufacturer.manufacturerid = purchase.manufacturerid