28.08.2019
 Data Book Research Conventional paper

Field Name| Data type| Constraint| Allow Null

Student id| Int| Primary key| Not really null

Scholar Name| Varchar(30)| -| Certainly not null

College student city| Varchar(30)| -| Not really null

Student Address| Varchar(50)| -| Not null

Student Contact no| Numeric| -| Not null

Student Gender| Bit| -| Not null

Student Particular date of birth| Date time| -| Not null

College student Email ID| Varchar(40)| -| Not null

Student degree ID| Int| Reference| Certainly not null

Pupil Course Id| Int| Reference| Not null

Student qualification| Varchar(15)| -| Not null

Student Photo| Varchar(max)| -| Not null

Student last result| Varchar(max)| -| Certainly not null

Scholar password | Varchar(40)| -| Not null

Student status| Bit| -| Not null

1 . Scholar Registration:

installment payments on your Faculty Registration:

Field Name| Data type| Constraint| Allow Null

Teachers ID| Int| Primary key| Not null

Faculty username| Varchar(30)| -| Not null

Faculty Password| Varchar(40)| -| Not null

Faculty Subject matter id| Int| Reference| Not null

Faculty gender| Bit| -| Not null

Faculty email| Varchar(40)| -| Certainly not null

Teachers qualification| Varchar(20)| -| Certainly not null

Faculty Experience| Varchar(30)| -| Not really null

Teachers Contact no| Numeric| -| Not null

Faculty photo| Varchar(max)| -| Not null

Faculty status| Bit| -| Not null

3. Admin:

Field Name| Data type| Constraint| Enable Null

Admin_id| Int| Primary-key| Not Null

Admin_username| Varchar(30)| -| Not null

Admin_status| Bit| -| Not null

4. De4. degree:

Discipline Name| Info type| Constraint| Allow Null

Degree id| Int| Primary-key| Not Null

Degree Name| Varchar(30)| -| Not null

Degree status| Bit| -| Not null

5. Course:

Field Name| Data type| Constraint| Allow Null

Study course id| Int| Primary-key| Not really Null

Program Name| Varchar(30)| -| Certainly not null

Course status| Bit| -| Not really null

Course degree id| Int| Reference| Not null

6. Division:

Field Name| Data type| Constraint| Enable Null

Dept id| Int| Primary-key| Not Null

Dept Name| Varchar(30)| -| Certainly not null

Dept status| Bit| -| Not null

Dept course id| Int| Reference| Not null

7. Session:

Field Name| Data type| Constraint| Allow Null

Sem id| Int| Primary-key| Not really Null

Sem name| Varchar(30)| -| Not really null

Search engine optimization status| Bit| -| Not really null

Sem dept id| Int| Reference| Not null

Sem training course id| Int| Reference| Certainly not null

almost 8. Subject:

Field Name| Data type| Constraint| Allow Null

Sub id| Int| Primary-key| Not Null

Sub name| Varchar(30)| -| Not null

Sub status| Bit| -| Not null

Sub search engine marketing id| Int| Reference| Not really null

9. Material:

Field Name| Info type| Constraint| Allow Null

Material id| Int| Primary-key| Not Null

Material name| Varchar(30)| -| Not null

Material status| Bit| -| Not null

Material sub id| Int| Reference| Not really null

Charges:

Field Name| Data type| Constraint| Let Null

Charges id| Int| Primary-key| Not really Null

Fees_amount| Float / money| -| Not null

Fees status| Bit| -| Not null

Fees program id| Int| Reference| Not null

twelve. Question:

Discipline Name| Data type| Constraint| Allow Null

Que id| Int| Primary-key| Not Null

Question| Varchar(max)| -| Not really null

La cual option| Varchar(30)| -| Not null

La cual answer| Varchar(30)| -| Not null

O qual status bit| Bit| -| Not null

Que_sub_category_id| Int| Reference| Not null

eleven. Feedback:

Field Name| Data type| Constraint| Allow Null

Feedback id| Int| Primary-key| Not Null

Feedback | Varchar(max)| -| Not null

Feedback status| Bit| -| Not null

Name(role)| varchar(30)| -| Certainly not null

Contact_no| Numeric(10)| -| Not null

12. Query help table:

Field Name|...