题目内容
某汽车维修公司需建立一个汽车维修数据库，该数据库中需要存储和管理下列信息： 车辆信息：车牌号，车型，发动机号，行驶里程，车辆所有人，联系电话 维修项目：项目号，项目名称，维修费 汽车备件：备件号，备件名称，备件单价，库存数量 以上数据之间存在下列约束： 可以对一个车辆进行多个维修项目，每个维修项目可用于多个车辆，维修项目完成后要在数据库中记录维修时间。 一种备件可用于多个维修项目，每个维修项目最多只使用一种备件，但每种备件的数量可以是多个。 假设车辆信息有如下约束： 车牌号：标识属性，取值形式为：第1个字符是“京”，第2个字符为“A”到“Z”的字母，第3～7个字符均是“0”到“9”的数字。此列采用普通编码定长字符型，非空； 车型：普通编码定长字符型，长度为6，默认值为“轿车”： 发动机号：普遍编码定长字符型：长度为6，非空； 行驶里程：整型，取值大于等于0； 车辆所有人：普通编码定长字符型，长度为8，非空； 联系电话：普通编码定长字符型，长度为13，取值唯一。 写出创建满足上述要求的车辆信息表的SQL语句。(注：表名、列名均用题中给出的中文名，SQL语句中的大、小写字母均可。)
查看答案
搜索结果不匹配？点我反馈
更多问题
E-mail Announcement WeeklyUniversity libraries to be closed for a day on FridayAll university libraries will be closed from 8 a.m. to 1 p.m. on Friday (Aug. 10). The closure will allow librarians to complete various tasks to prepare for the coming fall term. Library users are asked to change their study or research plans around this short closure.Bring your old films to Home Movie DayFind your old home movies and bring them to Home Movie Day from 1～5 p.m. Saturday (Aug. 11). The free event at WILL’s Campbell Hall, 300 N. Goodwin, includes a clinic on caring for old films and continuous showing of movies brought in by students like you. Sponsors(主办者) are WILL and the U of C Library.Ireland garden tour set for June 2012The public is invited to join Illinois Master Gardeners on a trip to visit popular public gardens and castles in Ireland. The tour (June 2～12, 2012) also includes several personal gardens as well as free time to find more. Bookings due Sept. 15. For trip introduction and booking information, please visit http://www, travels.uiui.edu/mg/. What can people do at Campbell Hall().
Do you often feel the quality of the goods we buy these days isn’t as good as it ought to beIn the past, when things were made by hand, it seems there was a lot of pride in individual workmanship. People were really proud of things they made.But now, of course, individuals don’t make things. Most things are made on assembly lines and one person only has a very small part in putting something together so there isn’t any workmanship any more.A good example of this is a friend of mine, Mary. She bought a toaster last summer at a sale. She used it, I guess, pretty often, but she only had it a couple of months when suddenly the plastic base of the toaster cracked wide open, and at the same time the heating system in the toaster burned out.She took it back to the store, but the clerk in the store said they wouldn’t take it back, and they wouldn’t give her money back, because she bought it on sale. So the only thing she could do was to buy a new one.I’m sure Mary is more careful when she buys things now, and that’s what we all have to be. In the fifth paragraph the underlined phrase "on sale" probably means ().
E-mail Announcement WeeklyUniversity libraries to be closed for a day on FridayAll university libraries will be closed from 8 a.m. to 1 p.m. on Friday (Aug. 10). The closure will allow librarians to complete various tasks to prepare for the coming fall term. Library users are asked to change their study or research plans around this short closure.Bring your old films to Home Movie DayFind your old home movies and bring them to Home Movie Day from 1～5 p.m. Saturday (Aug. 11). The free event at WILL’s Campbell Hall, 300 N. Goodwin, includes a clinic on caring for old films and continuous showing of movies brought in by students like you. Sponsors(主办者) are WILL and the U of C Library.Ireland garden tour set for June 2012The public is invited to join Illinois Master Gardeners on a trip to visit popular public gardens and castles in Ireland. The tour (June 2～12, 2012) also includes several personal gardens as well as free time to find more. Bookings due Sept. 15. For trip introduction and booking information, please visit http://www, travels.uiui.edu/mg/. What do people do on Home Movie Day().
E-mail Announcement WeeklyUniversity libraries to be closed for a day on FridayAll university libraries will be closed from 8 a.m. to 1 p.m. on Friday (Aug. 10). The closure will allow librarians to complete various tasks to prepare for the coming fall term. Library users are asked to change their study or research plans around this short closure.Bring your old films to Home Movie DayFind your old home movies and bring them to Home Movie Day from 1～5 p.m. Saturday (Aug. 11). The free event at WILL’s Campbell Hall, 300 N. Goodwin, includes a clinic on caring for old films and continuous showing of movies brought in by students like you. Sponsors(主办者) are WILL and the U of C Library.Ireland garden tour set for June 2012The public is invited to join Illinois Master Gardeners on a trip to visit popular public gardens and castles in Ireland. The tour (June 2～12, 2012) also includes several personal gardens as well as free time to find more. Bookings due Sept. 15. For trip introduction and booking information, please visit http://www, travels.uiui.edu/mg/. People need to book the Ireland trip ().
微信支付 
支付宝支付