汽車站數(shù)據(jù)庫(kù)設(shè)計(jì)-全文預(yù)覽
【正文】 nto line (line_ID,destination,take_time,start_address,ticket_price) values (39。南京39。上海39。)。,39。,39。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。139。李鳴39。1949101139。,39。,39。,39。839。198039。09120139。)。,39。,39。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。039。陳娜39。1949100739。,39。,39。,39。1639。197739。09120539。)。,39。,39。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。039。李嬌39。1949100339。,39。,39。,39。639。198139。09120139。)。,39。3639。09120739。,39。insert into car values(39。筋斗云39。)。,39。4239。09120339。,39。insert into car values(39。飛鶴39。.字段含義字段名稱字段類型汽車編號(hào)usernameChar(20)路線編號(hào)password char(20)創(chuàng)建用戶表表：CREATE TABLE user_ID( username varchar(20), password varchar(20), primary key(username,password))。四、E—R圖如下： 駕駛員表屬于汽車表路線表汽車路線表：字段含義字段名稱字段類型駕駛員編號(hào)driverIDChar(20) primary key汽車編號(hào)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 ))。二、 本系統(tǒng)有四張表組成，表結(jié)構(gòu)如下：駕駛員表：（駕駛員編號(hào)，汽車編號(hào)，姓名，生日，性別，工作年限）汽車表：（汽車編號(hào)，型號(hào)，載客量，票價(jià)
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1