DEe7hJmi

1--Vues
2--Question a)
3CREATE TABLE DEPT(    
4	DEPT_ID NUMERIC(4,0) NOT NULL PRIMARY KEY IDENTITY(0, 1),
5    DEPT_NAME VARCHAR(25)
6   ) ;
7
8exec sp_help dept;
9
10--Question i)
11DROP TABLE IF EXISTS EMP;
12CREATE TABLE EMP (
13	ID NUMERIC(7,0) NOT NULL PRIMARY KEY IDENTITY(0, 1),
14	LAST_NAME VARCHAR(25),
15	FIRST_NAME VARCHAR(25),
16	DEPT_ID NUMERIC(4, 0),
17	FOREIGN KEY(dept_id) REFERENCES DEPT(DEPT_ID)
18);
19
20--Question j)
21SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.LAST_NAME, EMPLOYEES.FIRST_NAME, EMPLOYEES.SALARY, EMPLOYEES.DEPARTMENT_ID into EMP2 from EMPLOYEES
22
23--Question l
24
25CREATE VIEW EMPLOYEES_VIEW AS SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, DEPARTMENT_ID FROM EMPLOYEES;
26
27--Question m
28CREATE VIEW DEPT50 AS SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 50;
29
30select * from DEPT50;