以下是EMPLOYEE表的详细定义，其中也包括了约束的描述。

EMPLOYEE
Column Name	EMPLOYEE_ID	NAME	JOB	MANAGER	DATE_HIRED	SALARY	BONUS	DEPIARTMENT_ID
Key-Type	PK
Nulls/Unique	NN，U				NN			NN
FK Table
FK Column
Datatype	HUM	VARCHAR2	VARCHAR2	NUM	DATE	NUM	HUM	NUM
Length	6	20	9	6		7, 2	7, 2	2

基于这个EMPLOYEE表创建了一个视图，并允许用户通过这个视图向EMPLOYEE表中插入数据。请问，在如下的语句中，应该使用哪个语句创建这个视图

A．CREATE VIEW department_v
AS SELECT DISTINCT department
FROM
employee;
B．CREATE VIEW emp_info_v
AS SELECT employee_id, name, job, manager
FROM
employee;
C．CREATE VIEW emp_info_v
AS SELECT employee_id, name, job, manager, department_id, date_hired
FROM
employee;
D．CREATE VIEW dept_salary_v
AS SELECT department_id，AVG (salary) "average salary"
FROM
employee
GROUP BY department_id;