Library Database System
VerifiedAdded on  2023/05/28
|19
|4490
|112
AI Summary
This article discusses the implementation of a library database system including normalization, ER diagram, data dictionary, and database implementation. It also includes sample data and SQL queries.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Running head LIBRARY DATABASE SYSTEM
Library Database System
Name of the student:
Name of the University:
Author note:
Library Database System
Name of the student:
Name of the University:
Author note:
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
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
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
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
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
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
4
LIBRARY DATABASE SYSTEM
CATEGORY NUMBER
NAME VARCHAR2(50)
PRICE NUMBER
AUTHOR VARCHAR2(50)
ISBN NUMBER
CD Table
CDID NUMBER
CATEGORY NUMBER
TITLE VARCHAR2(50)
TYPE VARCHAR2(20)
PRICE NUMBER
TIME NUMBER
Member Table
MEMBERID NUMBER
NAME VARCHAR2(20)
PHONE NUMBER
ADDRESS VARCHAR2(50)
Register table
REGID NUMBER
LIBRARY DATABASE SYSTEM
CATEGORY NUMBER
NAME VARCHAR2(50)
PRICE NUMBER
AUTHOR VARCHAR2(50)
ISBN NUMBER
CD Table
CDID NUMBER
CATEGORY NUMBER
TITLE VARCHAR2(50)
TYPE VARCHAR2(20)
PRICE NUMBER
TIME NUMBER
Member Table
MEMBERID NUMBER
NAME VARCHAR2(20)
PHONE NUMBER
ADDRESS VARCHAR2(50)
Register table
REGID NUMBER
5
LIBRARY DATABASE SYSTEM
TYPEID NUMBER
CATEGORY NUMBER
MEMBERID NUMBER
DATE_BORROW DATE
DATE_RETURN DATE
2.5 Database Implementation
CREATE TABLE ITEM
(
TYPE VARCHAR2(20) NOT NULL , CATEGORY NUMBER NOT NULL ,
CONSTRAINT ITEM_PK PRIMARY KEY (CATEGORY)
);
CREATE TABLE BOOK
(
BOOKID NUMBER NOT NULL , CATEGORY NUMBER NOT NULL , NAME
VARCHAR2(20) NOT NULL , PRICE NUMBER NOT NULL , AUTHOR
VARCHAR2(10) NOT NULL , ISBN NUMBER , CONSTRAINT BOOK_PK
PRIMARY KEY ( BOOKID , CATEGORY )
);
CREATE TABLE CD
(
LIBRARY DATABASE SYSTEM
TYPEID NUMBER
CATEGORY NUMBER
MEMBERID NUMBER
DATE_BORROW DATE
DATE_RETURN DATE
2.5 Database Implementation
CREATE TABLE ITEM
(
TYPE VARCHAR2(20) NOT NULL , CATEGORY NUMBER NOT NULL ,
CONSTRAINT ITEM_PK PRIMARY KEY (CATEGORY)
);
CREATE TABLE BOOK
(
BOOKID NUMBER NOT NULL , CATEGORY NUMBER NOT NULL , NAME
VARCHAR2(20) NOT NULL , PRICE NUMBER NOT NULL , AUTHOR
VARCHAR2(10) NOT NULL , ISBN NUMBER , CONSTRAINT BOOK_PK
PRIMARY KEY ( BOOKID , CATEGORY )
);
CREATE TABLE CD
(
6
LIBRARY DATABASE SYSTEM
CDID NUMBER NOT NULL , CATEGORY NUMBER NOT NULL , TITLE
VARCHAR2(20) NOT NULL , TYPE VARCHAR2(20 BYTE) NOT NULL , PRICE
NUMBER NOT NULL , TIME NUMBER NOT NULL , CONSTRAINT CD_PK
PRIMARY KEY ( CDID , CATEGORY )
);
CREATE TABLE MEMBER
(
MEMBERID NUMBER NOT NULL , NAME VARCHAR2(20 BYTE) NOT
NULL , PHONE NUMBER(10, 0) NOT NULL , ADDRESS VARCHAR2(50
BYTE) NOT NULL , CONSTRAINT MEMBER_PK PRIMARY KEY
( MEMBERID )
);
CREATE TABLE REGISTER
(
REGID NUMBER NOT NULL , TYPEID NUMBER , CATEGORY
VARCHAR2(20 BYTE), MEMBERID VARCHAR2(20) , DATE_ BORROW DATE
NOT NULL , DATE_RETURN DATE , CONSTRAINT REGISTER_PK PRIMARY
KEY ( REGID )
);
Insert into tables
LIBRARY DATABASE SYSTEM
CDID NUMBER NOT NULL , CATEGORY NUMBER NOT NULL , TITLE
VARCHAR2(20) NOT NULL , TYPE VARCHAR2(20 BYTE) NOT NULL , PRICE
NUMBER NOT NULL , TIME NUMBER NOT NULL , CONSTRAINT CD_PK
PRIMARY KEY ( CDID , CATEGORY )
);
CREATE TABLE MEMBER
(
MEMBERID NUMBER NOT NULL , NAME VARCHAR2(20 BYTE) NOT
NULL , PHONE NUMBER(10, 0) NOT NULL , ADDRESS VARCHAR2(50
BYTE) NOT NULL , CONSTRAINT MEMBER_PK PRIMARY KEY
( MEMBERID )
);
CREATE TABLE REGISTER
(
REGID NUMBER NOT NULL , TYPEID NUMBER , CATEGORY
VARCHAR2(20 BYTE), MEMBERID VARCHAR2(20) , DATE_ BORROW DATE
NOT NULL , DATE_RETURN DATE , CONSTRAINT REGISTER_PK PRIMARY
KEY ( REGID )
);
Insert into tables
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
7
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('1', '1', 'OZ', '21', 'L. Frank Baum', '1231231231')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('2', '1', 'HARRY POTTER', '12', 'JK ROWLING', '2342342342')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('3', '1', 'GOT', '43', 'Jan Mike', '3453453453')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('4', '1', 'POSTMASTER', '34', 'RABINDRANATH TAGORE', '4564564564')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('5', '1', 'GITANJALI', '65', 'RABINDRANATH TAGORE', '5675675675')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('6', '1', 'OLIVER TWIST', '45', 'CHARLES DICKENS', '6786786786')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('7', '1', 'EARTH ENCYCLOPEDIA', '23', 'JOHN DOE', '7987897897')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('8', '1', 'MYSTERY 11', '33', 'JANE DOE', '8908908908')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('9', '1', 'THE SHINING', '11', 'STEPHEN KING', '3213213213')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('10', '1', 'DAVID COPPERFIELD', '44', 'CHARLES DICKENS', '4324324324')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('11', '1', 'ALIBABA', '56', 'Richard F. Burton', '5435435435')
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('1', '1', 'OZ', '21', 'L. Frank Baum', '1231231231')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('2', '1', 'HARRY POTTER', '12', 'JK ROWLING', '2342342342')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('3', '1', 'GOT', '43', 'Jan Mike', '3453453453')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('4', '1', 'POSTMASTER', '34', 'RABINDRANATH TAGORE', '4564564564')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('5', '1', 'GITANJALI', '65', 'RABINDRANATH TAGORE', '5675675675')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('6', '1', 'OLIVER TWIST', '45', 'CHARLES DICKENS', '6786786786')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('7', '1', 'EARTH ENCYCLOPEDIA', '23', 'JOHN DOE', '7987897897')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('8', '1', 'MYSTERY 11', '33', 'JANE DOE', '8908908908')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('9', '1', 'THE SHINING', '11', 'STEPHEN KING', '3213213213')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('10', '1', 'DAVID COPPERFIELD', '44', 'CHARLES DICKENS', '4324324324')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('11', '1', 'ALIBABA', '56', 'Richard F. Burton', '5435435435')
8
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('12', '1', 'ALLADIN', '56', 'Antoine ', '6546546546')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('13', '1', 'GULIVERS TRAVEL', '22', 'Jonathan Swift', '7657657657')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('14', '1', 'GIFT OF NILE', '23', 'JANE MASON', '8768768768')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('15', '1', 'WAR AND PEACE', '50', 'LEO TOLSTOY', '9879879879')
Commit Successful
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('1', '2', 'THE KILLING', 'ACTION', '22', '123')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('2', '2', 'THE SHINING', 'HORROR', '33', '200')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('3', '2', 'BLAIR WITCH PROJECT', 'HORROR', '44', '87')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('4', '2', 'THE HOLE', 'CRIME', '22', '90')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('5', '2', 'BATMAN', 'ACTION', '33', '100')
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('12', '1', 'ALLADIN', '56', 'Antoine ', '6546546546')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('13', '1', 'GULIVERS TRAVEL', '22', 'Jonathan Swift', '7657657657')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('14', '1', 'GIFT OF NILE', '23', 'JANE MASON', '8768768768')
INSERT INTO "HR"."BOOK" (BOOKID, CATEGORY, NAME, PRICE, AUTHOR, ISBN)
VALUES ('15', '1', 'WAR AND PEACE', '50', 'LEO TOLSTOY', '9879879879')
Commit Successful
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('1', '2', 'THE KILLING', 'ACTION', '22', '123')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('2', '2', 'THE SHINING', 'HORROR', '33', '200')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('3', '2', 'BLAIR WITCH PROJECT', 'HORROR', '44', '87')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('4', '2', 'THE HOLE', 'CRIME', '22', '90')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('5', '2', 'BATMAN', 'ACTION', '33', '100')
9
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('6', '2', 'AVENGERS', 'ACTION', '44', '102')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('7', '2', 'THE GODFATHER', 'CRIME', '55', '115')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('8', '2', 'PULP FICTION', 'CRIME', '11', '186')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('9', '2', 'FIGHT CLUB', 'ACTION', '24', '150')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('10', '2', 'ORPHAN', 'HORROR', '45', '90')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('11', '2', 'CONJURING', 'HORROR', '43', '60')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('12', '2', 'FOREST GRUMP', 'DRAMA', '23', '106')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('13', '2', '12 ANGRY MEN', 'DRAMA', '34', '125')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('14', '2', 'THE MATRIX', 'ACTION', '43', '145')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('15', '2', 'HOME ALONE', 'COMEDY', '33', '200')
Commit Successful
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('6', '2', 'AVENGERS', 'ACTION', '44', '102')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('7', '2', 'THE GODFATHER', 'CRIME', '55', '115')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('8', '2', 'PULP FICTION', 'CRIME', '11', '186')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('9', '2', 'FIGHT CLUB', 'ACTION', '24', '150')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('10', '2', 'ORPHAN', 'HORROR', '45', '90')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('11', '2', 'CONJURING', 'HORROR', '43', '60')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('12', '2', 'FOREST GRUMP', 'DRAMA', '23', '106')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('13', '2', '12 ANGRY MEN', 'DRAMA', '34', '125')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('14', '2', 'THE MATRIX', 'ACTION', '43', '145')
INSERT INTO "HR"."CD" (CDID, CATEGORY, TITLE, TYPE, PRICE, TIME) VALUES
('15', '2', 'HOME ALONE', 'COMEDY', '33', '200')
Commit Successful
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
10
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('1', 'JOHN', '1212121212', 'MANCHESTER')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('2', 'JANE', '3322332233', 'LONDON')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('3', 'MILY', '4433443344', 'MANCHESTER')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('4', 'MAX', '1122112233', 'LIVERPOOL')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('5', 'ROSS', '1020304050', 'OXFORD')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('6', 'RACHEL', '5040302010', 'LONDON')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('7', 'CHANDLER', '0102030405', 'LIVERPOOL')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('8', 'MONIKA', '0504030201', 'BATH')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('9', 'JOEY', '1133225544', 'MANCHESTER')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('10', 'PHOEBE', '1534211510', 'YORK')
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('1', 'JOHN', '1212121212', 'MANCHESTER')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('2', 'JANE', '3322332233', 'LONDON')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('3', 'MILY', '4433443344', 'MANCHESTER')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('4', 'MAX', '1122112233', 'LIVERPOOL')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('5', 'ROSS', '1020304050', 'OXFORD')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('6', 'RACHEL', '5040302010', 'LONDON')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('7', 'CHANDLER', '0102030405', 'LIVERPOOL')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('8', 'MONIKA', '0504030201', 'BATH')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('9', 'JOEY', '1133225544', 'MANCHESTER')
INSERT INTO "HR"."MEMBER" (MEMBERID, NAME, PHONE, ADDRESS) VALUES
('10', 'PHOEBE', '1534211510', 'YORK')
11
LIBRARY DATABASE SYSTEM
Commit Successful
UPDATE "HR"."REGISTER" SET DATE_BORROW = TO_DATE('2018-08-12 00:00:00',
'YYYY-MM-DD HH24:MI:SS') WHERE ROWID = 'AAAFbyAAEAAAAIOAAA' AND
ORA_ROWSCN = '1808417'
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('2', '3', '2', '3', TO_DATE('2018-08-10
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-14 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('3', '2', '1', '4', TO_DATE('2018-08-12
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-11 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('4', '1', '1', '1', TO_DATE('2018-08-12
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-06 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('5', '14', '1', '5', TO_DATE('2018-09-06
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-16 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
LIBRARY DATABASE SYSTEM
Commit Successful
UPDATE "HR"."REGISTER" SET DATE_BORROW = TO_DATE('2018-08-12 00:00:00',
'YYYY-MM-DD HH24:MI:SS') WHERE ROWID = 'AAAFbyAAEAAAAIOAAA' AND
ORA_ROWSCN = '1808417'
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('2', '3', '2', '3', TO_DATE('2018-08-10
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-14 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('3', '2', '1', '4', TO_DATE('2018-08-12
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-11 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('4', '1', '1', '1', TO_DATE('2018-08-12
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-06 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('5', '14', '1', '5', TO_DATE('2018-09-06
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-16 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
12
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('6', '15', '2', '7', TO_DATE('2018-09-06
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-16 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('7', '10', '1', '2', TO_DATE('2018-09-06
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-25 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('8', '2', '2', '10', TO_DATE('2018-09-25
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-28 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('9', '2', '1', '8', TO_DATE('2018-09-26
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-25 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('10', '11', '2', '5', TO_DATE('2018-09-30
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-18 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('11', '12', '2', '6', TO_DATE('2018-10-25
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-12 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('6', '15', '2', '7', TO_DATE('2018-09-06
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-16 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('7', '10', '1', '2', TO_DATE('2018-09-06
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-25 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('8', '2', '2', '10', TO_DATE('2018-09-25
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-28 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('9', '2', '1', '8', TO_DATE('2018-09-26
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-25 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('10', '11', '2', '5', TO_DATE('2018-09-30
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-18 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('11', '12', '2', '6', TO_DATE('2018-10-25
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-12 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
13
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('12', '08', '1', '2', TO_DATE('2018-10-12
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-23 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('13', '9', '1', '7', TO_DATE('2018-10-23
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-11-03 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('14', '10', '1', '7', TO_DATE('2018-11-05
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-12-20 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('15', '4', '2', '3', TO_DATE('2018-11-14
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-12-14 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
Commit Successful
LIBRARY DATABASE SYSTEM
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('12', '08', '1', '2', TO_DATE('2018-10-12
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-10-23 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('13', '9', '1', '7', TO_DATE('2018-10-23
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-11-03 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('14', '10', '1', '7', TO_DATE('2018-11-05
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-12-20 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
INSERT INTO "HR"."REGISTER" (REGID, TYPEID, CATEGORY, MEMBERID,
DATE_BORROW, DATE_RETURN) VALUES ('15', '4', '2', '3', TO_DATE('2018-11-14
00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-12-14 00:00:00', 'YYYY-MM-
DD HH24:MI:SS'))
Commit Successful
14
LIBRARY DATABASE SYSTEM
Display data
SQL> select * from item;
TYPE CATEGORY
-------------------- ----------
BOOK 1
CD 2
SQL> select *from book;
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
1 1 OZ
21 L. Frank Baum 1231231231
2 1 HARRY POTTER
12 JK ROWLING 2342342342
3 1 GOT
43 Jan Mike 3453453453
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
4 1 POSTMASTER
34 RABINDRANATH TAGORE 4564564564
5 1 GITANJALI
65 RABINDRANATH TAGORE 5675675675
6 1 OLIVER TWIST
45 CHARLES DICKENS 6786786786
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
7 1 EARTH ENCYCLOPEDIA
23 JOHN DOE 7987897897
8 1 MYSTERY 11
33 JANE DOE 8908908908
LIBRARY DATABASE SYSTEM
Display data
SQL> select * from item;
TYPE CATEGORY
-------------------- ----------
BOOK 1
CD 2
SQL> select *from book;
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
1 1 OZ
21 L. Frank Baum 1231231231
2 1 HARRY POTTER
12 JK ROWLING 2342342342
3 1 GOT
43 Jan Mike 3453453453
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
4 1 POSTMASTER
34 RABINDRANATH TAGORE 4564564564
5 1 GITANJALI
65 RABINDRANATH TAGORE 5675675675
6 1 OLIVER TWIST
45 CHARLES DICKENS 6786786786
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
7 1 EARTH ENCYCLOPEDIA
23 JOHN DOE 7987897897
8 1 MYSTERY 11
33 JANE DOE 8908908908
15
LIBRARY DATABASE SYSTEM
9 1 THE SHINING
11 STEPHEN KING 3213213213
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
10 1 DAVID COPPERFIELD
44 CHARLES DICKENS 4324324324
11 1 ALIBABA
56 Richard F. Burton 5435435435
12 1 ALLADIN
56 Antoine 6546546546
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
13 1 GULIVERS TRAVEL
22 Jonathan Swift 7657657657
14 1 GIFT OF NILE
23 JANE MASON 8768768768
15 1 WAR AND PEACE
50 LEO TOLSTOY 9879879879
15 rows selected.
SQL> select *from cd;
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
1 2 THE KILLING
ACTION 22 123
2 2 THE SHINING
HORROR 33 200
3 2 BLAIR WITCH PROJECT
HORROR 44 87
LIBRARY DATABASE SYSTEM
9 1 THE SHINING
11 STEPHEN KING 3213213213
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
10 1 DAVID COPPERFIELD
44 CHARLES DICKENS 4324324324
11 1 ALIBABA
56 Richard F. Burton 5435435435
12 1 ALLADIN
56 Antoine 6546546546
BOOKID CATEGORY NAME
---------- ---------- --------------------------------------------------
PRICE AUTHOR ISBN
---------- -------------------------------------------------- ----------
13 1 GULIVERS TRAVEL
22 Jonathan Swift 7657657657
14 1 GIFT OF NILE
23 JANE MASON 8768768768
15 1 WAR AND PEACE
50 LEO TOLSTOY 9879879879
15 rows selected.
SQL> select *from cd;
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
1 2 THE KILLING
ACTION 22 123
2 2 THE SHINING
HORROR 33 200
3 2 BLAIR WITCH PROJECT
HORROR 44 87
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
16
LIBRARY DATABASE SYSTEM
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
4 2 THE HOLE
CRIME 22 90
5 2 BATMAN
ACTION 33 100
6 2 AVENGERS
ACTION 44 102
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
7 2 THE GODFATHER
CRIME 55 115
8 2 PULP FICTION
CRIME 11 186
9 2 FIGHT CLUB
ACTION 24 150
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
10 2 ORPHAN
HORROR 45 90
11 2 CONJURING
HORROR 43 60
12 2 FOREST GRUMP
DRAMA 23 106
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
13 2 12 ANGRY MEN
DRAMA 34 125
LIBRARY DATABASE SYSTEM
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
4 2 THE HOLE
CRIME 22 90
5 2 BATMAN
ACTION 33 100
6 2 AVENGERS
ACTION 44 102
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
7 2 THE GODFATHER
CRIME 55 115
8 2 PULP FICTION
CRIME 11 186
9 2 FIGHT CLUB
ACTION 24 150
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
10 2 ORPHAN
HORROR 45 90
11 2 CONJURING
HORROR 43 60
12 2 FOREST GRUMP
DRAMA 23 106
CDID CATEGORY TITLE
---------- ---------- --------------------------------------------------
TYPE PRICE TIME
-------------------- ---------- ----------
13 2 12 ANGRY MEN
DRAMA 34 125
17
LIBRARY DATABASE SYSTEM
14 2 THE MATRIX
ACTION 43 145
15 2 HOME ALONE
COMEDY 33 200
15 rows selected.
SQL> select *from member;
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
1 JOHN 1212121212
MANCHESTER
2 JANE 3322332233
LONDON
3 MILY 4433443344
MANCHESTER
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
4 MAX 1122112233
LIVERPOOL
5 ROSS 1020304050
OXFORD
6 RACHEL 5040302010
LONDON
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
7 CHANDLER 102030405
LIVERPOOL
8 MONIKA 504030201
BATH
LIBRARY DATABASE SYSTEM
14 2 THE MATRIX
ACTION 43 145
15 2 HOME ALONE
COMEDY 33 200
15 rows selected.
SQL> select *from member;
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
1 JOHN 1212121212
MANCHESTER
2 JANE 3322332233
LONDON
3 MILY 4433443344
MANCHESTER
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
4 MAX 1122112233
LIVERPOOL
5 ROSS 1020304050
OXFORD
6 RACHEL 5040302010
LONDON
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
7 CHANDLER 102030405
LIVERPOOL
8 MONIKA 504030201
BATH
18
LIBRARY DATABASE SYSTEM
9 JOEY 1133225544
MANCHESTER
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
10 PHOEBE 1534211510
YORK
10 rows selected.
SQL> select *from register;
REGID TYPEID CATEGORY MEMBERID DATE_BORR DATE_RETU
---------- ---------- ---------- ---------- --------- ---------
1 1 2 3 12-AUG-18 22-OCT-18
2 3 2 3 10-AUG-18 14-OCT-18
3 2 1 4 12-AUG-18 11-OCT-18
4 1 1 1 12-AUG-18 06-SEP-18
5 14 1 5 06-SEP-18 16-SEP-18
6 15 2 7 06-SEP-18 16-SEP-18
7 10 1 2 06-SEP-18 25-SEP-18
8 2 2 10 25-SEP-18 28-SEP-18
9 2 1 8 26-SEP-18 25-OCT-18
10 11 2 5 30-SEP-18 18-OCT-18
11 12 2 6 25-OCT-18 12-OCT-18
12 8 1 2 12-OCT-18 23-OCT-18
13 9 1 7 23-OCT-18 03-NOV-18
14 10 1 7 05-NOV-18 20-DEC-18
15 4 2 3 14-NOV-18 14-DEC-18
15 rows selected.
LIBRARY DATABASE SYSTEM
9 JOEY 1133225544
MANCHESTER
MEMBERID NAME PHONE
---------- -------------------- ----------
ADDRESS
--------------------------------------------------
10 PHOEBE 1534211510
YORK
10 rows selected.
SQL> select *from register;
REGID TYPEID CATEGORY MEMBERID DATE_BORR DATE_RETU
---------- ---------- ---------- ---------- --------- ---------
1 1 2 3 12-AUG-18 22-OCT-18
2 3 2 3 10-AUG-18 14-OCT-18
3 2 1 4 12-AUG-18 11-OCT-18
4 1 1 1 12-AUG-18 06-SEP-18
5 14 1 5 06-SEP-18 16-SEP-18
6 15 2 7 06-SEP-18 16-SEP-18
7 10 1 2 06-SEP-18 25-SEP-18
8 2 2 10 25-SEP-18 28-SEP-18
9 2 1 8 26-SEP-18 25-OCT-18
10 11 2 5 30-SEP-18 18-OCT-18
11 12 2 6 25-OCT-18 12-OCT-18
12 8 1 2 12-OCT-18 23-OCT-18
13 9 1 7 23-OCT-18 03-NOV-18
14 10 1 7 05-NOV-18 20-DEC-18
15 4 2 3 14-NOV-18 14-DEC-18
15 rows selected.
1 out of 19
Your All-in-One AI-Powered Toolkit for Academic Success.
 +13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
Unlock your academic potential
© 2024  |  Zucol Services PVT LTD  |  All rights reserved.