《Database System Concepts（数据库系统概念）》第六版——第一次作业（第二章）

最新推荐文章于 2024-05-19 17:03:37 发布

JeekZhang

最新推荐文章于 2024-05-19 17:03:37 发布

阅读量117

点赞数 1

分类专栏：数据库系统概念文章标签：数据库 sql java

本文链接：https://blog.csdn.net/qq_50939442/article/details/129936659

版权

数据库系统概念专栏收录该内容

10 篇文章 0 订阅

订阅专栏

2.12

a.
$\Pi_{person-name}(\sigma_{company-name="First Bank Corporation"}(works))$
b.
$\Pi_{person-name,city}(\sigma_{company-name="First Bank Corporation"}(works⋈employee))$
c.
$\Pi_{person-name,street,city}(\sigma_{company-name="First Bank Corporation" \wedge salary>\$10000 }(works⋈employee))$

2.13

a.
$\Pi_{loan\_number}(\sigma_{amount>\$10000}(loan))$
b.
$\Pi_{customer\_name}(\sigma_{balance>\$6000}(customer⋈depositor⋈account))$
c.
$\Pi_{customer\_name}(\sigma_{balance>\$6000\wedge branch\_name="Uptown"}(depositor⋈account))$

3.1

select title
from course
where dept_name in ('Comp.','Sci.') and credit=3;

c.
```
select max(salary)
from instructor
```

select name
from instructor
where salary=(select max(salary) from instructor)

3.13

create table person(
    driver_id        varchar(100),
    name             varchar(100),
    address          varchar(100),
    primary key (driver_id));
    
create table car(
    license          varchar(100),
    model            varchar(100),
    year             numeric(4,0),
    primary key (license));    
    
create table accident(
    report_number    int,
    date_            date,
    location         varchar(100),
    primary key (report_number));  

create table owns(
    driver_id        varchar(100),
    license          varchar(100),
    primary key (driver_id),
    foreign key (driver_id) references person,
	foreign key (license) references car);
  
create table participated(
    report_number     int,
    license           varchar(100),
    driver_id         varchar(100),
    damage_amount     int,
    primary key (report_number,license),
    foreign key (driver_id) references person,
    foreign key (report_number) references accident,
	foreign key (license) references car);