问题 单项选择题

某公司的部门(部门号,部门名,负责人,电话)、商品(商品号,商品名称,单价,库存量)和职工(职工号,姓名,住址)三个实体对应的关系如表1、表2和表3所示。

假设每个部门有一位负责人,一个负责人只有一部电话,但有若干名员工;每种商品只能由一个部门负责销售。

①部门关系不属于第三范式的原因是 (36) 。如果用户要求得到表4所示的结果,需要 (37) ,并增加关系模式 (38)

②若部门名是唯一的,请将下述部门SQL语句的空缺部分补充完整。

CREATE TABLE 部门 (部门号 CHAR(3) PRIMARY KEY,

部门名CHAR(10) (39)

负责人CHAR(4),

电话CHAR(20))

(40) );

③查询各部门负责人的姓名及住址的SQL语句如下:

SELECT 部门名,姓名,住址

FROM 部门,职工 (41)

(37)处应填()。

A.修改表1的结构,在表1中增加一个职工号

B.修改表2的结构,在表2中增加一个职工号

C.修改表2的结构,在表2中增加一个部门号

D.修改表3的结构,在表3中增加一个部门号

答案

参考答案:D

单项选择题

In 1930, W. K. Kellogg made what he thought was a sensible decision, grounded in the best economic, social and management theories of the time. Workers at his cereal plant in Battle Greek, Mich. were told to go home two hours earlier, every day for good.
The Depression-era move was hailed in Factory and Industrial Management magazine as the "biggest piece of industrial news since Henry Ford announced his five-dollar-a-day policy." It’s believed that industry and machines would lead to workers’ paradises where all would have less work, more free time, and yet still produce enough to meet their needs.
So what happened Today, instead of working less, our hours have stayed steady or risen- and today many more women work so that families can afford the trappings of suburbia. In effect, workers chose the path of consumption over leisure.
With unemployment at a nine-year high and many workers worded about losing their jobs- or forced to accept cutbacks in pay and benefits -- work is hardly the paradise economists once envisioned.
The modern environment would seem alien to pre-industrial laborers. For centuries, the household -- from farms to "cottage" craftsmen -- was the unit of production. The whole family was part of the enterprise, be it farming, blacksmithing, or baking. "In pre-industrial society, work and family were practically the same thing," says Gillis.
The Industrial Revolution changed all that. Mills and massive iron smelters required ample labor and constant attendance. For the first time, work and family were split. Instead of selling what they produced, workers sold their time. With more people leaving farms to move to cities and factories, labor became a commodity and placed on the market like any other.
Innovation gave rise to an industrial process based on machinery and mass production. The theories of Frederick Taylor, a Philadelphia factory foreman, led to work being broken down into component parts, with each step timed to coldly quantify jobs that skilled craftsmen had worked a lifetime to learn. Workers resented Taylor and his stopwatch, complaining that his focus on process stripped their jobs of creativity and pride, making them irritable. Long before anyone knew what "stress" was, Taylor brought it to the workplace- and without sympathy.
The division of work into components that could be measured and easily taught reached its apex in Ford’s River Rouge Plant in Dearborn, Mich., where the assembly line came of age. To maximize the production lines, businesses needed long hours from their workers. But it was no easy to sell.
Labor leaders fought back with their own propaganda. For more than a century, a key struggle for the labor movement was reducing the amount of time workers had to spend on the job.
Between 1830 and 1930, work hours were cut nearly in half, with economist John Maynard Keynes famously predicting in 1930 that by 2030 a 15-hour workweek would be standard. While work had once been a means to serve God, two centuries of choices and industrialization had turned work into an end in itself, stripped of the spiritual meaning that sustained the Puritans who came ready to tame the wilderness.
By the end of the 1970s, companies were reaching out to spiritually drained workers by offering more engagement while withdrawing the promise of a job for life, as the American economy faced a stiff challenge from cheaper workers abroad. By the 1990s, technology made working from home possible for a growing number of people. Seen as a boon at first, telecommuting and the rapidly proliferating "electronic leash" of cell phones made work inescapable, as employees found themselves on call 24/7. Today, almost half of American workers use computers, cell phones, E-mail, and faxes for work during what is supposed to be nonwork time. Home is no longer a refuge but a cozier extension of the office.
When the stock market bubble burst and the economy fell into its recent recession, workers were forced to re-evaluate their priorities. They want a better quality of life; they’re asking for more flextime to spend with their families.
But there’s still the question of fulfillment. A recent study shows that work doesn’t satisfy workers’ deeper needs. "We expect more and more out of our jobs," says Hunnicutt. "We expect to find wonderful people and experience all around us."

The author ply believes that ______.

A.work is not all that people need though it is important.

B.work can offer people fulfillment

C.the economic recession can improve the people’s quality of life

D.the flextime can satisfy people’s needs.

单项选择题