汽車站數(shù)據(jù)庫設(shè)計(專業(yè)版)
【正文】 路線表在路線編號字段上建立索引create index take_time_index on line(take_time)。,39。9120439。insert into car_line(carID,lineID) values (39。3小時39。insert into line (line_ID,destination,take_time,start_address,ticket_price) values (39。,39。20100439。南京39。,39。)。039。,39。09120739。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。,39。198339。,39。1949100239。5039。白龍馬39。09120439。)。四、E—R圖如下： 駕駛員表屬于汽車表路線表汽車路線表：字段含義字段名稱字段類型駕駛員編號driverIDChar(20) primary key汽車編號car_ID Char(20) not null姓名name char(20) unique生日birthdayChar(20)性別sexChar(20)工作年限standingChar(20)創(chuàng)建駕駛員表：CREATE TABLE driver( driverID char(20) primary key, car_ID char(20) NOT NULL , name char(20)unique, brithday char(20), sex char(2), standing char(20), foreign key (car_ID) references car(car_ID ))。,39。)。09120739。09120139。,39。039。)。,39。陳娜39。,39。839。1949101139。,39。南京39。20100339。,39。insert into line (line_ID,destination,take_time,start_address,ticket_price) values (39。3小時39。)。insert into car_line(carID,lineID) values (39。9120139。,39。執(zhí)行結(jié)果：，并按年齡降序排列。12345639。,39。9120539。insert into car_line(carID,lineID) values (39。insert into line (line_ID,destination,take_time,start_address,ticket_price) values (39。,39。20100539。南京39。,39。,39。197839。,39。1949100939。1739。,39。劉備39。,39。)。139。insert into car values(39。3839。鴕鳥39。
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1