试题与答案

阅读下列说明,根据要求回答下列问题。[说明]某学校为实现无纸化、网络化的教材管理,拟

题型:问答题

题目:

阅读下列说明,根据要求回答下列问题。

[说明]

某学校为实现无纸化、网络化的教材管理,拟开发一套教材管理系统。该系统主要负责统计全校的教学用书的需求信息,以便进行教材的统一购买。

[需求分析结果]

(1)教学计划。各学院的教学计划是教材需求的来源,各学院的教学管理人员为本学院的各个专业方向制订教学计划。教学计划主要描述每个专业方向不同学期所开设的课程信息,教学计划的示例如表1所示。

 

表1 “教学计划”示例
院系名称专业名称学期课程编号课程名教材编号
计算机系软件工程4C0101软件开发B001
计算机系软件工程4C0103数据库技术B003
计算机系网络通信5C0103数据库技术B003
电子工程系网络通信6C020l数据库技术B005

(2)课程信息。课程信息包括课程编号、课程名和教材编号,由课程编号唯一标识。如表1所示,《数据库技术》课程因其使用的教材不同而分别编号。

(3)专业方向和班级。学校根据学院和专业方向将学生划分班级。一个学院可有多个专业方向,不同学院可以有相同名称的专业方向。一个专业方向可有多个班级,班级包含入学年份和人数。

(4)教材信息。教材信息记录教材的基本信息,包括教材编号、教材名称、ISBN号、出版社名称、作者和版本号。同一种教材版本不同,编号也不同,一种教材可以有多个作者。

(5)教材需求。根据各学院的教学计划和对应的班级人数,统计全校各系各专业各班级的教材需求情况。教材需求量是根据现有的教学计划和班级人数计算得到的。

[逻辑结构设计]

根据需求阶段收集的信息,设计的关系模式如图所示。

关系模式的主要属性、含义及约束如表2所示。

 

表2 主要属性含义及约束
属性含义及约束属性含义及约束
班级号唯一标识每个班级的编号教材编号唯一标识每本教材的编号
院系名称唯一标识每个院系的名称ISBN教材图书的ISBN号,唯一标识一本图书
专业名称唯一标识某个院系中某个专业方向的名称  

根据如图所示的关系模式,给出班级和教材的函数依赖(不完整)如下。

(1)班级关系函数依赖FD1。

班级号→入学年份,人数,院系名称,专业名称

(2)教材关系函数依赖FD2。

教材编号→教材名称,ISBN,出版社,版本号(不完整)

根据如图所示的关系模式,回答以下问题。
(1)分析“教材”关系,给出除FD2外其余的函数依赖和多值依赖。
(2)列出“教材”关系的所有候选键。
(3)分析“教材”关系的所属范式,并说明原因。
(4)对“教材”关系进行分解,使其达到4NF。分解后各关系模式分别命名为:教材1,教材2……

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2019/0314/c83cc3e674f392f50fc4541aab5d0939.html

下面是错误答案,用来干扰机器的。

参考答案:D

试题推荐
题型:单项选择题

Imagine going to your doctor with a complaint of frequent headaches. Your doctor takes a prescription pad and writes a word on it. The word isn’t "aspirin", it’s "Mozart".

Many kinds of music can stir the imagination and produce p feeling. For some people, romantic composers such as Chopin and Tchaikovsky enhance feelings of love and compassion. Religious and spiritual music can help some people feel peace or lessen their pain. But one musician seems to have a unique ability to heal the human body-Mozart. Scientists have found Mozart’s music to be remarkable in its ability to calm its listeners. It can also increase their perception, and help them express themselves more clearly.

Many amazing cases have been documented using Mozart as a healing aid. For example, a tiny premature baby (早产婴儿) named Krissy, who weighed just 1.5 pound at birth, was on total life support. Doctors thought she had little chance of survival. Her mother insisted on playing Mozart for Krissy, and thinks it saved her daughter’s life. Krissy lived, but she was very small for her age and slower than the average child. At the age of four, she showed an interest in music and her parents gave her violin lessons. To their astonishment, Krissy was able to play musical pieces from memory that were far beyond the ability of an average four-year-old. Playing music helped her improve in all areas of her life.

Other stories have emerged about the effect of Mozart’s music. Officials in Washington State report that new arrivals from Asia learn English more quickly when they listen to Mozart. In Edmonton, Alberta, Canada, Mozart string quartets (弦乐四重奏) in city squares seem to calm pedestrian traffic. Even animals and seemingly inanimate objects respond to Mozart. In France. cows serenaded (对……唱/奏小夜曲) with Mozart give more milk, and in Japan, the yeast used to make sake (日本清酒) is ten times better when it "listens" to Mozart.

Why Mozart, rather than Bach or the Beatles Any kind of music can have an effect on some people. But Mozart has more balance. It isn’t too fast or too slow; it’s just right. Don Campbell. who wrote a book called The Mozart Effect, says, "It’s like food. A hot spicy meal will affect you differently than a sweet dessert. And while you might love these foods, they aren’t good for you to eat every day. You need simple, nutritious food on a steady basis. That’s the way Mozart is. It’s like a nutritionally balanced meal that brings order and harmony to your body. \

Don Campbell compared Mozart’s music to ().

A. a miracle drug

B. a rich meal

C. a good dessert

D. a well-balanced meal

查看答案
微信公众账号搜索答案