问题 单项选择题

某商场的部门、员工和商品3个实体之间的关系如图5-4和表5-1至表5-4所示。


表5-1 部门信息

部门号 名称 电话
001 家电部 1001
002 百货部 1002
003 食品部 1003
表5-2 商品信息
商 品 号 名 称 单 价 库 存 量
30023 微机 4800 26
30024 打印机 1650 7
…… …… …… ……
30101 毛巾 10 106
30102 牙刷 3.8 288
…… …… …… ……
表5-3 员工信息1
员 工 号 姓 名 住 址
E001 王 军 南京路
E002 李晓斌 淮海路
E021 柳烨 江西路
E026 田波 西藏路
E028 李晓斌 西藏路
E029 刘丽华 淮海路
E030 李彬彬 唐山路
…… …… ……
表5-4 员工信息2
员工号 姓名 部门号 月销售额
E001 王军 001 528900
E002 李晓斌 001 368000
…… …… …… ……
E021 柳烨 002 12500
…… …… …… ……
E028 李晓斌 003 82500
…… …… …… ……
假设每个部门有若干名员工,每种商品只能由一个部门负责销售。如果用户要求得到如表5-4所示的结果,则需要 (60) ,并增加关系模式 (61) 。如果要求查询某部门负责销售的商品,则需要 (62)

答案

参考答案:D

单项选择题 A1/A2型题
单项选择题

Questions 58 to 62 are based on the following passage:In the past century Irish painting has changes from a British-influenced lyrical tradition to an art that evokes the ruggedness (朴实) and roots of an Irish Celtic past. At the turn of the twentieth century Irish painters, including notables Walter Frederick Osborne and Sir William Orpen, looked elsewhere for influence. Osborne’s exposure to ’plain air’ painting deeply impacted his stylistic development; and Orpen allied himself with a group of English artists, while at the same time participated in the French avant-garde experiment, both as painter and teacher.However, nationalist energies were beginning to coalesce (接合 ), reviving interest in Irish culture-including Irish visual arts. Beatrice Elvery’s (1907), a landmark achievement, merged the devotional simplicity of fifteenth-century Italian painting with the iconography (图像学) of Ireland’s Celtic past, linking the history of Irish Catholicism with the still-nascent (初生的 )Irish republic. And, although also captivated by the French plain air school. Sir John Lavery invoked the mythology of his native land for a 1928 commission to paint the central figure for the bank note of the new Irish Free State. Lavery chose as this figure, with her arm on a Celtic harp (竖琴), the national symbol of independent Ireland.In Irish painting from about 1910, memories of Edwardian romanticism coexisted with a new sense of realism, exemplified by the paintings of Paul Henry and Se Keating, a student of Orpen’s. Realism also crept into the work of Edwardians Lavery and Orpen, both of whom made paintings depicting World War I, Lavery with a distanced Victorian nobility, Orpen closer to the front, revealing a more sinister and realistic vision. Meanwhile, counterpoint ( 对照 ) to the Edwardians and realists came Jack B. Yeats, whose travels throughout the rugged and more authentically Irish West led him to depict subjects ranging from street scenes in Dublin to boxing matches and funerals. Fusing close observations of Irish life and icons with an Irish identity in a new way, Yeats changed the face of Irish painting and became the most important Irish artist of his century.

Which of the following art most probably exerted the greatest influence on Irish painting in the 19th century

A.British lyrical tradition

B.French avant-garde experiment

C.nationalist energies

D.Italian painting