当前位置:考试网  > 试卷库  > 学历类  > 自考  > 自考专业(电子商务)  > 互联网数据库  >  某酒店有多间客房,顾客可以入住到酒店。其关系模式如下: 客房(房间编号,房间类型,价格); 顾客(顾客编号,顾客姓名,年龄,电话); 入住(房间编号,顾客编号,入住日期,入住天数)。 根据以上关系用SQL语句完成36~39题。 36.查询每次入住天数大于5天的顾客姓名和电话。 37.向顾客表插入一条新纪录:顾客编号为20180359,姓名为刘平,电话为15598745631。 38.查询没有被使用过的房间编号(要求必须用子查询,否则不得分)。 39.建立视图V_VIEW:2017年12月1日后入住的所有顾客的姓名、房间类型、入住天数。
试题预览

某酒店有多间客房,顾客可以入住到酒店。其关系模式如下:

客房(房间编号,房间类型,价格);

顾客(顾客编号,顾客姓名,年龄,电话);

入住(房间编号,顾客编号,入住日期,入住天数)。

根据以上关系用SQL语句完成36~39题。

36.查询每次入住天数大于5天的顾客姓名和电话。

37.向顾客表插入一条新纪录:顾客编号为20180359,姓名为刘平,电话为15598745631。

38.查询没有被使用过的房间编号(要求必须用子查询,否则不得分)。

39.建立视图V_VIEW:2017年12月1日后入住的所有顾客的姓名、房间类型、入住天数。

查看答案
收藏
纠错
正确答案:

1

答案解析:

暂无解析

你可能感兴趣的试题

关于数据库系统的特点,下列说法中错误的是()

由并发操作引起的数据不一致性包括丢失修改、不能重复读和_____。

已知某个研究所中有多个科室,每个科室有多个职员,每个职员只在一个科室中,每个职员参加多种项目的研发,而每种项目的研发可由多个职员参加。

科室:科室编号,科室名;

职员:工号,职员名,出生日期;

项目:项目号,项目名称,开始日期。

每个职员参加某个项目,都有参加该项目的时间。

请根据上述语义完成以下操作:

(1)建立一个反映上述局部应用的ER模型,要求标注联系类型(可省略实体属性)。

(2)将ER模型转换为关系模型,要求标注每个关系模型的主键和外键(如果存在)。

数据库系统的三级模式结构和两级映象功能,使得数据库系统具有较高的()

下列不属于数据仓库特征的是()

热门试题 更多>
试题分类: 社区工作人员
练习次数:0次
试题分类: 资料员
练习次数:0次
试题分类: 社区工作人员
练习次数:0次
试题分类: 资料员
练习次数:1次
Part II Vocabulary and Structure Directions: In this part there are forty incomplete sentences. Each sentence is followed by four choices. Choose the one that best completes the sentence and then mark your answer on the Answer Sheet. 21. The teacher the students on a tour through the art museum. A. made B. indicated C. forced D. took 22. Tom’s parents died when he was a child, so he was by his relatives. A. grown up B. brought up C. raised D. fed up 23. Here is my card. Let’s keep in . A. touch B. relation C. connection D. friendship 24. So far there is no proof people from other planets do exist. A. which B. how C. what D. that 25. The newspapers reported yesterday several on the boundaries of these two countries. A. incidents B. happenings C. events D. accidents 26. We’ve worked out the plan and now we must put it into . A. fact B. reality C. practice D. deed 27. He didn’t and so he failed the examination. A. work enough hard B. hard work enough C. hard enough work D. work hard enough 28. Not until Mr. Smith came to China what kind of country she is. A. he knew B. he didn’t know C. did he know D. he couldn’t know 29. Scientists say it may be ten years this medicine was put to use. A. since B. before C. after D. when 30. In some countries, is called “equality” does not really mean equal rights for all people. A. that B. what C. which D. how 31. We didn’t know his telephone number, otherwise we him. A. would telephone B. would have telephone C. had telephoned D. must have telephoned 32. We’ve missed the last bus, I’m afraid we have no but to take a taxi. A. way B. possibility C. choice D. selection 33. Luckily, most sheep the flood last month. A. endured B. survived C. lived D. passed 34. My parents always let me have my own of living. A. way B. method C. manner D. fashion 35. Like other language skills, reading requires practice. A. the most of B. much of the C. most of the D. more of the 36. It is only through practice one will be able to swim skillfully. A. what B. who C. that D. which 37. The brain is capable of ignoring pain message of to concentrate on other activities. A. it allowed B. is it allowed C. allowed D. allowed it 38. Don’t worry, I have already them the decision. A. informed; with B. informed; of C. informed; for D. informed; that 39. The child was sorry his mother when he arrived at the station. A. to miss B. having missed C. missing D. to have missed 40. I wonder why he to discuss the problem at the meeting. A. declined B. rejected C. refused D. delayed 41. You can hang up what you like on these walls. A. bare B. empty C. blank D. vacant 42. According to a , the majority would rather have newspapers without a government than a government without newspapers. A. election B. campaign C. poll D. vote 43. The population of the village has decreased 150 to 500. A. in B. at C. by D. with 44. It seems that there is that I can’t do. A. nothing B. anything C. everything D. none 45. They are often caring more about animals than human beings. A. accused if B. accused with C. charged of D. charged for 46. a good beginning is made, the word is half done. A. As soon as B. While C. As D. Once 47. George could not his foolish mistake. A. account in B. count on C. count for D. account for 48. We came into this field late, so we must work hard to the lost time. A. make up for B. make out C. keep up with D. put up with 49. The new law will came into on the day it is passed. A. effect B. use C. service D. existence 50. We can separate the mixture into the pure chemical compounds it is composed. A. in which B. of what C. of which D. from which 51. Mrs. Lincoln has that she is unable to get a job. A. such small education B. so little education C. a such little education D. a so small education 52. She can’t prevent her little boy shooting birds. A. from; to B. on; at C. with; up D. from; at 53. Many countries are increasing their use of natural gas, wind and other forms of . A. energy B. source C. power D. material 54. A darkened sky in the daytime is usually and indication that a storm is . A. possible coming B. about to take place C. close by D. expected to be severe 55. We all know that speak louder than words. A. movements B. performance C. operations D. actions 56. , he could not cover the whole distance in fifteen minutes. A. Fast as he can B. As he can ran fast C. If he can ran fast D. Since he ran fast 57. Agricultural production in that country has increased in recent years. A. vastly B. strikingly C. considerably D. extremely 58. Peter has planned to some money every month so that he can buy a used car next year. A. set aside B. set up C. set in D. set along 59. Although I spoke to him many times, he never took any of what I said. A. attention B. notice C. warning D. observation 60. They overcame all the difficulties and fulfilled the plan three months ahead of time, is something we had not expected. A. that B. what C. it D. which
试题分类: 大学英语六级
练习次数:0次
扫一扫,手机做题