停車場管理系統(tǒng)數(shù)據(jù)庫設計說明(編輯修改稿)
2025-05-04 23:02 本頁面
【文章內容簡介】 . . .學習參考任務與結果 建立數(shù)據(jù)庫（1） 建立數(shù)據(jù)庫、數(shù)據(jù)表、視圖、索引等create database Parking。. . . . .學習參考：create table Car(Carno char(10) primary key, Carsb char(10), Carcolor char(4))。：create table Ffed(Cwno char(10) primary key, Cwpace char(10) not null, Cwtype char(4) not null, Carno char(10), Carpho bit, Caradd char(20), Cartel char(20), Carmon float check(Carmon=100 and Carmon=200)foreign key (Carno) reference Car(Carno))。：create table Stop(Cwno char(10) not null, Carno char(10) not null, Carat bit not null, Carin datetime, Carout datetime, Timetype char(6), primary key(Cwno,Carno), foreign key(Cwno) references Ffed(Cwno), foreign key(Carno) references Car(Carno))。：create table Moneyt(Timetype char(6) primary key, Montime float not null check(Montime=1 or Montime=2 or Montime=),)。6，總數(shù)據(jù)庫及其調試代碼如下： create table Car(Carno char(10) primary key, Carsb char(10),. . . . .學習參考 Carcolor char(4))。create table Ffed(Cwno char(10) primary key, Cwpace char(10) not null, Cwtype char(4) not null, Carno char(10), Carname char(10), Carpho bit, Caradd char(20), Cartel char(20), Carmon float check(Carmon=100 and Carmon=200))。create table Stop(Cwno char(10) not null, Carno char(10) not null, Carat bit not null, Carin datetime, Carout datetime,
公司管理相關推薦
鄂ICP備17016276號-1