SACCorp(CompanyID, Name, Address, Phone, FedTaxNo, StateTaxNo, DivisionID, SalesPayment, PurchasePayment) Division (DivisionID, DivisionType, Name, Address, Phone, FedTaxNo, StateTaxNo)
Question:
SACCorp(CompanyID, Name, Address, Phone, FedTaxNo, StateTaxNo, DivisionID, SalesPayment, PurchasePayment)
Division (DivisionID, DivisionType, Name, Address, Phone, FedTaxNo, StateTaxNo)
Employee (EmpID, FName, LName, Address, DOB, SSN, Position, Sex, DriverLisNo, Salary, HireDate, TerminationDate, CompanyID)
Sales (SalesID, Date, SalePrice, QuantitySold, TransType, SalesPayment, Amount, EmpID, CustID, DivisionID)
SalesItem (SalesID, ProductNo, UnitPrice, Quantity)
Inventory (ProductNo, ProdName, Description, Date, OnHandQuantity, DivisionID, SalesID)
Purchase (PurshaseID, Date, Amount, PurchasePayment, PurchaseType,VendorID, EmpID)
PurchasedItem (PurshaseID, ProductNo, UnitPrice, Quantity)
Vendor (VendorID, VendorName, Address, Phone, Email, FedTaxNo, StateTaxNo)
Customer (CustID, FName, LName, Address, Phone, Email)
Transfer (TransferID, DivisionIDto, DivisionIDfrom, EmpIDfrom, EmpIDto, Date)
TransferItem (TransferID, ProductNo, Quantity, Date)
1 Error handling method due to mistakes in the data.
2 Security discussions for the company database.
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe