Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE [Movies]
- CREATE TABLE [Directors](
- [Id] INT PRIMARY KEY IDENTITY(1,1),
- [DirectorName] VARCHAR(50),
- [Notes] VARCHAR
- )
- CREATE TABLE [Genres](
- [Id] INT PRIMARY KEY IDENTITY(1,1) ,
- [GenreName] VARCHAR(50),
- [Notes] VARCHAR
- )
- CREATE TABLE [Categories](
- [Id] INT PRIMARY KEY IDENTITY(1,1) ,
- [CategoryName] VARCHAR(50),
- [Notes] VARCHAR
- )
- CREATE TABLE [Movies](
- [Id] INT PRIMARY KEY IDENTITY(1,1),
- [Title] VARCHAR(50),
- [DirectorId] VARCHAR,
- [CopyrightCHAR(4)] CHAR(4),
- [Length] DECIMAL(2,2),
- [GenreId] INT,
- [CategoryId] INT,
- [Rating] INT(10),
- [Notes] VARCHAR,
- )
- INSERT INTO [Directors]([Id],[DirectorName],[Notes])
- VALUES
- (1,'John',NULL),
- (2,'Stan',NULL),
- (3,'George',NULL),
- (4,'Luke',NULL),
- (5,'Peter',NULL)
- INSERT INTO [Genres]([Id],[GenreName],[Notes])
- VALUES
- (1,'Action',NULL),
- (2,'Thriller',NULL),
- (3,'Fanatasy',NULL),
- (4,'Sci-Fi',NULL),
- (5,'Comedy',NULL)
- INSERT INTO [Categories]([Id],[CategoryName],[Notes])
- VALUES
- (1,'Film',NULL),
- (2,'TV Series',NULL),
- (3,'Documentary',NULL),
- (4,'Limited TV Series',NULL),
- (5,'TV Show',NULL)
- INSERT INTO [Movies]([Id],[Title],[DirectorId],[CopyrightCHAR(4)], [Rating], [Notes])
- VALUES
- (1,'Superhero Adventure', 1, 2022, 6, NULL),
- (2,'Fighting Justice', 2, 2022, 7, NULL),
- (3,'Strange New Planets', 3, 2022, 8, NULL),
- (4,'The Flying Steel Donkey', 4, 2022, 8, NULL),
- (5,'Mr. Smith and his Umbrella', 5, 2022, 8, NULL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement