问题
问答题
在下有“教师档案.mdb”数据库。
(1)将“教师授课表.xls”和“班级.xls” 导入到数据库中,第一行包含列标题,授课ID、班级ID设置为主键,将导入表命名为“教师授课表”和“班级”。
(2)将“教师授课”表中的课程编号为“0011”的所有行删除。“教师授课”表如图所示。
(3)将“教师档案”表到教师“授课”表的设置为一对多,实施参照完整性。
答案
参考答案:[*]
在下有“教师档案.mdb”数据库。
(1)将“教师授课表.xls”和“班级.xls” 导入到数据库中,第一行包含列标题,授课ID、班级ID设置为主键,将导入表命名为“教师授课表”和“班级”。
(2)将“教师授课”表中的课程编号为“0011”的所有行删除。“教师授课”表如图所示。
(3)将“教师档案”表到教师“授课”表的设置为一对多,实施参照完整性。
参考答案:[*]
阅读下面五段文字 ,找出能代表本段主题的最佳选项 。 | |
( ) 1. I've got a collection of terrible "mistakes" at the back of my wardrobe(衣柜) ,which I never wear! But I don't mind going with my girlfriend, because she helps me choose. I think women are better at buying clothes than men.They've got better taste and they always know what's fashion. ( ) 2. You shouldn't be afraid of her. Maybe she's just as shy as you. What about giving her a red rose and a short message? Say somcthing like this: "I'd really like to know you but I don't know how. " She'Il probably bc excited to know she's got a fan! ( ) 3. Jane usually travcls for 2 hours at most and then shc can have a rest of at lcast 3 hours. She meets a lot of interesting people from all over the world. She says she likes it because she doesn't have to work full-timc so she can spend more time with our three children and me. ( ) 4. When Mrs Poor got into the lift. she was carrying only a handbag. After few seconds, the lift stopped bn floors. She shouted and shouted. and rang the alarm (警报). But nobody heard her. ( ) 5. I've known her for four years and l really like her. But she always copies everything I do. lf I buy some new clothes. the next day she'll go out and buy exactly the same ones. It's the same with music. films, even my friends! What should I do?
|