Scribd
Upload
18 views3 pages

EXP 1 (Schema)

The document describes the schema of several tables in a MySQL database for a library management system. It includes tables for books (BOOK), authors (AUTHOR), the book-author mapping (BOOK_AUTHOR), publishers (PUBLISHER), members (MEMBERS), book issues (BOOK_ISSUE), book returns (BOOK_RETURN), languages (LANGUAGES), and late fee rules (LATE_FEE_RULE). Each table description shows the fields, their data types, whether they can be null, what keys they are part of, and any other details.

Uploaded by

Chitra Merin Varghese
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
18 views3 pages

EXP 1 (Schema)

The document describes the schema of several tables in a MySQL database for a library management system. It includes tables for books (BOOK), authors (AUTHOR), the book-author mapping (BOOK_AUTHOR), publishers (PUBLISHER), members (MEMBERS), book issues (BOOK_ISSUE), book returns (BOOK_RETURN), languages (LANGUAGES), and late fee rules (LATE_FEE_RULE). Each table description shows the fields, their data types, whether they can be null, what keys they are part of, and any other details.

Uploaded by

Chitra Merin Varghese
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

mysql> DESC BOOK;

+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| BOOK_ID | varchar(20) | NO | PRI | NULL | |
| TITLE | varchar(20) | YES | | NULL | |
| LANGUAGE_ID | varchar(20) | YES | MUL | NULL | |
| MRP | int | YES | | NULL | |
| PUBLISHER_ID | varchar(20) | YES | MUL | NULL | |
| PUBLISHED_DATE | date | YES | | NULL | |
| VOLUME | varchar(5) | YES | | NULL | |
| BOOK_STATUS | varchar(20) | YES | | NULL | |
+----------------+-------------+------+-----+---------+-------+

mysql> DESC AUTHOR;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| AUTHOR_ID | varchar(20) | NO | PRI | NULL | |
| AUTHOR_NAME | varchar(20) | YES | | NULL | |
| EMAIL_ID | varchar(20) | YES | | NULL | |
| PH_NO | varchar(20) | YES | | NULL | |
| AUTHOR_STATUS | varchar(20) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> DESC BOOK_AUTHOR;


+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| BOOK_ID | varchar(20) | NO | PRI | NULL | |
| AUTHOR_ID | varchar(20) | NO | PRI | NULL | |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> desc PUBLISHER;


+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| PUBLISHER_ID | varchar(20) | NO | PRI | NULL | |
| PUBLISHER_NAME | varchar(20) | YES | | NULL | |
| ADDRESS | varchar(20) | YES | | NULL | |
+----------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> desc MEMBERS;


+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| MEM_ID | varchar(20) | NO | PRI | NULL | |
| MEM_NAME | varchar(20) | YES | | NULL | |
| BRANCH_CODE | varchar(20) | YES | | NULL | |
| RNO | int | YES | | NULL | |
| PHNO | varchar(20) | YES | | NULL | |
| EMAIL_ID | varchar(30) | YES | | NULL | |
| DO_JOIN | date | YES | | NULL | |
| MEM_STAT | varchar(10) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

mysql> DESC BOOK_ISSUE;


+------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| ISSUE_ID | varchar(20) | NO | PRI | NULL | |
| DO_ISSUE | date | YES | | NULL | |
| BOOK_ID | varchar(20) | YES | MUL | NULL | |
| MEMBER_ID | varchar(20) | YES | MUL | NULL | |
| EXPCTD_DO_RETURN | date | YES | | NULL | |
| ISSUE_STATE | varchar(20) | YES | | NULL | |
+------------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> DESC BOOK_RETURN;


+------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| ISSUE_ID | varchar(20) | NO | PRI | NULL | |
| ACTUAL_DO_RETURN | date | YES | | NULL | |
| LATE_DAYS | int | YES | | NULL | |
| LATE_FINE | int | YES | | NULL | |
+------------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> desc LANGUAGES;


+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| Language_ID | varchar(20) | NO | PRI | NULL | |
| Language_name | varchar(20) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> DESC LATE_FEE_RULE;


+----------+-------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------+------+-----+---------+-------+
| FromDays | int | NO | PRI | NULL | |
| ToDays | int | NO | PRI | NULL | |
| Amount | float | NO | PRI | NULL | |
+----------+-------+------+-----+---------+-------+
3 rows in set (0.01 sec)

You might also like