mysql建图书馆表_SQL数据库建立。图书馆。上图

展开全部

你好的！

答案如下32313133353236313431303231363533e59b9ee7ad9431333431343638:CREATE TABLE publishHouse(

publishHouseNO VARCHAR2(64) PRIMARY KEY,

publishHouseName VARCHAR2(64),

adress VARCHAR2(64),

telNO VARCHAR2(32)

);

CREATE TABLE admins(

adminsNO VARCHAR2(64) PRIMARY KEY,

adminsName VARCHAR2(64),

gender VARCHAR2(64),

age INT,

job VARCHAR2(64)

);

CREATE TABLE book(

bookNO VARCHAR2(64) PRIMARY KEY,

bookName VARCHAR2(64),

price NUMBER(18,2) check(price>0 and price<1000),

locate VARCHAR2(64),

indate DATE,

publishHouseNO VARCHAR2(64) references publishHouse(publishHouseNO) ,

adminNO VARCHAR2(64) references admins(adminsNO)

);

请您核对！

望采纳！