LAB7 hoàn thành

create database BookLibrary
go
use BookLibrary
go
--Làm một Table book nhập giá trị mặc định là 1 cho cột Edition
create table book

(
BookCode int ,
BookTitle varchar(40),
Author varchar(40),
BookPrice money,
Copies int,
constraint ck_bookprice check (BookPrice>10 and BookPrice<100)

)
go
select* from book
go
alter table book
add Edition int default (1)
go
select * from book
go
--Create Members Table
create table Members
(
MemberCode int,
Name varchar(40),
[Address] varchar(40),
PhoneNumber int,
constraint pk_membercode primary key (MemberCode)
)
go
select *from Members
go
--Create IssueDetails table
create table IssueDetails
(
Bookcode int,
MemberCode int,
IssueDate datetime,
ReturnDate datetime,
constraint fk_MemberCode foreign key (MemberCode) references Members(MemberCode)
)
go
select *from IssueDetails
go
--Remove BookPrice
alter table book
drop constraint ck_bookprice
go
--Remove FOREIGN KEY contraint
alter table IssueDetails
drop constraint fk_MemberCode
go
--Drop table BOOK and Members
drop table book
go
drop table Members
go





[quote]

Bài chỉ mang tính chất tham khảo !