USE [DVDclub]
GO
/****** Object:  Table [dbo].[ΔΙΣΚΟΣ]    Script Date: 11/12/2014 5:23:16 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ΔΙΣΚΟΣ](
	[Id] [int] NOT NULL,
	[IDΤαινίας] [int] NOT NULL,
	[Τύπος] [varchar](7) NOT NULL,
	[Τιμή] [decimal](9, 2) NOT NULL,
 CONSTRAINT [PK_ΔΙΣΚΟΣ] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ΕΝΟΙΚΙΑΣΗ]    Script Date: 11/12/2014 5:23:16 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ΕΝΟΙΚΙΑΣΗ](
	[IDΠελάτη] [int] NOT NULL,
	[IDΔίσκου] [int] NOT NULL,
	[Από] [date] NOT NULL,
	[Έως] [date] NULL,
 CONSTRAINT [PK_ΕΝΟΙΚΙΑΣΗ] PRIMARY KEY CLUSTERED 
(
	[IDΠελάτη] ASC,
	[IDΔίσκου] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ΠΕΛΑΤΗΣ]    Script Date: 11/12/2014 5:23:16 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ΠΕΛΑΤΗΣ](
	[Id] [int] NOT NULL,
	[Όνομα] [varchar](30) NOT NULL,
	[Τηλέφωνο] [varchar](10) NULL,
 CONSTRAINT [PK_ΠΕΛΑΤΗΣ] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ΡΟΛΟΣ]    Script Date: 11/12/2014 5:23:16 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ΡΟΛΟΣ](
	[Id] [int] NOT NULL,
	[Περιγραφή] [varchar](25) NOT NULL,
 CONSTRAINT [PK_ΡΟΛΟΣ] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ΣΥΝΤΕΛΕΣΤΗΣ]    Script Date: 11/12/2014 5:23:16 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ΣΥΝΤΕΛΕΣΤΗΣ](
	[Id] [int] NOT NULL,
	[Όνομα] [varchar](50) NULL,
 CONSTRAINT [PK_ΣΥΝΤΕΛΕΣΤΗΣ] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Τ_Σ_Ρ]    Script Date: 11/12/2014 5:23:16 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Τ_Σ_Ρ](
	[IDΤαινίας] [int] NOT NULL,
	[IDΣυντελεστή] [int] NOT NULL,
	[IDΡόλου] [int] NOT NULL,
 CONSTRAINT [PK_ΤΣ2] PRIMARY KEY CLUSTERED 
(
	[IDΤαινίας] ASC,
	[IDΣυντελεστή] ASC,
	[IDΡόλου] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ΤΑΙΝΙΑ]    Script Date: 11/12/2014 5:23:16 μμ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ΤΑΙΝΙΑ](
	[Id] [int] NOT NULL,
	[Τίτλος] [varchar](100) NOT NULL,
	[Έτος] [int] NULL,
 CONSTRAINT [PK_ΤΑΙΝΙΑ] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO


ALTER TABLE [dbo].[ΔΙΣΚΟΣ]  WITH CHECK ADD  CONSTRAINT [FK_ΔΙΣΚΟΣ_ΤΑΙΝΙΑ] FOREIGN KEY([IDΤαινίας])
REFERENCES [dbo].[ΤΑΙΝΙΑ] ([Id])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ΔΙΣΚΟΣ] CHECK CONSTRAINT [FK_ΔΙΣΚΟΣ_ΤΑΙΝΙΑ]
GO
ALTER TABLE [dbo].[ΕΝΟΙΚΙΑΣΗ]  WITH CHECK ADD  CONSTRAINT [FK_ΕΝΟΙΚΙΑΣΗ_ΔΙΣΚΟΣ] FOREIGN KEY([IDΔίσκου])
REFERENCES [dbo].[ΔΙΣΚΟΣ] ([Id])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ΕΝΟΙΚΙΑΣΗ] CHECK CONSTRAINT [FK_ΕΝΟΙΚΙΑΣΗ_ΔΙΣΚΟΣ]
GO
ALTER TABLE [dbo].[ΕΝΟΙΚΙΑΣΗ]  WITH CHECK ADD  CONSTRAINT [FK_ΕΝΟΙΚΙΑΣΗ_ΠΕΛΑΤΗΣ] FOREIGN KEY([IDΠελάτη])
REFERENCES [dbo].[ΠΕΛΑΤΗΣ] ([Id])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ΕΝΟΙΚΙΑΣΗ] CHECK CONSTRAINT [FK_ΕΝΟΙΚΙΑΣΗ_ΠΕΛΑΤΗΣ]
GO
ALTER TABLE [dbo].[Τ_Σ_Ρ]  WITH CHECK ADD  CONSTRAINT [FK_Τ_Σ_Ρ_ΡΟΛΟΣ] FOREIGN KEY([IDΤαινίας])
REFERENCES [dbo].[ΡΟΛΟΣ] ([Id])
GO
ALTER TABLE [dbo].[Τ_Σ_Ρ] CHECK CONSTRAINT [FK_Τ_Σ_Ρ_ΡΟΛΟΣ]
GO
ALTER TABLE [dbo].[Τ_Σ_Ρ]  WITH CHECK ADD  CONSTRAINT [FK_Τ_Σ_Ρ_ΣΥΝΤΕΛΕΣΤΗΣ] FOREIGN KEY([IDΣυντελεστή])
REFERENCES [dbo].[ΣΥΝΤΕΛΕΣΤΗΣ] ([Id])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Τ_Σ_Ρ] CHECK CONSTRAINT [FK_Τ_Σ_Ρ_ΣΥΝΤΕΛΕΣΤΗΣ]
GO
ALTER TABLE [dbo].[Τ_Σ_Ρ]  WITH CHECK ADD  CONSTRAINT [FK_Τ_Σ_Ρ_ΤΑΙΝΙΑ] FOREIGN KEY([IDΤαινίας])
REFERENCES [dbo].[ΤΑΙΝΙΑ] ([Id])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Τ_Σ_Ρ] CHECK CONSTRAINT [FK_Τ_Σ_Ρ_ΤΑΙΝΙΑ]
GO

/****** Script for SelectTopNRows command from SSMS  ******/

INSERT [dbo].[ΠΕΛΑΤΗΣ] ([Id], [Όνομα], [Τηλέφωνο]) VALUES (1, N'Perkins', N'246801')
GO
INSERT [dbo].[ΠΕΛΑΤΗΣ] ([Id], [Όνομα], [Τηλέφωνο]) VALUES (2, N'Καντακουζηνός', N'246801')
GO
INSERT [dbo].[ΠΕΛΑΤΗΣ] ([Id], [Όνομα], [Τηλέφωνο]) VALUES (3, N'Παλαιολόγος', N'987654')
GO

INSERT [dbo].[ΡΟΛΟΣ] ([Id], [Περιγραφή]) VALUES (1, N'Σκηνοθέτης')
GO
INSERT [dbo].[ΡΟΛΟΣ] ([Id], [Περιγραφή]) VALUES (2, N'Ηθοποιός')
GO

INSERT [dbo].[ΣΥΝΤΕΛΕΣΤΗΣ] ([Id], [Όνομα]) VALUES (1, N'Alfred Hitchcock')
GO
INSERT [dbo].[ΣΥΝΤΕΛΕΣΤΗΣ] ([Id], [Όνομα]) VALUES (2, N'Grace Kelly')
GO
INSERT [dbo].[ΣΥΝΤΕΛΕΣΤΗΣ] ([Id], [Όνομα]) VALUES (3, N'Anthony Perkins')

INSERT [dbo].[ΤΑΙΝΙΑ] ([Id], [Τίτλος], [Έτος]) VALUES (1, N'Rear Window', 1954)
GO
INSERT [dbo].[ΤΑΙΝΙΑ] ([Id], [Τίτλος], [Έτος]) VALUES (2, N'Psycho', 1960)
GO
INSERT [dbo].[ΤΑΙΝΙΑ] ([Id], [Τίτλος], [Έτος]) VALUES (3, N'Ben-Hur', 1959)
GO


INSERT [dbo].[ΔΙΣΚΟΣ] ([Id], [IDΤαινίας], [Τύπος], [Τιμή]) VALUES (1, 1, N'BLU-RAY', CAST(2.00 AS Decimal(9, 2)))
GO
INSERT [dbo].[ΔΙΣΚΟΣ] ([Id], [IDΤαινίας], [Τύπος], [Τιμή]) VALUES (2, 1, N'DVD ', CAST(3.00 AS Decimal(9, 2)))
GO
INSERT [dbo].[ΔΙΣΚΟΣ] ([Id], [IDΤαινίας], [Τύπος], [Τιμή]) VALUES (3, 2, N'BLU-RAY', CAST(2.00 AS Decimal(9, 2)))
GO

INSERT [dbo].[ΕΝΟΙΚΙΑΣΗ] ([IDΠελάτη], [IDΔίσκου], [Από], [Έως]) VALUES (1, 1, CAST(N'2006-07-10' AS Date), CAST(N'2006-09-10' AS Date))
GO
INSERT [dbo].[ΕΝΟΙΚΙΑΣΗ] ([IDΠελάτη], [IDΔίσκου], [Από], [Έως]) VALUES (1, 2, CAST(N'2006-09-20' AS Date), CAST(N'2006-11-20' AS Date))
GO
INSERT [dbo].[ΕΝΟΙΚΙΑΣΗ] ([IDΠελάτη], [IDΔίσκου], [Από], [Έως]) VALUES (2, 1, CAST(N'2006-09-10' AS Date), NULL)
GO

GO

INSERT [dbo].[Τ_Σ_Ρ] ([IDΤαινίας], [IDΣυντελεστή], [IDΡόλου]) VALUES (1, 1, 1)
GO
INSERT [dbo].[Τ_Σ_Ρ] ([IDΤαινίας], [IDΣυντελεστή], [IDΡόλου]) VALUES (1, 2, 2)
GO
INSERT [dbo].[Τ_Σ_Ρ] ([IDΤαινίας], [IDΣυντελεστή], [IDΡόλου]) VALUES (2, 1, 1)
GO
INSERT [dbo].[Τ_Σ_Ρ] ([IDΤαινίας], [IDΣυντελεστή], [IDΡόλου]) VALUES (2, 3, 2)
GO