Question: Please identify constraints (entity, referential, domain, and enterprise) for each relation below and explain why. -------------------------------------------------------------------------------- Warehouse (WarehouseNo, Address, Phone_Number , Email) Vendor(VendorID, Address, Phone_Number
Please identify constraints (entity, referential, domain, and enterprise) for each relation below and explain why. -------------------------------------------------------------------------------- Warehouse (WarehouseNo, Address, Phone_Number, Email)
Vendor(VendorID, Address, Phone_Number, Email)
Employee (EmpId, FName, LName, SSN, Address, Email, Phone_Number, Dept, Position)
Customer (CustID, CustType, FName, LName, Email, Phone Number, AR, AP)
Inventory (ItemID, Name, Description, UnitCost, UnitPrice, Instock_Quantity, BackOrder_Quantity, WarehouseNo, LocationInWarehouse)
Purchase (PurchaseNo, ItemID, Date, Instock_Quanity, UnitCost, Purchase_Status, VendorID)
Sales (SaleID, Date, ItemID, units, paymentstatus, transtype, Instock_Quantity
BackOrder _Quantity, CustID)
SacCorporation (Fed taxid, State taxid, Sac name, Contact name, Address, Phone, Email)
Division (Div ID, Div type, Name, Employee ID, Fed taxid, State taxid)
Department (Dept ID, Dept Name, Manager ID, Div ID, Phone)
Sales item ( Item ID, Sales ID, Quantity, Unit Price, SalesPayment ID, Payment type,
Amount, Employee ID)
Sales Payment (SalesPayment ID, Paymenttype, Amount, Employee ID, Customer ID)
Item (Item ID, Name, Description, Category, Unit Price, Date, Div ID)
Order (Order ID, Order date. Delivery date. Vendor ID. Employee ID)
Order Item (Order ID, Item ID, Quantity Unit Price)
Order Payment (OrderPayment ID, Vendor ID, Payment amount, Date, Emplovee ID)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
