b) Identify the domain of various attributes.
Table Name : course
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| c_code | varchar(10) | Primary Key | Uniquely identify each course in this table |
| c_name | varchar(100) | Course name | |
| course_fees | int | Total course fee |
Table Name : faculty
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| f_code | varchar(10) | Primary Key | Uniquely identify each faculty in this table |
| f_name | varchar(100) | Name of the faculty | |
| f_address | varchar(200) | Current address of the faculty | |
| f_phone | bigint | Contact number of the faculty | |
| f_qualification | varchar(100) | Educational qualification/degree of the faculty |
Table Name : student
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| s_code | varchar(10) | Primary Key | Uniquely identify each student in this table |
| s_name | varchar(100) | Name of the student | |
| s_address | varchar(200) | Current address of the student | |
| s_phone | bigint | Contact number of the student |
Table Name : teach
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| s_code | varchar(10) | Foreign Key | Student identification code |
| c_code | varchar(10) | Foreign Key | Course identification code |
| f_code | varchar(10) | Foreign Key | Faculty identification code |
Table Name : test_schedule
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| exam_code | varchar(10) | Primary Key | Uniquely identify each examination in this table |
| week_number | int | Represent week number on which week the examination was done | |
| full_marks | int | Full marks of the examination paper | |
| c_code | varchar(10) | Foreign Key | Course identification code |
Table Name : test_result
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| s_code | varchar(10) | Foreign Key | Student identification code |
| exam_code | varchar(10) | Foreign Key | Examination identification code |
| grade | varchar(2) |
Table Name : classes
| Field Name | Data Type | Constraint | Description |
|---|---|---|---|
| class_code | varchar(10) | Primary Key | Uniquely identify each class in this table |
| duration | int | Class duration | |
| class_type | varchar(15) | Define class type : theory, practical, examination | |
| date_and_time | datetime | Date and time of the class | |
| c_code | varchar(10) | Foreign Key | Course identification code |
| f_code | varchar(10) | Foreign Key | Faculty identification code |
