---------------CREATE CUSTOMER CREATE TABLE CUSTOMER(CUSTOMERID INT NOT NULL PRIMARY KEY, CUSTOMERFIRST VARCHAR(50) NOT NULL, CUSTOMERLAST VARCHAR(50) NOT NULL , CUSTOMERSTREET VARCHAR(50) NOT NULL , CUSTOMERCITY VARCHAR(50) NOT NULL , CUSTOMERSTATE VARCHAR(50) NOT NULL , CUSTOMERZIP VARCHAR(50) NOT NULL ); --------------INSERT CUSTOMER INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (1,'Christian','Walker','96 Clark Drive','Hicksvile','NY','11801'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (2,'Deena','Pilgrim','838 Orange Street','Frederick','MD','21701'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (3,'Calista','Secor','9330 El Dorado Lane','Temple Hills','MD','20748'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (4,'Emile','Cross','387 Circle Ave','Vincentown','NJ','08088'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (5,'Johnny','Royalle','9948 Campfire Drive','East Elmhurst','NY','11369'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (6,'Harley','Cohen','96 Vine StreeT','Bowie','MD','20715'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (7,'Christian','Walker','96 Clark Drive','Hicksvile','NY','11801'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (8,'Christian','Walker','96 Clark Drive','Hicksvile','NY','11801'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (9,'Christian','Walker','96 Clark Drive','Hicksvile','NY','11801'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (10,'Deena','Pilgrim','838 Orange Street','Frederick','MD','21701'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (11,'Deena','Pilgrim','838 Orange Street','Frederick','MD','21701'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (12,'Calista','Secor','9330 El Dorado Lane','Temple Hills','MD','20748'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (13,'Calista','Secor','9330 El Dorado Lane','Temple Hills','MD','20748'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (14,'Emile','Cross','387 Circle Ave','Vincentown','NJ','08088'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (15,'Emile','Cross','387 Circle Ave','Vincentown','NJ','08088'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (16,'Johnny','Royalle','9948 Campfire Drive','East Elmhurst','NY','11369'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (17,'Johnny','Royalle','9948 Campfire Drive','East Elmhurst','NY','11369'); INSERT INTO CUSTOMER(CUSTOMERID,CUSTOMERFIRST,CUSTOMERLAST,CUSTOMERSTREET,CUSTOMERCITY,CUSTOMERSTATE,CUSTOMERZIP)VALUES (18,'Harley','Cohen','96 Vine StreeT','Bowie','MD','20715'); --------------CREATE LIBRARY CREATE TABLE LIBRARY_SYS(LIBRARY_CODE_ID INT NOT NULL PRIMARY KEY, CUSTOMERID INT NOT NULL, LIBRARY_CARD_NUM INT NOT NULL , CARD_PIN INT NOT NULL , CARD_EXPIRTION_DATE DATE, CARD_ISSUE_LIBARARY VARCHAR(50), LIBRARY_CONTACT INT NOT NULL , LIBRARY_ADDRESS VARCHAR(50), FOREIGN KEY (CUSTOMERID) REFERENCES CUSTOMER(CUSTOMERID)); ------------INSERT LIBRARY INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (1,1,16777216,1234,'31-DEC-2019','New York Public Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (2,2,33554432,8192,'04-JULY-2020','New York Public Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (3,3,10485760,8888,'29-FEB-2020','Baltimore County Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (4,4,20971520,0911,'17-MAY-2021','Baltimore County Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (5,5,65536128,4711,'09-OCT-2019','UMUC Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (6,6,32768256,8008,'11-MAR-2020','UMUC Library Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (7,4,16384512,8192,'15-FEB-2020','UMUC Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (8,2,33554432,8192,'04-JULY-2020','New York Public Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (9,3,10485760,8888,'29-FEB-2020','Baltimore County Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (10,4,20971520,0911,'17-MAY-2021','Baltimore County Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (11,5,65536128,4711,'09-OCT-2019','UMUC Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (12,6,32768256,8008,'11-MAR-2020','UMUC Library Library','2125551234','476 5th Avenue, New York, NY'); INSERT INTO LIBRARY_SYS(LIBRARY_CODE_ID,CUSTOMERID ,LIBRARY_CARD_NUM ,CARD_PIN,CARD_EXPIRTION_DATE,CARD_ISSUE_LIBARARY,LIBRARY_CONTACT,LIBRARY_ADDRESS)VALUES (13,4,16384512,8192,'15-FEB-2020','UMUC Library','2125551234','476 5th Avenue, New York, NY'); ------------CREATE TRASACTION CREATE TABLE TRASACTION(TRASACTIONID INT NOT NULL PRIMARY KEY, LIBRARY_CODE_ID INT NOT NULL, CUSTOMERID INT NOT NULL, CHECKOUT_DATE DATE, DUE_DATE DATE, RETURN_DATE DATE, FOREIGN KEY (LIBRARY_CODE_ID) REFERENCES LIBRARY_SYS(LIBRARY_CODE_ID), FOREIGN KEY (CUSTOMERID) REFERENCES CUSTOMER(CUSTOMERID)); -------------INSERT TRASACTION INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (1,1,1,'02-FEB-2017','02-MAR-2017','28-FEB-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (2,2,2,'28-FEB-2017','28-MAR-2017','01-APR-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (3,3,3,'01-APR-2017','01-MAY-2017','03-APR-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (4,4,4,'03-APR-2017','03-MAY-2017','30-APR-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (5,5,5,'03-MAR-2017','03-APR-2017','28-MAR-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (6,6,6,'12-DEC-2017','12-JAN-2018',''); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (7,7,7,'12-DEC-2017','12-JAN-2018',''); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (8,1,1,'14-JUL-2017','14-AUG-2017','20-AUG-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (9,2,2,'20-AUG-2017','20-SEP-2017','19-SEP-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (10,3,3,'19-SEP-2017','19-OCT-2017','21-SEP-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (11,4,4,'21-SEP-2017','21-OCT-2017',''); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (12,5,5,'12-MAY-2017','12-JUN-2017','31-MAY-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (13,6,6,'12-MAY-2017','12-JUN-2018','31-MAY-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (14,7,7,'12-MAY-2017','12-JUN-2018','31-MAY-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (15,1,1,'11-NOV-2017','11-DEC-2017','09-DEC-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (16,2,2,'09-DEC-2017','09-JAN-2017',''); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (17,3,3,'12-DEC-2017','12-JAN-2017','20-DEC-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (18,4,4,'14-JUL-2017','14-AUG-2017','20-JUL-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (19,5,5,'21-JUL-2017','21-AUG-2017','22-JUL-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (20,6,6,'12-OCT-2017','12-NOV-2018','22-OCT-2017'); INSERT INTO TRASACTION(TRASACTIONID,LIBRARY_CODE_ID ,CUSTOMERID ,CHECKOUT_DATE ,DUE_DATE,RETURN_DATE)VALUES (21,7,7,'10-OCT-2017','10-NOV-2018','22-OCT-2017'); ------------CREATE BRANCH CREATE TABLE BRANCH(BRANCH_ITEM_ID INT NOT NULL PRIMARY KEY, LIBRARY_CODE_ID INT NOT NULL, BRANCH_ITEM_CODE_NUM INT NOT NULL, BRANCH_ITEM_PURCHASE_DATE DATE, BRANCH_NAME VARCHAR(50) NOT NULL, BRANCH_PHONE INT NOT NULL, BRANCH_ADDRESS VARCHAR(50) NOT NULL, BRANCH_IDENTIFIER INT NOT NULL, BRANCH_LIBRARY_SYSTEM VARCHAR(50) NOT NULL, FOREIGN KEY (LIBRARY_CODE_ID) REFERENCES LIBRARY_SYS(LIBRARY_CODE_ID)); --------------INSERT BRANCH INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (1,1,1,'01-FEB-2011','125th Street Library','2125552345','224 E 125th St, New York, NY',101,'New York Public Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (2,2,2,'15-MAR-2012','125th Street Library','2125552345','224 E 125th St, New York, NY',101,'New York Public Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (3,3,3,'08-JUL-2011','Grand Central Library','21255523','224 E 125th St, New York, NY',101,'New York Public Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (4,4,4,'08-JUL-2011','125th Street Library','2125552345','224 E 125th St, New York, NY',101,'Baltimore County Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (5,5,5,'23-FEB-2013','125th Street Library','2125552345','224 E 125th St, New York, NY',101,'New York Public Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (6,6,6,'04-MAR-2014','125th Street Library','2125552345','224 E 125th St, New York, NY',101,'New York Public Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (7,7,7,'01-FEB-2011','125th Street Library','2125552345','224 E 125th St, New York, NY',101,'New York Public Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (8,1,1,'04-MAR-2014','125th Street Library','2125552345','1100 Eastern Blvd, Essex, MD',101,'Baltimore County Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (9,2,1,'14-JUN-2017','Essex Branch','2125552345','1100 Eastern Blvd, Essex, MD, NY',101,'Baltimore County Library'); INSERT INTO BRANCH(BRANCH_ITEM_ID,LIBRARY_CODE_ID ,BRANCH_ITEM_CODE_NUM ,BRANCH_ITEM_PURCHASE_DATE ,BRANCH_NAME ,BRANCH_PHONE ,BRANCH_ADDRESS ,BRANCH_IDENTIFIER ,BRANCH_LIBRARY_SYSTEM)VALUES (10,3,1,'14-JUN-2017','Essex Branch','2125552345','1100 Eastern Blvd, Essex, MD',101,'Baltimore County Library'); --------------------CREATE CATALOG CREATE TABLE CATALOG(CATALOG_ITEM_ID INT NOT NULL PRIMARY KEY, LIBRARY_CODE_ID INT NOT NULL, TITLE VARCHAR(50) NOT NULL, DESCRIPTION VARCHAR(50) NOT NULL, PUBLISHER VARCHAR(50) NOT NULL, RELEASE_DATE DATE, TYPE VARCHAR(50) NOT NULL, BOOK_ISBN INT NOT NULL, BOOK_PAGES INT NOT NULL, DVD_LENGTH VARCHAR(50) NOT NULL, FOREIGN KEY (LIBRARY_CODE_ID) REFERENCES LIBRARY_SYS(LIBRARY_CODE_ID)); -------------INSERT CATALOG INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (1,1,'Way of Kings','Fantasy','Tor Books','31-AUG-2010','Book','9780765365279',1280,'1'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (2,2,'Words of Radiance','Fantasy','Tor Books','31-AUG-2010','Book','9780765365279',1280,'1'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (3,3,'Inception','Science Fiction/Thriller','Warner Bros','08-JUL-2008','DVD','9780765365279',1280,'2:28'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (4,4,'Way of Kings','Fantasy','Tor Books','01-OCT-2010','Book','9780765365279',1380,'1'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (5,5,'La La Land','Musical','Summit Entertainments','04-MAR-2014','DVD','9780765365279',1380,'2:08'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (6,6,'Moonrise Kingdom','Drama comedy','Tor Books','31-AUG-2010','DVD','9780765365279',1280,'1:34'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (7,1,'The Name of the Wind','Fantasy','Tor Books','31-AUG-2010','DVD','9780765365279',1080,'2:08'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (8,2,'The Social Network','Drama','Columbia Pictures','31-AUG-2010','DVD','9780765365279',1280,'2:08'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (9,3,'Way of Kings','Fantasy','Tor Books','25-MAY-2012','Book','9780765365279',1280,'2:08'); INSERT INTO CATALOG(CATALOG_ITEM_ID ,LIBRARY_CODE_ID ,TITLE ,DESCRIPTION ,PUBLISHER,RELEASE_DATE ,TYPE ,BOOK_ISBN ,BOOK_PAGES,DVD_LENGTH)VALUES (10,1,'Way of Kings','Fantasy','Tor Books','31-AUG-2010','Book','9780765365279',1280,'00'); -------------- SELECT BRANCH_ITEM_CODE_NUM, BRANCH_ITEM_PURCHASE_DATE,BRANCH_NAME,CUSTOMERID,LIBRARY_CARD_NUM FROM BRANCH INNER JOIN LIBRARY_SYS ON BRANCH.LIBRARY_CODE_ID=LIBRARY_SYS.LIBRARY_CODE_ID;
