DATABASE DESIGN
TABLE DESIGN:
Table: Administrator Login (Librarian)
SL NO | FIELD | DATATYPE | DESCRIPTION |
1 | User_ID | Varchar(20) | User ID |
2 | Password | Varchar(20) | Password |
Table: Student Login
SL NO | FIELD | DATATYPE | DESCRIPTION |
1 | User_ID | Varchar(20) | User ID |
2 | Password | Varchar(20) | Password |
Table: Staff Login
SL NO | FIELD | DATATYPE | DESCRIPTION |
1 | User_ID | Varchar(20) | User ID |
2 | Password | Varchar(20) | Password |
Table: College Configuration
SL NO | FIELD | DATATYPE | DESCRIPTION |
1 | C_Code | Varchar(20) | Code Of College |
2 | C_Name | Varchar(30) | Name Of College |
3 | Reg_No | Varchar(20) | Reg No Of College |
5 | Address | Varchar(30) | Address Of College |
6 | Cont_No | varchar(30) | Contact Number |
7 | E_ID | Varchar(20) | E-ID Of College |
8 | web_site | Varchar(20) | WebSite of College |
9 | Ac_Year | varchar(30) | Academic Year |
Table: Student Members
SL NO | FIELD | DATATYPE | Constraints | DESCRIPTION |
1 | Std_ID | Int | Primary Key | Student ID |
2 | Std_Name | Varchar(20) | Notnull | Name Of Student |
3 | Class | Varchar(20) | Notnull | Class Of Student |
5 | Year | DateTime | Notnull | Academic Year |
6 | Ph_No | Varchar(20) | Notnull | Phone No |
7 | E_Id | Varchar(20) | Notnull | Email Of Student |
8 | L_ Address | Varchar(30) | Notnull | Local Address |
9 | P_Address | Varchar(30) | Notnull | Permanent Address |
Table: Staff Members
SL NO | FIELD | DATATYPE | Constraints | DESCRIPTION |
1 | Staff_ID | Int | Primary Key | Staff ID |
2 | Staf_Name | Varchar(20) | Notnull | Name Of Staff |
3 | Designation | Varchar(20) | Notnull | Designation Of Staff |
5 | Year | DateTime | Notnull | Academic Year |
6 | Ph_No | Varchar(20) | Notnull | Phone No |
7 | E-Id | Varchar(20) | Notnull | Email Of Staff |
8 | L_ Address | Varchar(30) | Notnull | Local Address |
9 | P_Address | Varchar(30) | Notnull | Permanent Address |
Table: Books table
SL NO | FIELD | DATATYPE | Constraints | DESCRIPTION |
1 | Acc_No | Int | Primary Key | Accession_no of books |
2 | Title | Varchar(20) | Notnull | Name of book |
3 | Author | Varchar(20) | Notnull | Author of Book |
5 | Publisher | Varchar(20) | Notnull | Publisher Of Book |
6 | Cost | Int | Notnull | Cost Of Book |
7 | Book Code | Varchar(20) | Notnull | Code Of Book |
8 | Copies | Int | Notnull | Total No Of Copies |
9 | Supplier | Varchar(30) | Notnull | Supplier of Books |
10 | Category | Varchar(30) | Notnull | Type Of Book |
11 | DOE | DateTime | Notnull | Date Of Entry |
12 | YOP | Varchar(20) | Notnull | YearOf Publication |
Table: Magazine Table
SL NO | FIELD | DATATYPE | Constraints | DESCRIPTION |
1 | Acc_No | Int | Primary Key | Accession_no of Magazine |
2 | Title | Varchar(20) | Notnull | Title of Magazine |
3 | Author | Varchar(20) | Notnull | Author of Magazine |
5 | Publisher | Varchar(20) | Notnull | Publisher Of Magazine |
6 | Cost | Int | Notnull | Cost Of Magazine |
7 | Book Code | Varchar(20) | Notnull | Code Of Magazine |
8 | Copies | Int | Notnull | Total No Of Copies |
9 | Supplier | Varchar(30) | Notnull | Supplier of Magazine |
10 | Category | Varchar(30) | Notnull | Type Of Magazine |
11 | DOE | DateTime | Notnull | Date Of Entry |
12 | YOP | Varchar(20) | Notnull | YearOf Publication |
Table: Table: Book Transcation ā Issued Books Table
SL NO | FIELD | DATATYPE | Constraints | DESCRIPTION |
1 | Member_ID | Int | Notnull | ID of Student |
2 | Acc_No | Int | Foreign key | Accession No Of Books |
3 | D_From | DateTime | Notnull | Issued Date |
4 | D_To | DateTime | Notnull | Issued Till |
Table: Book Transcation ā Returned Books Table
SL NO | FIELD | DATATYPE | Constraints | DESCRIPTION |
1 | Member_ID | Int | Notnull | ID of Student |
3 | Acc_No | Int | Notnull | Accession No Of Books |
3 | No_Exceed | DateTime | Notnull | Number of Exceeded Date |
4 | Fine | Int | Notnull | Fine |
Tabel: Stock Tabel
SL NO | FIELD | DATATYPE | Constraints | DESCRIPTION |
1 | Acc_No | Int | Primary Key | Accession no of books |
2 | Title | Varchar(20) | Notnull | Name of book |
3 | Author | Varchar(20) | Notnull | Author of Book |
5 | Publisher | Varchar(20) | Notnull | Publisher Of Book |
6 | Cost | Int | Notnull | Cost Of Book |
7 | Book Code | Varchar(20) | Notnull | Code Of Book |
8 | Copies | Int | Notnull | Total No Of Copies |
9 | Supplier | Varchar(30) | Notnull | Supplier of Books |
10 | Category | Varchar(30) | Notnull | Type Of Book |
11 | DOE | DateTime | Notnull | Date Of Entry |
12 | YOP | Varchar(20) | Notnull | YearOf Publication |
Leave a reply