| Home>CVC>Specification | ||
|
Database Scheme for Virtual Classroom |
||
|
E-R Diagram:
|
||
|
Script:
CREATE TABLE [dbo].[ADMIN] (
[FIRSTNAME] [nvarchar] (50) NOT NULL ,
[LASTNAME] [nvarchar] (50) NOT NULL ,
[PASS] [char] (6) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[COURSE] (
[COURSE] [nvarchar] (20) NOT NULL ,
[COURSE_TIT] [nvarchar] (50) NOT NULL ,
[COURSE_URL] [nvarchar] (100)
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[IS_ENROLLED] (
[SSN] [char] (11) NOT NULL ,
[COURSE][nvarchar] (20) NOT NULL ,
[IS_ONLINE] [char] (1) ,
[IP_ADDR] [char] (16) ,
[DATA] [char] (50)
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[STUDENT] (
[FIRSTNAME] [nvarchar] (50) NOT NULL ,
[LASTNAME] [nvarchar] (50) NOT NULL ,
[PASS] [nvarchar] (6) NOT NULL ,
[SSN] [nvarchar] (11) NOT NULL ,
[Email] [nvarchar] (25)
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TEACHES] (
[SSN] [char] (11) NOT NULL ,
[COURSE] [nvarchar] (20) NOT NULL ,
[IS_ONLINE] [char] (1) ,
[IP_ADDR] [char] (16) ,
[DATAFORMAT] [char] (40) ,
[Port] [char] (10)
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TEA_PAS] ( [SSN] [char] (11) NOT NULL ,
[FIRSTNAME] [nvarchar] (50) NOT NULL ,
[LASTNAME] [nvarchar] (50) NOT NULL , [PASS] [char] (6) NOT NULL
) ON [PRIMARY] GO
|
