___________, a car knocked him down.A. While crossing the streetC. While the boy was cro

.

S: Excuse me! I am new to the campus. Would you please tell me where I can get a smartphone？

K: Sure! You can go to Mobile Joker Store, which is the nearest mobile phone store from here.

S: Er, sorry, but I don't know how to get there.

K: Don't worry, do you have a map？

S: Yes, here it is.

K: Let's see —Here's where we are right now. To get to Mobile Joker Store, you'll need to cross this square and go to the south.

S: OK. And then…？

K: And then the mobile phone store is about five hundred yards past the gym, on your left. You'll see a sign in front of the shop.

S: No wonder I got lost. I was heading in the wrong direction! Anyway, thank you very much for your help.

K: No problem. Good luck!

再听一听他们的谈话，看看你对他们的谈话了解了多少。

1.What does Susan want to get？()

A.A mobile phone

B.A book

C.An electronic dictionary

2.Susan needs to cross to get to the store ().

A.a school

B.a meeting room

C.a square

3.How many yards is the store away from the gym？()

A.500

B.800

C.600

4.Susan will see a _______ in front of the shop.

A.tree

B.bike

C.sign

5.Susan has got _______ on her to get around.

A.a map

B.an umbrella

C.a car

已知条件列于下表中，计算某重油锅炉的炭黑粒子辐射减弱系数并对计算结果进行分析与讨论。

某燃烧重油的锅炉的已知条件

受热面	α"	θ"(℃)	T"(K)	Car(%)	Har(%)
炉膛、大屏、壁式再热器	1.02	1097	1370	86.82	11.16
后 屏	1.025	1021	1294	86.82	11.16
中温再热器	1.03	893	1166	86.82	11.16
后水引出管	1.04	886	1159	86.82	11.16
高温再热器	1.05	811	1084	86.82	11.16
悬吊管	1.06	734	1007	86.82	11.16
低温过热器垂直段	1.07	700	973	86.82	11.16
辖向室	1.075	656	929	86.82	11.16
低温过热器水平段	1.08	454	727	86.82	11.16
省煤器	1.09	401	674	86.82	11.16
空气预热器	1.1	140	413	86.82	11.16

务部门数据库的部分关系模式如下： 驾驶员：EMP（Eno,Ename, Age, Sex, telephone），各属性分别表示驾驶员工号、姓名、年龄、性别和电话号码； 车辆：CAR（Cno,Brand,Capacity），各属性分别表示汽车车牌号、品牌名和排量； 调度：SCHEDULE（Sno,Eno,Cno,StartTime, Endtime），各属性分别表示调度号、驾驶员工号、汽车车牌号、发车时间和收车时间。 奖金：BONUS（Eno,Year,Month,Amount），各属性分别表示驾驶员工号、年、月和当月的奖金数量。 有关车辆调度的相关说明如下：

公车的行驶时间只能在工作时间内，因此规定调度表中每天安排发车的时间在上午07：00:00至下午18:00:00范围内。（

【问题1】（4分） 请将下面创建调度关系的SQL语句的空缺部分补充完整，要求指定关系的主码、外码，以及调度表中每天安排发车的时间在上午07:00:00至下午18:00:00范围内的约束（由函数 Time Get_time(DATETIME StartTime)返回出车的时间）。 CREATE TABLE SCHEDULE(Sno CHAR(10), Eno CHAR(10) (a) , Cno CHAR(8) (b) , StartTime DATETIME (c) , EndTime DATETIME, PRIMARY KEY (d) )； 【问题2】（6分） （1）创建所有&39;奥迪&39;品牌汽车的调度信息的视图AudiSCHEDULE，属性有Eno、Ename、Cno、Brand、StartTime和EndTime，请将下面SQL语句的空缺部分补充完整。 CREATE (e) AS SELECT EMP,Eno,Ename, CAR,Cno,Brand, StartTime, EndTime FROM EMP,CAR, SCHEDULE WHERE (f) （2）驾驶员的奖金在收车时间写入时，由出车时间段自动计算，并用触发器来实现奖金的自动维护，函数float Bonus_value(DATETIME StartTime, DATETIME EndTime)依据发车时间和收车时间来计算本次出车的奖金。系统在每月初自动增加一条该员工的当月奖金记录，初始金额为零。请将下面SQL语句的空缺部分补充完整。 CREATE (g) Bonus_TRG AFTER (h) ON SCHEDULE REFERENCING new row AS nrow FOR EACH ROW BEGIN UPDATE BONUS SET (i) WHERE (j) AND Year=Get_Year(nrow.StartTime) AND Month= Get_Month(nrow.StartTime) ; END 【问题3】（5分） 请将下面SQL语句的空缺郜分补充完整。 （1）查询调度次数最多的汽车车牌号及其品牌。 SELECT CAR．Cno，Brand FROM CAR, SCHEDULE WHERE CAR.Cno =SCHEDULE.Cno GROUP BY (k) HAVING (l) (SELECT COUNT（*） FROM SCHEDULE CROUP BY Cno); （2）查询所有在调度表中没有安排过“大金龙”品牌车辆的驾驶员工员和姓名。 SELECT Eno，Ename FROM EMP WHERE Eno (m) (SELECT Eno FROM （n） WHERE (o) AND brand= ‘大金龙&39;）；

A.This is your car

B.Your car is this

C.Is this your car

A.is

B.are

C.has

A.This is a car

B.It’s a car

C.That is a car

D.Its a car

A.car comes

B.omes a car

C.oes a car come

D.oes come a car

A．first

B．second

A.CAR—121AA

B.CAR—145R2

C.CAR—39

D.CAR—25