Writing SQL Help

[artursam]

STUDENT TABLE
NAME DATA TYPE DESCRIPTION
IDNO CHARACTER ID Code "Primary Key"
COURSE CHARACTER Course
DEPART CHARACTER Department
LNAME CHARACTER Last Name
FNAME CHARACTER First Name
MNAME CHARACTER Middle Name
STREET CHARACTER Street
CITY CHARACTER City
COUNTY CHARACTER County
MOBHONE CHARACTER Mobile Phone Number
WPHONE CHARACTER Work Phone Number
EMAIL CHARACTER Email Address
GENDER CHARACTER Gender
STATS CHARACTER Stats
BIRTH DATE Date Of Birth
WEIGHT CHARACTER Weight




STAFF TABLE
NAME DATA TYPE DESCRIPTION
IDNO CHARACTER Staff Code "Primary Key"
LNAME CHARACTER Last name
FNAME CHARACTER First name
MNAME CHARACTER Middle Name
MOBPHONE CHARACTER Mobile Phone
WPHONE CHARACTER Work Phone
EMAIL CHARACTER Email Address
ADDRESS CHARACTER Home Address
FACULTY CHARACTER Faculty


















PROGRAM TABLE
NAME DATA TYPE DESCRIPTION
REFNBR CHARACTER Ref Number("Primary Key")
CODE CHARACTER Module Code
DESC CHARACTER Module Description
UNITS CHARACTER Units
DAYS1 CHARACTER Days e.g M-W-F
STIME CHARACTER Start Time
ETIME CHARACTER End Time
ROOMNBR CHARACTER Room Number
TYPE CHARACTER Type
CPCTY NUMBER Capacity of Class Room
YEAR1 CHARACTER Year
YEAR2 CHARACTER Year
SEM CHARACTER Semester
SNAME CHARACTER Program Name
DIRECTOR CHARACTER Director Name
PGCODE CHARACTER Program Code



MODULE TABLE
NAME DATA TYPE DESCRIPTION
CODE CHARACTER Module Code "Primary Key"
DESC CHARACTER Description
UNITS CHARACTER Units
LEVEL CHARACTER Level
SEM CHARACTER Semester
TYPE CHARACTER Type
SUPERVISOR CHARACTER Supervisor



INVENTORY TABLE
NAME DATA TYPE DESCRIPTION
CODE CHARACTER Module Code "Primary Key"
DESC CHARACTER Description
UNITS CHARACTER Units
LEVEL CHARACTER Level
SEM CHARACTER Semester
TYPE CHARACTER Type
SUPERVISOR CHARACTER Supervisor










STUDENT REGISTER/SCHEDULE TABLE
NAME DATA TYPE DESCRIPTION
IDNO CHARACTER Student IDCode"Primary Key"
CODE CHARACTER Module Code
DESC CHARACTER Module Description
UNITS CHARACTER Units
DAYS1 CHARACTER Days e.g M-W-F
STIME CHARACTER Start Time
ETIME CHARACTER End Time
ROOMNBR CHARACTER Room Number
TYPE CHARACTER Type
CPCTY NUMBER Capacity of Class Room
REFNBR CHARACTER Reference Number for Program
YEAR1 CHARACTER Year
YEAR2 CHARACTER Year
SEM CHARACTER Semester
SNAME CHARACTER Program Name
DIRECTOR CHARACTER Director Name
PGCODE CHARACTER Program Code





USER TABLE
NAME DATA TYPE DESCRIPTION
USERNAME CHARACTER Username "Primary Key"
PASSWORD CHARACTER Password
LEVEL CHARACTER Level of Access
FNAME CHARACTER First name
LNAME CHARACTER Last name
TITLE CHARACTER Title



CLASS ROOM TABLE
NAME DATA TYPE DESCRIPTION
ROOMID CHARACTER Room Code "Primary Key"
Desc CHARACTER Description
Note CHARACTER Remarks