3.12使用大学模式,用SQL写出如下查询。
a.创建一门课程"CS-001",其名称为"Weekly Seminar",学分为0.
insert into course values('CS-001', 'Weekly Seminar', NULL, 0);
插入失败,原因如下:
ERROR: new row for relation "course" violates check constraint "course_credits_check"
DETAIL: Failing row contains (CS-001, Weekly Seminar, null, 0).
SQL state: 23514
原来是违反了字段检查规则,因为我们在创建course关系的时候,对credits学分这个字段有限制,要求大于0。
create table course
(course_id varchar(8),
title varchar(50),
dept_name varchar(20),
credits numeric(2,0) check (credits > 0),
primary key (course_id),
foreign key (dept_name) references department
on delete set null
);
为了能成功插入数据,将学分改成1:
insert into