Library Database System

Running head LIBRARY DATABASE SYSTEM
Library Database System
Name of the student:
Name of the University:
Author note:

1
LIBRARY DATABASE SYSTEM
2.1 Table of Contents
2.2 Normalization.......................................................................................................................2
2.3 ER Diagram..........................................................................................................................3
2.4 Data Dictionary....................................................................................................................3
2.5 Database Implementation.....................................................................................................5

2
LIBRARY DATABASE SYSTEM
2.2 Normalization
1st Normal form
ItemID CategoryType Name Price Author ISBN MemberID Name Phone Address
2nd Normal form
BookID CategoryType Name Price Author MemberID Name Phone
CdID CategoryType Title Price Type MemberID Name Phone
3rd Normal Form
Item Table
Category_num Type
Book Table
BookID CategoryID Name Price Author ISBN
CD Table
CdID CategoryID Title Price Type Time
Member
MemberID Name Phone Address

3
LIBRARY DATABASE SYSTEM
Registers
RegID MemberID TypeID CategoryID Borrow_date Return_date
2.3 ER Diagram
2.4 Data Dictionary
Item Table
TYPE VARCHAR2(20)
CATEGORY NUMBER
Book Table
BOOKID NUMBER