Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Zad. 4. Dodać integralność referencyjną i klucze główne do tabel już zdefiniowanych.
- USE AdventureWorks2014
- GO
- ALTER TABLE Mandziejewska.DIM_CUSTOMER
- ADD CONSTRAINT pk_dim_customer PRIMARY KEY(CustomerID);
- GO
- ALTER TABLE Mandziejewska.DIM_PRODUCT
- ADD CONSTRAINT pk_dim_product PRIMARY KEY(ProductID);
- GO
- ALTER TABLE Mandziejewska.DIM_SALESPERSON
- ADD CONSTRAINT pk_dim_salesperson PRIMARY KEY (SalesPersonID);
- ALTER TABLE Mandziejewska.FACT_SALES
- ADD FactSalesID int NOT NULL IDENTITY(1,1) PRIMARY KEY;
- GO
- ALTER TABLE Mandziejewska.FACT_SALES
- ADD CONSTRAINT fk_fact_product FOREIGN KEY (ProductID) REFERENCES Mandziejewska.DIM_Product(ProductID),
- CONSTRAINT fk_fact_customer FOREIGN KEY (CustomerID) REFERENCES Mandziejewska.DIM_CUSTOMER(CustomerID),
- CONSTRAINT fk_fact_salesperson FOREIGN KEY (SalesPersonID) REFERENCES Mandziejewska.DIM_SALESPERSON(SalesPersonID);
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement