USE [master]
GO
/****** Object:  Database [PowerBI]    Script Date: 2019/10/27 下午 10:15:34 ******/
CREATE DATABASE [PowerBI]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'PowerBI', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\PowerBI.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'PowerBI_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\PowerBI_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [PowerBI] SET COMPATIBILITY_LEVEL = 120
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [PowerBI].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [PowerBI] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [PowerBI] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [PowerBI] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [PowerBI] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [PowerBI] SET ARITHABORT OFF 
GO
ALTER DATABASE [PowerBI] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [PowerBI] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [PowerBI] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [PowerBI] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [PowerBI] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [PowerBI] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [PowerBI] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [PowerBI] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [PowerBI] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [PowerBI] SET  DISABLE_BROKER 
GO
ALTER DATABASE [PowerBI] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [PowerBI] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [PowerBI] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [PowerBI] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [PowerBI] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [PowerBI] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [PowerBI] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [PowerBI] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [PowerBI] SET  MULTI_USER 
GO
ALTER DATABASE [PowerBI] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [PowerBI] SET DB_CHAINING OFF 
GO
ALTER DATABASE [PowerBI] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [PowerBI] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
ALTER DATABASE [PowerBI] SET DELAYED_DURABILITY = DISABLED 
GO
USE [PowerBI]
GO
/****** Object:  Table [dbo].[course]    Script Date: 2019/10/27 下午 10:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[course](
	[couno] [char](3) NOT NULL,
	[course] [varchar](20) NULL,
	[credit] [int] NULL,
 CONSTRAINT [course_pkey] PRIMARY KEY CLUSTERED 
(
	[couno] 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].[genderValue]    Script Date: 2019/10/27 下午 10:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[genderValue](
	[gender] [char](1) NOT NULL,
	[value] [nchar](1) NOT NULL,
 CONSTRAINT [PK_genderValue] PRIMARY KEY CLUSTERED 
(
	[gender] 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].[score]    Script Date: 2019/10/27 下午 10:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[score](
	[serno] [int] NOT NULL,
	[stuno] [char](6) NULL,
	[couno] [char](3) NULL,
	[score] [int] NULL,
 CONSTRAINT [score_pkey] PRIMARY KEY CLUSTERED 
(
	[serno] 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].[student]    Script Date: 2019/10/27 下午 10:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[student](
	[stuno] [char](6) NOT NULL,
	[stuname] [varchar](20) NULL,
	[gender] [char](1) NULL,
 CONSTRAINT [student_pkey] PRIMARY KEY CLUSTERED 
(
	[stuno] 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
INSERT [dbo].[course] ([couno], [course], [credit]) VALUES (N'c01', N'國文', 1)
INSERT [dbo].[course] ([couno], [course], [credit]) VALUES (N'c02', N'英語', 2)
INSERT [dbo].[course] ([couno], [course], [credit]) VALUES (N'c03', N'數學', 2)
INSERT [dbo].[course] ([couno], [course], [credit]) VALUES (N'c04', N'社會', 1)
INSERT [dbo].[course] ([couno], [course], [credit]) VALUES (N'c05', N'自然', 1)
INSERT [dbo].[course] ([couno], [course], [credit]) VALUES (N'c06', N'寫作', 1)
INSERT [dbo].[genderValue] ([gender], [value]) VALUES (N'F', N'女')
INSERT [dbo].[genderValue] ([gender], [value]) VALUES (N'M', N'男')
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (1, N'120001', N'c01', 50)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (2, N'120001', N'c02', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (3, N'120001', N'c03', 43)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (4, N'120001', N'c04', 75)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (5, N'120001', N'c05', 60)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (6, N'120001', N'c06', 35)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (7, N'120002', N'c01', 55)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (8, N'120002', N'c02', 53)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (9, N'120002', N'c03', 46)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (10, N'120002', N'c04', 78)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (11, N'120002', N'c05', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (12, N'120002', N'c06', 48)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (13, N'120003', N'c01', 82)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (14, N'120003', N'c02', 85)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (15, N'120003', N'c03', 88)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (16, N'120003', N'c04', 92)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (17, N'120003', N'c05', 90)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (18, N'120003', N'c06', 88)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (19, N'120004', N'c01', 61)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (20, N'120004', N'c02', 70)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (21, N'120004', N'c03', 63)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (22, N'120004', N'c04', 72)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (23, N'120004', N'c05', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (24, N'120004', N'c06', 70)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (25, N'120005', N'c01', 43)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (26, N'120005', N'c02', 46)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (27, N'120005', N'c03', 53)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (28, N'120005', N'c04', 44)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (29, N'120005', N'c05', 32)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (30, N'120005', N'c06', 28)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (31, N'120006', N'c01', 74)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (32, N'120006', N'c02', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (33, N'120006', N'c03', 83)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (34, N'120006', N'c04', 76)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (35, N'120006', N'c05', 65)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (36, N'120006', N'c06', 80)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (37, N'120007', N'c01', 60)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (38, N'120007', N'c02', 78)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (39, N'120007', N'c03', 80)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (40, N'120007', N'c04', 79)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (41, N'120007', N'c05', 69)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (42, N'120007', N'c06', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (43, N'120008', N'c01', 94)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (44, N'120008', N'c02', 96)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (45, N'120008', N'c03', 92)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (46, N'120008', N'c04', 90)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (47, N'120008', N'c05', 98)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (48, N'120008', N'c06', 93)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (49, N'120009', N'c01', 48)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (50, N'120009', N'c02', 83)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (51, N'120009', N'c03', 44)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (52, N'120009', N'c04', 56)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (53, N'120009', N'c05', 75)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (54, N'120009', N'c06', 57)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (55, N'120010', N'c01', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (56, N'120010', N'c02', 81)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (57, N'120010', N'c03', 76)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (58, N'120010', N'c04', 54)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (59, N'120010', N'c05', 76)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (60, N'120010', N'c06', 80)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (61, N'120011', N'c01', 62)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (62, N'120011', N'c02', 88)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (63, N'120011', N'c03', 74)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (64, N'120011', N'c04', 33)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (65, N'120011', N'c05', 62)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (66, N'120011', N'c06', 37)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (67, N'120012', N'c01', 83)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (68, N'120012', N'c02', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (69, N'120012', N'c03', 79)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (70, N'120012', N'c04', 55)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (71, N'120012', N'c05', 65)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (72, N'120012', N'c06', 69)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (73, N'120013', N'c01', 55)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (74, N'120013', N'c02', 81)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (75, N'120013', N'c03', 54)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (76, N'120013', N'c04', 51)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (77, N'120013', N'c05', 42)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (78, N'120013', N'c06', 35)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (79, N'120014', N'c01', 72)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (80, N'120014', N'c02', 63)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (81, N'120014', N'c03', 69)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (82, N'120014', N'c04', 50)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (83, N'120014', N'c05', 48)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (84, N'120014', N'c06', 49)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (85, N'120015', N'c01', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (86, N'120015', N'c02', 71)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (87, N'120015', N'c03', 63)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (88, N'120015', N'c04', 73)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (89, N'120015', N'c05', 85)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (90, N'120015', N'c06', 89)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (91, N'120016', N'c01', 85)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (92, N'120016', N'c02', 84)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (93, N'120016', N'c03', 61)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (94, N'120016', N'c04', 62)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (95, N'120016', N'c05', 89)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (96, N'120016', N'c06', 88)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (97, N'120017', N'c01', 70)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (98, N'120017', N'c02', 57)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (99, N'120017', N'c03', 59)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (100, N'120017', N'c04', 78)
GO
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (101, N'120017', N'c05', 64)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (102, N'120017', N'c06', 59)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (103, N'120018', N'c01', 56)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (104, N'120018', N'c02', 58)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (105, N'120018', N'c03', 50)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (106, N'120018', N'c04', 55)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (107, N'120018', N'c05', 66)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (108, N'120018', N'c06', 69)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (109, N'120019', N'c01', 67)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (110, N'120019', N'c02', 55)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (111, N'120019', N'c03', 65)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (112, N'120019', N'c04', 57)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (113, N'120019', N'c05', 67)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (114, N'120019', N'c06', 58)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (115, N'120020', N'c01', 71)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (116, N'120020', N'c02', 70)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (117, N'120020', N'c03', 56)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (118, N'120020', N'c04', 88)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (119, N'120020', N'c05', 78)
INSERT [dbo].[score] ([serno], [stuno], [couno], [score]) VALUES (120, N'120020', N'c06', 66)
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120001', N'洪翊寧', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120002', N'莊亭郁', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120003', N'陳佑政', N'M')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120004', N'徐子倫', N'M')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120005', N'邱冠傑', N'M')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120006', N'何典運', N'M')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120007', N'劉盈瑩', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120008', N'王潔琳', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120009', N'徐尉容', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120010', N'何盈瑩', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120011', N'黃慈菁', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120012', N'陳宜貞', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120013', N'賴霈勻', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120014', N'沈孟蓁', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120015', N'朱家穎', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120016', N'蕭羚佑', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120017', N'余宛儒', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120018', N'呂艾倫', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120019', N'林德芳', N'F')
INSERT [dbo].[student] ([stuno], [stuname], [gender]) VALUES (N'120020', N'程雅雯', N'F')
ALTER TABLE [dbo].[score]  WITH CHECK ADD  CONSTRAINT [fk01] FOREIGN KEY([stuno])
REFERENCES [dbo].[student] ([stuno])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[score] CHECK CONSTRAINT [fk01]
GO
ALTER TABLE [dbo].[score]  WITH CHECK ADD  CONSTRAINT [fk02] FOREIGN KEY([couno])
REFERENCES [dbo].[course] ([couno])
GO
ALTER TABLE [dbo].[score] CHECK CONSTRAINT [fk02]
GO
ALTER TABLE [dbo].[student]  WITH CHECK ADD  CONSTRAINT [FK_student_genderValue] FOREIGN KEY([gender])
REFERENCES [dbo].[genderValue] ([gender])
GO
ALTER TABLE [dbo].[student] CHECK CONSTRAINT [FK_student_genderValue]
GO
USE [master]
GO
ALTER DATABASE [PowerBI] SET  READ_WRITE 
GO