寵物醫(yī)院信息管理系統(tǒng)數(shù)據(jù)庫課程設(shè)計-wenkub
2023-01-28 15:16:49 本頁面
【正文】 ,Doctor_ID）CREATE VIEW V3_pat_docASSELECT Patient_ID,Doctor_IDFROM Doctor_Patient4) 建立視圖V4_Drugs（M_ID,M_Name,Quantity,Storage）CREATE VIEW V4_DrugsASSELECT M_ID,M_Name,Quantity,StorageFROM Drugs四、 SQL語言描述 數(shù)據(jù)定義 建表：1) 醫(yī)生Doctor表CREATE TABLE Doctor ( Doctor_ID VARCHAR (10) NOT NULL PRIMARY KEY, Dname VARCHAR(20), Dsex VARCHAR(10), Dage INT, Ddept VARCHAR(50), Dtel VARCHAR(20), )表31列名含義數(shù)據(jù)類型長度容許空Doctor_ID醫(yī)生員工號Varchar10NOT NULLDname醫(yī)生姓名Varchar20Dsex醫(yī)生性別Varchar10Dage醫(yī)生年齡Int4Ddept科室Varchar50Dtel電話Varchar202) 病寵Patient表CREATE TABLE Patient ( Patient_ID VARCHAR (10) NOT NULL PRIMARY KEY, Pname VARCHAR(20), Psex VARCHAR(10), Pspecies VARCHAR(10),Ptel VARCHAR(20),Pinf VARCHAR(50))表32列名含義數(shù)據(jù)類型長度容許空Patient_ID病寵編號Varchar10NOT NULLPname主人姓名Varchar20Psex病寵性別Varchar10Pspecies物種Varchar10Ptel聯(lián)系方式Varchar20Pinf病歷Varchar503) 住院部IPD表CREATE TABLE IPD ( Ipd_ID VARCHAR (10) NOT NULL PRIMARY KEY, Room_No VARCHAR(10), Sickbed_No VARCHAR(10), )表33列名含義數(shù)據(jù)類型長度容許空Ipd_ID住院部代號Varchar10NOT NULLRoom_No病房號Varchar10NOT NULLSickbed_No病床號Varchar10NOT NULL4) 科室Office表CREATE TABLE Office ( Office_No VARCHAR (10) NOT NULL PRIMARY KEY, Oname VARCHAR(10), Oaddress VARCHAR(50), Doctot_ID VARCHAR(10), Otel VARCHAR(10) )表34列名含義數(shù)據(jù)類型長度容許空Office_No科室號Varchar10NOT NULLOname科室名Varchar10Oaddress科室地址Varchar50Doctot_ID醫(yī)生編號Varchar10Otel科室電話Varchar105) 護士Nurse表CREATE T
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1