A SQL Task – All Assignment Experts

---------------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;
Stumble
April 2024
M	T	W	T	F	S	S
« Feb
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30