新型停車場(chǎng)智能化管理系統(tǒng)設(shè)計(jì)方案-預(yù)覽頁(yè)
【正文】 e_freedom( free number place ,char(20), primary key,not nullingoing time,char(20),not null)創(chuàng)建自由車位信息表格 vehicle_freedom placecreate table vehicle_freedom place( free number place ,char(20), primary key,not null ingoing time,char(20),not null leave time char(20),not null expenses char(20) )。為固定車主建立視圖create view vehicle_masterasselect name ,age, address, contact way為自由車建立視圖create view vehicle_freedom asselect free number place,ingoing time,from freedom為自由車位建立視圖 create view vehicle_freedom placeasselect free number place,ingoing time, leave time, expensesfrom freedom?！ 」潭ㄜ囓囍餍畔⒈戆葱彰匆舻谝粋€(gè)字母升序建唯一索引Create unique index on vehicle_master（first letter of name）自由車車位表按車牌號(hào)升序建立唯一索引Create unique index on vehicle_freedom place(free number plate)自由車車位表按車牌號(hào)升序建立唯一索引Create unique index on vehicle_freedom (free number plate) 管理員信息按姓名拼音第一個(gè)字母升序建唯一索引Create unique index on administrators（first letter of name） 數(shù)據(jù)查詢查詢?nèi)w固定車輛的車牌號(hào)Select number plate from vehicle_ fixation 查詢?nèi)w固定車輛的顏色Select color from vehicle_ fixation查詢?nèi)w固定車輛的車主姓名Select name of vehicle’master from vehicle_ fixation 查詢?nèi)w固定車輛的車位編號(hào)Select fixed number place from vehicle_ fixation查詢?nèi)w固定車車主的年齡Select age of vehicle’master from vehicle’master查詢?nèi)w固定車車主的聯(lián)系方式Select contract way from vehicle’master查詢?nèi)w固定車車主的地址Select address from vehicle’master查詢?nèi)w固定車位的車位號(hào)Select fixed number place from fixed place查詢?nèi)w固定車位的進(jìn)入時(shí)間Select ingoing time from fixed place查詢?nèi)w固定車位的離開時(shí)間Select leave timeFrom fixed place查詢?nèi)w自由車的車牌號(hào) Select number plateFrom vehicle_freedom 查詢?nèi)w自由車的進(jìn)入時(shí)間Select ingoing timeFrom vehicle_freedom查詢?nèi)w自由車位的車牌號(hào)碼Select number plateFrom vehicle_freedom place查詢?nèi)w自由車位的進(jìn)入時(shí)間Select ingoing timeFrom vehicle_freedom place查詢所有管理員的工作證號(hào)Select employee39。s card numbe, name,age, vehicle place)Values(‘001’, ‘張凱濱’，‘43’，‘1，2，3，4，5’)．2 修改數(shù)據(jù)修改操作又稱為更新操作，其語(yǔ)句一般格式為Update表名Set 列名=表達(dá)式[，列名=表達(dá)式]…[where條件]；修改固定車位車主年齡Update vehicle_ fixationSet age=26Where name of vehicle’master= ‘陳東’；修改固定車車主聯(lián)系方式Update vehicle_fixation masterset contract way= ‘13664302629’where name of vehicle’master= ‘陳東’；修改自由車位車位離開時(shí)間Update vehicle_freedom placeSet leave time= ‘9:56’Where vehicle freedom number place修改自由車車牌號(hào)Update vehicle_freedom Set vehicle_freedom number plate= ‘45’Where vehicle_freedom number place= ‘12’。刪除自由車車牌號(hào)DeleteFrom vehicle_freedom Where vehicle_freedom number place = ‘遼A E825’。是整個(gè)數(shù)據(jù)庫(kù)設(shè)計(jì)的關(guān)鍵。數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)經(jīng)過試運(yùn)行后即可投入正
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1