USE [Test2]/**your db name**/
GO
/****** Object:  Table [dbo].[class_activities]    Script Date: 1/20/2021 1:52:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[class_activities](
    [activity_id] [NCHAR](10) NULL,
    [activity_name] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[scores]    Script Date: 1/20/2021 1:52:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[scores](
    [activity_id] [NCHAR](10) NULL,
    [student_id] [NCHAR](10) NULL,
    [activity_score] [INT] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[users]    Script Date: 1/20/2021 1:52:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users](
    [user_id] [NCHAR](10) NULL,
    [username] [NCHAR](10) NULL,
    [password] [NCHAR](10) NULL,
    [user_type] [NCHAR](10) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'1         ', N'Oral Spanish')
GO
INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'2         ', N'Oral English')
GO
INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'3         ', N'Written Espanyol')
GO
INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'4         ', N'Integral Exercise')
GO
INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'5         ', N'Oral French')
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'1         ', N'3         ', 28)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'2         ', N'3         ', 28)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'2         ', N'2         ', 30)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'3         ', N'3         ', 40)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'4         ', N'3         ', 40)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'4         ', N'2         ', 28)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'5         ', N'2         ', 28)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'5         ', N'3         ', 20)
GO
INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'5         ', N'4         ', 25)
GO
INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'1         ', N'villavon  ', N'12345     ', N'Teacher   ')
GO
INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'2         ', N'warlow    ', N'undercover', N'Student   ')
GO
INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'3         ', N'bbdantsy  ', N'killer69  ', N'Student   ')
GO
INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'4         ', N'king56    ', N'55tuna55  ', N'Student   ')
GO
INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'5         ', N'spiderman ', N'xxtenasyon', N'Student   ')
GO