题目内容

文件是如何进行分类的举例说明。

查看答案
更多问题

案例分析题给定关系模式R(U,F),U=A,B,C,D,E,F=B→A,D→A,A→E,AC→B,其候选关键字为(),则分解ρ=R1(ABCE),R2(CD)满足()。 则分解ρ=R1(ABCE),R2(CD)满足()

A. 具有无损连接性、保持函数依赖
B. 不具有无损连接性、保持函数依赖
C. 具有无损连接性、不保持函数依赖
D. 不具有无损连接性、不保持函数依赖

案例分析题Currently the Pentium chip or () , made by () , is the most common CPU though there are many other companies that produce processors for personal computers. One example is the CPU made by Motorola which is used in Apple computers. With faster processors the clock speed becomes more important. Compared to some of the first computers which operated at below 30 megahertz ( () ) the Pentium chips began at 75 megahertz in the late 1990g. As of mid 2003 speeds now exceed 3000 + megahertz or 3 gigahertz (check your local computer store for the latest speed) . It depends on the () that the chip is housed in, or the () , as to whether you are able to upgrade to a faster chip. The motherboard contains the circuitry and connections that allow the various component to communicate with each other. Compared to some of the first computers which operated at below 30 megahertz ( () ) the Pentium chips began at 75 megahertz in the late 1990g.

A. MHz
B. MEG
C. MTZ
D. MGH

案例分析题某医院管理系统部分关系模式为:科室(科室号,科室名,负责人,电话)、病患(病历号,姓名,住址,联系电话)和职工(职工号,职工姓名,科室号,职位,住址,联系电话)。假设每个科室有一位负责人和一部电话,每个科室有若干名职工,一名职工只属于一个科室;一个医生可以为多个病患看病;一个病患可以由多个医生多次诊治;职位有医生、护士和其他。a.科室和职工的所属联系类型是(1),病患和医生的就诊联系类型是(2)。科室关系的主键和外键分别为(3)。对于就诊联系最合理的设计是(4),就诊关系的主键是(5)。b.若科室关系中的科室名是唯一的,并要求指出外码。请将下述SQL语句的空缺部分补充完整。CREATE TABLE 科室 (科室至号 CHAR(3) PRIMARY KEY,科室名 CHAR(10) (6),负责人 CHAR(4),电话 CHAR(20),(7)); (2)处应选择()

A. 1:1
B. 1:n
C. n:1
D. n:m

案例分析题某医院管理系统部分关系模式为:科室(科室号,科室名,负责人,电话)、病患(病历号,姓名,住址,联系电话)和职工(职工号,职工姓名,科室号,职位,住址,联系电话)。假设每个科室有一位负责人和一部电话,每个科室有若干名职工,一名职工只属于一个科室;一个医生可以为多个病患看病;一个病患可以由多个医生多次诊治;职位有医生、护士和其他。a.科室和职工的所属联系类型是(1),病患和医生的就诊联系类型是(2)。科室关系的主键和外键分别为(3)。对于就诊联系最合理的设计是(4),就诊关系的主键是(5)。b.若科室关系中的科室名是唯一的,并要求指出外码。请将下述SQL语句的空缺部分补充完整。CREATE TABLE 科室 (科室至号 CHAR(3) PRIMARY KEY,科室名 CHAR(10) (6),负责人 CHAR(4),电话 CHAR(20),(7)); (4)处应选择()

A. 就诊(病历号,职工号,就诊情况)
B. 就诊(病历号,职工姓名,就诊情况)
C. 就诊(病历号,职工号,就诊时间,就诊情况)
D. 就诊(病历号,职工姓名,就诊时间,就诊情况)

答案查题题库