P P EmployeeID * FirstName * LastName Manager Address Title Department ManagerlD F F SalaryID NUMBER (10) NUMBER (10) EMPLOYEE_PK (EmployeeID) MANAGER_FK (ManagerID) SALARY_FK (SalaryID) SALARY NUMBER (10) NUMBER (10,2) VARCHAR2 (50) EMPLOYEE NUMBER (10) VARCHAR2 (50) VARCHAR2 (50) NUMBER VARCHAR2 (50) VARCHAR2 (10) VARCHAR2 (50) SalaryID Amount Type SALARY_PK (SalaryID) P F IF RenegotiationID ApprovalDate Department OfferedPrice EmployeelD PurchaseID RENEGOTIATION NUMBER (10) DATE VARCHAR2 (50) NUMBER (10,2) NUMBER (10) NUMBER (10) RENEGOTIATION PK (RenegotiationID) EMPLOYEE_FKv1 (EmployeelD) PURCHASE_FK (PurchaseID) IP IF F IF * PurchaselD * Purchase Date CompanyPrice Sale Price PricePerUnit TotalPrice Customer D ProductID * EmployeelD " PURCHASE SALES_PK (PurchaseID) CUSTOMER FK (CustomerID) PRODUCT_FK (ProductID) EMPLOYEE FK (EmployeeID) P " IF NUMBER (10) DATE NUMBER (10,2) NUMBER (10,2) NUMBER (10,2) NUMBER (10,2) NUMBER (10) NUMBER (10) NUMBER (10) ProductID Name * VendorID PRODUCT P VendorID Name NUMBER (10) VARCHAR2 (100) NUMBER (10) PRODUCT_PK (ProductID) PRODUCT VENDOR_FK (VendorID) VENDOR NUMBER (10) VARCHAR2 (100) VARCHAR2 (100) NUMBER (10,2) NUMBER (10) Company VendorPrice Quantity VENDOR_PK (VendorID) P CustomerSatisfactionID * Score Date " SatisfactionScore F CustomerlD F * ProductID P IF P NUMBER (10) NUMBER (10) NUMBER (10) CUSTOMER SATISFACTION PK (Customer SatisfactionID) SATISFACTION_CUSTOMER_FK (CustomerID) SATISFACTION PRODUCT_FK (ProductID) 1.1 " CUSTOMER CustomerlD FirstName * LastName CUSTOMER SATISFACTION NUMBER (10) DATE CUSTOMER_PK (CustomerID) NUMBER (10) VARCHAR2 (50) VARCHAR2 (50) PAYMENT PaymentID PaymentDate PaymentType Payment Amount Comments NUMBER (10) DATE VARCHAR2 (50) NUMBER (10,2) VARCHAR2 (500) NUMBER (10) * VendorlD COMPANY_PK (PaymentID) VENDOR FK (VendorID) Cl Ansicht Einfgen Ansichten Alle Tabellen Sales 43 Start Erstellen Externe Daten Managers HAR Bereit H Sales : Tabelle Operation Expenses Zwischenablage Managers: Tabelle = Ausschneiden Kopieren Format bertragen < < OperationExpenses : Tabelle O Type here to search M Datenbanktools E F KUA Beziehungen Managers Schriftart ManagerFirstName ManagerLastName ManagerTitle Beziehungstools Datenbank1: Datenbank (Access 2007) - Microsoft Access Entwurf EmployeeFirstName EmplooyeeLastName EmployeeTitle Q 8: e [ =:= ab T Rich-Text Operation Expenses Neu Speichern Alle aktualisieren X Lschen X Lschen EmployeeFirstName/VendorName EmployeeLastName PaymentType PaymentAmount PaymentDate Address Quanity Apt City Datenstze Province PostalCode Comments Summen Rechtschreibung Rechtschreibung 20 Weitere LO P Filtern Filter ein/aus Sortieren und filtern Sales Auswahl .... Erweitert CompanyName RecipientFirstName RecipientLastName Product Quanity og Address Apt City Province Postal Code PricePerUnit TotalPrice Sales ManFirstName Sales ManLastName Suchen ab Ersetzen Gehe zu Markieren- Suchen 4) ENG 8:36 PM 2020-03-21 X (3) X