drop database Reservation
go
Create database Reservation
go
USE Reservation
GO
BEGIN
CREATE TABLE [dbo].[T_Classe](
	PRIMARY KEY([Cla_No]),
	[Cla_No] [int] IDENTITY(1,1) NOT NULL,
	[Cla_Nom] [nvarchar](20) NULL,
	[Cla_Capacite] [int] NULL,
)
END
GO
BEGIN
CREATE TABLE [dbo].[T_Reservations](
	PRIMARY KEY([Res_No],[Cla_No]),
	[Res_No] [int] IDENTITY(1,1) NOT NULL,
	[Res_Date] [datetime] NOT NULL,
	[Res_Client] [nvarchar](25) NOT NULL,
	[Res_AmPm] [bit] NOT NULL,
	[Cla_No] [int] NOT NULL,
)
END
GO
ALTER TABLE [dbo].[T_Reservations]  WITH CHECK ADD  CONSTRAINT [FK_T_Reservations_T_Classe] FOREIGN KEY([Cla_No])
REFERENCES [dbo].[T_Classe] ([Cla_No])
GO
ALTER TABLE [dbo].[T_Reservations] CHECK CONSTRAINT [FK_T_Reservations_T_Classe]