creatdb.sql

来自「ssd7 exercise 1 ,绝对有用~欢迎下载」· SQL 代码 · 共 47 行

CREATE TABLE Publisher
(
	PublisherID	VARCHAR(5)	NOT NULL,
	Name		VARCHAR(20)	NOT NULL,
	Address		VARCHAR(20)	NOT NULL,

	PRIMARY KEY(PublisherID)
);

CREATE TABLE Book
(
	PrimaryAuthor		VARCHAR(20)	NOT NULL,
	Title			VARCHAR(30)	NOT NULL,
	ISBN			VARCHAR(20)	NOT NULL,
	PublisherID		VARCHAR(5)	NOT NULL,
	Edition			SMALLINT	NOT NULL,
	PublicationDate		DATE		NOT NULL,
	Price			DECIMAL(4,2)	NOT NULL,
	BookDescription		VARCHAR(80)	NOT NULL,

	PRIMARY Key(ISBN),
	FOREIGN Key(PublisherID) REFERENCES Publisher(PublisherID)
);

INSERT INTO Publisher
VALUES('13001','Electronics Industry','Beijing');
INSERT INTO Publisher
VALUES('13002','Mochine Press','Beijing');
INSERT INTO Publisher
VALUES('13066','Telecom Press','Beijing');
INSERT INTO Publisher
VALUES('13077','NWPU Press','Xi an');


INSERT INTO Book
VALUES('Thomas Connolly','Database Systems','7-5053-9418-5','13001','3','2005-9-2','79.00','A practical Approach to Design, Implementation, and Management Third Edition');
INSERT INTO Book
VALUES('James F.Kurose','Computer Networking','978-7-111-16505-7','13002','3','2006-5-6','55.00','A Top-Down Approach Featuring the Internet, Third Edition');
INSERT INTO Book
VALUES('Stanley','C++ Primer','978-711-51455-4-3','13066','4','2006-03-01','50.00','C++');
INSERT INTO Book
VALUES('Lippman','Operating Systems','978-711-10915-6-1','13077','2','2002-01-01','48.00','computer operation systems');