Library-Management-System
https://github.com/Ahmad-Rasheed-01/Library-Management-System.git
This project is basically creating a database management system for the management of physical and online library. Aim of the project is to creating a backend program of the processes taking place using SQL. This model deals with the relationship between the books, borrower and borrowing details. The other entities play a supportive weak role. So basically this helps the librarian to keep a record of books, borrowers along with their details.
Attribute
Data Type
Constraint
employee_id
Int
Primary key
employee_name
Varchar (50)
None
employee_address
Varchar (50)
None
Attribute
Data Type
Constraint
employee_id
int
foreign key
employee_name
Varchar (50)
None
employee_address
Varchar(100)
None
employee_phone
Varchar (50)
None
Attribute
Data type
Constraint
publisher_name
Varchar (100)
Primary key
publisher_address
Varchar (200)
None
publisher_phone
Varchar (50)
None
publisher_email
Varchar (50)
None
Attribute
Data Type
Constraint
author_name
Varchar (50)
Primary key
author_dob
Date
None
author_nationality
Varchar (50)
None
Attribute
Data type
Constraint
book_is
int
None
book_title
Varchar(100)
None
book_price
Varchar (10)
None
book_publish_year
Int
None
book_publisher_name
Varchar (100)
Foreign Key
author_name
Varchar (50)
Foreign Key
Attribute
Data type
Constraint
borrower_id
Int
Primary key
borrower_date
date
None
return_date
date
None
return_status
Varchar (100)
None
Attribute
Data type
Constraint
borrower_id
int
Foreign Key
borrower_name
Varchar (100)
None
borrower_address
Varchar (200)
None
borrower_phone
Varchar (50)
none
Attribute
Data type
Constraint
ebook-title
Varchar (100)
Primary
ebook_price
Varchar (10)
None
Ebook_publisher_name
Varchar(100)
None
Ebook_author_name
Varchar(100)
None
Attribute
Data type
Constraint
ebook_title
Varchar (100)
Foreign Key
ebook_author_name
Varchar (100)
None
ebook_publisher_name
Varchar (100)
None
ebook_publisher_address
Varchar (200)
None
ebook_publisher_phone
Varchar (50)
None
ebook_publisher_email
Varchar(50)
None
employee_id
employee_name
employee_type
1
Viladmir Putin
Manager
2
'David Bombal
Librarian
3
Jack Reacher
Librarian
4
Scarlet Johnson
Library Assistant
5
Chris Evans
Pages
6
Tom Holland
Pages
7
Nancy Finland
Accounting and Finance
8
Clark Kent
Security Services
9
Jack Hammer
Security Services
Employee_id
Employee_name
Employee_address
Employee_phone
1
Viladmir Putin
Karachi, Pakistan
+92-300-345-6538
2 David Bombal
Lahore, Pakistan
+92-344-345-6783
3
Jack Reacher
Faisabad, Pakistan
+92-305-867-6453
4
Scarlet Johnson
Rawalpindi, Pakistan
+92-311-285-6532
5
Chris Evans
Lahore, Pakistan
+92-315-564-9888
6
Tom Holland
Islamabad, Pakistan
+92-301-768-8879
7
Nancy Finland
Quetta, Pakistan
+92-333-689-4532
8
Clark Kent
Lahore, Pakistan
+92-300-768-8822
9
Jack Hammer
Lahore, Pakistan
+92-312-793-9874
publisher_name
publisher_address
publisher_phone
publisher_email
Auraq Publications
BS-6, Satti Plaza, Stadium Rd, Rawalpindi,Pakistan
+92-300-0571-530
auraqpublications@gmail.com
Fact Publications
14/B 2nd Floor Ali Plaza Temple Road, Lahore, Pakistan
+92-42-3524-0076
publications.fact711@gmail.com
Daniyal Publisher
Lar,38 Ghazni St, Urdu Bazar Lahore, Pakistan
+92-320-7660-736
maktabahdanyal786@gmail.com
Jinnah Group of Publications
5# Stop, Kahna Nau, Lahore, Pakistan
+92-300-151-5777
jinnahpublications1@gmail.com
author_name
author_dob
author_nationality
Jane Austen
2001-01-22
Netherland
William Blake
1981-12-19
Pakistan
George Eliot
1983-08-22
Russia
John Milton
1971-04-09
China
Harold Pinter
1943-07-23
Pakistan
Charles Dickens
1981-09-01
USL
Samuel Taylor
1987-09-24
Wakanda
book_id
book_title
publisher_name
author_name
book_price
book_publish_year
1910
The Green Mile
Fact Publications
Jane Austen
19$
2012
1911
Dune
Fact Publications
Jane Austen
10$
2001
1912
The Name of the Wind
Fact Publications
Jane Austen
32$
2001
1913
The Hobbit
Sultan Publications
William Blake
5$
2007
1914
A Wise Mans Fear
Sultan Publications
William Blake
21$
2011
1915
Eragon
Sultan Publications
William Blake
7$
2007
1916
Harry Potter
Paramount Books
George Eliot
3$
2009
1917
Hard Boiled Wonderland
Paramount Books
George Eliot
11$
2015
1918
The Giving Tree
Paramount Books
George Eliot
22$
2021
1919
The Hitchhikers Guide to the Galaxy
Medical Channel Journal
John Milton
14$
2022
1920
Brave New World
Medical Channel Journal
John Milton
6$
2001
1921
Fight Club
Medical Channel Journal
John Milton
5$
2019
1922
The Princess Bride
Auraq Publications
Harold Pinter
17$
2013
1923
Holes
Auraq Publications
Harold Pinter
2$
2016
1924
The Fellowship of the Ring
Auraq Publications
Harold Pinter
8$
2002
1925
Game of Thrones
Jinnah Group of Publications
Charles Dickens
13$
2016
1926
The Lost Tribe
Jinnah Group of Publications
Charles Dickens
12$
2009
1927
Invisible Man
Jinnah Group of Publications
Charles Dickens
4$
2008
1928
Don Quixote
Daniyal Publisher
Samuel Taylor
7$
2014
1929
Beloved
Daniyal Publisher
Samuel Taylor
23$
2018
1930
A Promised Land
Daniyal Publisher
Samuel Taylor
free
2021
borrower_id
borrowing_date
due_date
return_status
2001
2022-01-25
2022-05-25
Not Returned
2002
2022-03-01
2022-04-01
Returned
2003
2022-01-22
2022-04-25
Returned
2004
2022-05-09
2022-06-05
Returned
2005
2022-03-19
2022-07-01
Not Returned
2006
2022-02-22
2022-04-29
Not Returned
2007
2022-04-09
2022-06-25
Returned
borrower_id
borrower_name
borrower_address
borrower_phone
2001
Michael John
USA
+92-300-453-6543
2002
Natasha Romanoff
Canada
+92-209-432-7943
2003
Mike Jackson
USA
+92-311-873-3827
2004
Indiana Johns
Russia
+92-345-623-9293
2005
Camilia David
Germany
+92-307-432-4533
2006
David Guetta
USA
+92-322-323-2321
2007
Showbaz Shariff
Indiana
+92-344-422-3412
ebook_title
ebook_price
ebook_publisher_name
ebook_author_name
Verity
5$
Pearson
Colleen Hoover
It Ends with Us
16$
Pearson
Colleen Hoover
Where the Crawdads Sing
9$
Penguin
Delia Owens
The Seven Husbands of Evelyn Hugo
7$
Penguin
Taylor Jenkins Reid
Ugly Love
23$
Hachette
James Clear
Atomic Habits
31$
Hachette
James Clear
The Body Keeps the Score
21$
Harper Collins
Bessel van der Kolk
Sparring Partners
4$
Macmillan
John Grisham
ebook_title
ebook_author_name
ebook_publisher_name
ebook_publisher_address
ebook_publisher_phone
ebook_publisher_email
Verity
Colleen Hoover
Pearson
8517 Excelsior, United States
+1-333-312-3215
pearsonpublications@gmail.com
It Ends with Us
Delia Owens
Penguin
1745 Broadway, 15-3 New York
+1-234-322-5623
penguinbooks@gmail.com
Where the Crawdads Sing
Taylor Jenkins Reid
Hachette Book Group.
1290 6th Ave, New York, NY 10104,United States
+1-212-364-1100
hachette.books@hbgusa.com
The Seven Husbands of Evelyn Hugo
James Clear
Harper Collins
New York, United States
+1-800-242-7737
orders@harpercollins.com
Ugly Love
Bessel van der Kolk
Macmillan
New York, United States
+1-888-330-8477
contact@macmillan.org.uk
Atomic Habits
John Grisham
USL
United States of Lidr
+1-233-243-5433
uslpublications@gmail.com
The Body Keeps the Score
Amy Tan
RELX Group
Queens Road, Brazil
+1-880-343-5642
relxgroup@gmail.com
Sparring Partners
Atul Gawande
Fiction House Publishers
68 Mozang Rd, Lahore, Pakistan
+42-342-321-4333
orders@fiction.com