数据库实验报告2.doc

数据库实验报告2.doc实验报告
〔 2015 / 2016 学年 第 2 学期〕
题 目：数据库系统原理
专业： 物联网工程
学生：
班级学号：
指导教师：
指导单位： 物联网es、moviestar、starsin、movieexec、studio。
2、运行语句
添加约束：
①ALTER TABLE movies ADD CONSTRAINT cproducerc
FOREIGN KEY(producerC) references MovieExec(cert);
②ALTER TABLE StarsIn ADD CONSTRAINT cmovies
FOREIGN KEY(movieTitle,movieYear) references movies(title,year);
③ALTER TABLE movies ADD CONSTRAINT cyear
CHEAK(year>=1915);
④ALTER TABLE movies ADD CONSTRAINT clength
CHEAK(length>=60 AND length<=250);
添加要求的视图和索引：
⑤CREATE VIEW RichExec AS
SELECT name,address,cert,netWorth
FROM MovieExec
WHERE netWorth>=10000000;
⑥CREATE VIEW StudioPress AS
SELECT ,,cert
FROM MovieExec,Studio
WHERE =;
⑦CREATE VIEW ExecutiveStar AS
SELECT , ,gender,birthdate,netWorth
FROM MovieStar,MovieExec
WHERE = AND =;
⑧CREATE INDEX aindex ON StarsIn(StarName);
3、调用存储过程〔函数〕，求Laptop内存容量的平均值和总和。
create function laptop() returns setof real
as $$
declare ramcount int :=0;
sum int:=0;
ramloop int;
ave real ;
begin
for ramloop in
select ram fro