--Code by #TASS
--Q1-
USE master
GO 
DROP DATABASE Q1_SUM_Trial_19
GO

CREATE DATABASE Q1_SUM_Trial_19
GO 
USE Q1_SUM_Trial_19
GO 
--=================== CREATE TABLE Teachers =======================
CREATE TABLE Teachers
    (
      TeacherID INT PRIMARY KEY ,
      Name NVARCHAR(50) ,
      Address NVARCHAR(200) ,
      Gender CHAR(1)
    )
GO 

--=================== CREATE TABLE Classes =======================
CREATE TABLE Classes
    (
      ClassID INT PRIMARY KEY ,
      GroupID CHAR(6) ,
      courseID CHAR(6) ,
      NoCredits INT ,
      Semester CHAR(10) ,
      year INT ,
      TeacherID INT FOREIGN KEY REFERENCES dbo.Teachers ( TeacherID )
    )
GO 
--=================== CREATE TABLE Students =======================

CREATE TABLE Students
    (
      StudentID INT PRIMARY KEY ,
      Name NVARCHAR(50) ,
      Address NVARCHAR(200) ,
      Gender CHAR(1)
    )
GO 

--=================== CREATE TABLE Attend =======================
CREATE TABLE Attend
    (
      Date DATE ,
      Slot INT ,
      StudentID INT FOREIGN KEY REFERENCES dbo.Students ( StudentID ) ,
      ClassID INT FOREIGN KEY REFERENCES dbo.Classes ( ClassID ) ,
      Attend BIT ,
      PRIMARY KEY ( Date, Slot, StudentID, ClassID )
    )
GO