0.002/01/90 CAROL WILLIS 1.0 INTRODUCTION: DRAFT COPY ------------ ---------- THE BOOKSTORE SUBSYSTEM IS DESIGNED TO FACILITATE THE ORDERING AND INVENTORY OF TEXTBOOKS FOR THE COLLEGE BOOKSTORE. THE SYSTEM MAINTAINS A BOOKSTORE DATA BASE AND PUBLISHER DATA BASE. ALL INFORMATION PERTINENT TO THE ORDERING, SALES AND INVENTORY OF TEXTBOOKS IS KEPT IN THE BOOKSTORE DATA BASE. THE PUBLISHER DATA BASE KEEPS THE FILE OF PUBLISHER NAMES AND ADDRESSES. THERE ALSO EXISTS A PSEUDOLOGICAL RELATIONSHIP BETWEEN THE PUBLISHER DATA BASE AND THE BOOKSTORE DATA BASE, ENABLING THE USER TO EXAMINE TEXTBOOKS ORDERED FROM A SPECIFIC PUBLISHER. 2.0 SYSTEM NARRATIVE ---------------- BEFORE THE BEGINNING OF EACH TERM, THE BOOK REQUEST FORMS ARE RUN FROM THE PREVIOUS YEAR'S DATA AND SENT OUT TO THE DIVISION CHAIRMEN. THE FORMS ARE THEN DISTRIBUTED TO THE VARIOUS INSTRUCTORS WHO MODIFY THESE REQUESTS TO REFLECT THE CHANGES, ADDITIONS OR DELETIONS THAT THEY REQUIRE FOR THE COMING TERM. WHEN THE FORMS HAVE BEEN APPROVED BY THE DIVISION CHAIRMAN THEY ARE SENT BACK TO THE BOOKSTORE. JUST PRIOR TO WORKING WITH A NEW TERM, THE INFORMATION FOR THAT TERM IS COPIED FROM THE PREVIOUS YEAR'S DATA USING A BATCH UPDATE PROGRAM. SINCE THE PROGRAM ALSO TRANSFERS THE ENDING INVENTORY DATA FROM THE CURRENT TERM INTO THE BEGINNING INVENTORY OF THE NEW TERM, THIS SHOULD NOT BE RUN UNTIL THE INVENTORY DATA FROM THE CURRENT TERM IS COMPLETED. AS SOON AS THE NEW TERM'S DATA HAS BEEN CREATED, THE UPDATES FROM THE BOOK REQUEST FORMS CAN BE MADE TO THE DATA BASE. THE PURCHASE ORDERS AND PRELIMINARY COPIES OF THE BOOK LIST CAN NOW BE PRINTED. THE PURCHASE ORDERS ARE SENT OUT. WHEN THE TEXTBOOKS ARRIVE AT THE BOOKSTORE THE INVENTORY AND PRICES ARE ENTERED INTO THE SYSTEM USING THE ONLINE BOOKSTORE SCREENS. ALL INFORMATION IS NOW AVAILABLE TO PRINT THE FINAL COPIES OF THE BOOK LIST. THIS LIST WILL BE USED BY THE STUDENTS TO DETERMINE WHAT TEXTBOOKS THEY WILL NEED TO BUY FOR THE COURSES IN WHICH THEY HAVE ENROLLED. LISTS AND SUMMARY REPORTS ARE ALSO AVAILABLE WITH THIS SUBSYSTEM, INCLUDING VARIOUS BOOKLISTS AND A PUBLISHER LISTING. * 2.1 SYSTEM FLOWCHART ---------------- _____________ _____________ ! BOOKSTORE ! ! SIS ! ! DATA ! ! DATA ! ! BASES ! ! BASES ! !___________! !___________! ! ! !________________________! ! ______!______ ! PROCESS ! ! TRANS- ! ! ACTIONS ! !___________! ! ! ____________________________________........> ! ! ! ______!______ ______!______ ______!______ !___BKS010__! !___BKS020__! !___BKS025__! !ADD/UPDATE/! ! BOOK ! ! CHANGE ! ! DELETE ! ! INQUIRY ! ! RECORD ! !___BOOKS___! !___________! !__NUMBER___! >.........____________________________________........> ! ! ! ______!______ ______!______ ______!______ !___BKS030__! !___BKS040__! !___BKS045__! ! INVENTORY! ! PURCHASE ! ! PURCHASE ! ! UPDATE ! ! ORDER ! ! ORDER ! !___ONLINE__! !___UPDATE__! !__INQUIRY__! >.........____________________________________........> ! ! ! ______!______ ______!______ ______!______ !___BKS050__! !___BKS060__! !___BKS070__! ! INVOICE ! ! RETURN ! !ADD/UPDATE/! ! UPDATE ! ! BOOKS ! ! DELETE ! !___________! !___________! !_PUBLISHER_! BATCH UPDATES >......_____________________________________________________........> ! ! ! ! ______!______ ______!______ ______!______ ______!______ !__BKS300___! !__BKS350___! !__BKS400___! !__BKS450___! ! COPY NEW ! ! PURCHASE ! ! DELETE ! ! RETURN ! ! QTR FROM ! ! ORDER & ! ! PREVIOUS ! ! SLIPS ! !__LAST_YR__! !_UPDATE DB_! !__QUARTERS_! !___________! BATCH REPORTS >.........____________________________________........> ! ! ! ______!______ ______!______ ______!______ !__BKS500___! !__BKS510___! !__BKS520___! ! BOOK ! ! BOOK ! ! LIST OF ! ! REQUEST ! ! LIST ! ! BOOKS BY ! !___FORMS___! !___________! !_PUBLISHER_! >.........____________________________________........> ! ! ! ______!______ ______!______ ______!______ !__BKS530___! !__BKS540___! !__BKS550___! ! LIST OF ! ! SUMMARY OF! ! PRINT ! ! BOOKS BY ! ! BOOK ! ! PUBLISHER ! !__DIV/DEPT_! !__REQUESTS_! !____LIST___! >.........____________________________________ ! ! ! ______!______ ______!______ ______!______ !__BKS560___! !__BKS570___! !__BKS580___! ! SHELF ! ! BOOK ! ! BUY BACK ! ! LABELS ! ! LIST BY ! ! LIST BY ! !___________! !__COURSE___! !__AUTHOR___! ______!______ !__BKS650___! ! SELECT ! ! PURCHASE ! !___ORDERS__! 3.0 DATA BASE DESIGN: ---------------- PHYSICAL DATA BASES ---------- ---------- ]BOOKMSTR] ]PUBLMSTR] ---------- ---------- ! ! ---------- ---------- ]BOOKREC ] ] PUBBOK ] ---------- ---------- __________!__________ ! ! ---------- ---------- ] INVREC ] ] REMREC ] ---------- ---------- ! ---------- ] PORDREC] ---------- ! ---------- ] INVOICE] ---------- ! ---------- ] RETNREC] ---------- * 3.1 SEGMENT LAYOUTS: --------------- BOOKMSTR SEQUENCED AND UNIQUE ONE ENTRY FOR EACH COURSE PER TERM KEY IS BOOK-ID 05 BOOK-ID. 10 BOOK-QUARTER PIC XXX. 10 BOOK-COURSE. 15 CAMPUS PIC X. 15 DEPARTMENT PIC XXXX. 15 COURSE-NUM PIC XXX. 05 COURSE-TITLE PIC X(40). 05 FILLER PIC X(20). BOOKREC SEQUENCED AND UNIQUE ONE ENTRY FOR EACH BOOK NUMBER PER COURSE PER TERM PARENT IS BOOKMSTR KEY IS BOOK-NUMBER 05 BOOK-NUMBER PIC XX. 05 AUTHOR-EDITOR. 10 AUTHOR-ED1 PIC X(25). 10 AUTHOR-ED2 PIC X(25). 05 BOOK-PUBLISHER PIC X(5). 05 BOOK-TITLE. 10 BOOK-TITLE1 PIC X(30). 10 BOOK-TITLE2 PIC X(30). 10 BOOK-TITLE3 PIC X(30). 10 BOOK-TITLE4 PIC X(30). 05 CLASS-SECTIONS PIC X(40). 05 COPYRIGHT-YR PIC XX. 05 DIVISIONS PIC XXX. 05 EDITION. 10 EDITION-NUMBER PIC X(6). 10 EDITION-COMMENT PIC X(20). 05 ISBN PIC X(20). 05 ORDERED-LAST-YR PIC XXXX. 05 QTY-USED-LAST-YR PIC XXXX. 05 QUANTITY-NEEDED PIC 9999. 05 SHELF-LOCATION PIC XXXX. 05 TEXTBOOK-REQUIRED PIC XX. 05 FILLER PIC X(20). INVREC SEQUENCED AND UNIQUE TWO ENTRIES FOR EACH BOOK NUMBER PER COURSE PER TERM (IF NEEDED; ONE FOR NEW, ONE FOR USED) PARENT IS BOOKREC KEY IS NEW-USED-KEY 05 NEW-USED-KEY PIC XXXX. 05 BEGINNING-INVENTORY PIC 9999. 05 INVENTORY-DATE PIC X(6). 05 INVENTORY-ON-HAND PIC 9999. 05 QUANTITY-SOLD PIC 9999. 05 FILLER PIC X(20). PORDREC SEQUENCED AND MULTIPLE ONE ENTRY FOR EACH TIME BOOKS ARE ORDERED FROM A PUBLISHER PARENT IS INVREC KEY IS PUBLISHER-CODE 05 PUBLISHER-CODE PIC X(5). 05 PURCHASE-ORDER-NUMBER PIC X(6). 05 PURCHASE-ORDER-DATE PIC X(6). 05 PURCHASE-ORDER-QUANTITY PIC 9(4). 05 FILLER PIC X(20). INVOICE SEQUENCED AND UNIQUE ONE ENTRY FOR EACH INVOICE NUMBER PER PURCHASE ORDER PARENT IS PORDREC KEY IS INVOICE-NUMBER 05 INVOICE-NUMBER PIC X(20). 05 INVOICE-DATE PIC X(6). 05 INVOICE-DATE-RECEIVED PIC X(6). 05 DISCOUNT-PERCENT PIC 99V9. 05 MARKUP-PERCENT PIC 99V9. 05 QUANTITY-RECEIVED PIC 9999. 05 RETAIL-PRICE PIC 999V99. 05 COST-PRICE PIC 999V99. 05 FILLER PIC X(20). RETNREC UNSEQUENCED ONE ENTRY FOR EACH RETURN PER INVOICE PARENT IS INVOICE NO KEY 05 RETURN-DATE PIC X(6). 05 RETURN-QUANTITY PIC 9(4). 05 RETURN-CODE PIC XX. 05 RETURN-INS-COST PIC 999V99. 05 RETURN-WEIGHT PIC 9(4). 05 RETURN-PRINT-FLAG PIC X. 05 FILLER PIC X(19). REMREC SEQUENCED AND UNIQUE ONE RECORD PER REMARK NUMBER PER BOOK RECORD (IF NEEDED) PARENT IS BOOKMSTR KEY IS REMARK-NO 01 REMARK-RECORD 05 REMARK-NO PIC XX. 05 BOOK-REMARKS PIC X(40). PUBLMSTR SEQUENCED AND UNIQUE ONE ENTRY PER PUBLISHER/VENDOR KEY IS PUBLISHER-CODE 05 PUBLISHER-CODE PIC X(5). 05 NAME-PUBLISHER PIC X(43). 05 NAME-PUBLISHER-SHORT PIC X(5). 05 ORDER-ADDRESS. 10 ORDER-ADDR1 PIC X(37). 10 ORDER-ADDR2 PIC X(37). 10 ORDER-ADDR3 PIC X(37). 05 PHONE-ORDER PIC X(10). 05 PHONE-RETURN PIC X(10). 05 PRIOR-PERMISSION-RETURN PIC X. 05 RETURN-ADDRESS. 10 RETURN-ADDR1 PIC X(37). 10 RETURN-ADDR2 PIC X(37). 10 RETURN-ADDR3 PIC X(37). 05 TIME-LIMIT-RETURN PIC XXX. 05 FILLER PIC X(20). PUBBOK SEQUENCED AND MULTIPLE ONE ENTRY EACH TIME A PURCHASE ORDER IS PRINTED FOR A PUBLISHER PER COURSE PER TERM. KEY IS BOOK-ORDER-KEY 05 BOOK-ORDER-KEY. 10 BOOK-ID PIC X(11). 10 BOOK-NUMBER PIC XX. 10 NEW-USED-KEY PIC XXXX. 10 PUBLISHER-CODE PIC X(5). 3.2 DATA DICTIONARY: --------------- AUTHOR-EDITOR AUTHOR/EDITOR OF BOOK (BOOKREC) BOOK-COURSE CAMPUS, DEPARTMENT AND (BOOKMSTR) SECTION OF COURSE BOOK-KEY PUBLISHER/BOOK - PSEUDO LOGICAL (PUBBOK) SEGMENT (SAME AS BOOKMSTR KEY) BOOK-NUMBER SEQUENTIAL NUMBER ASSIGNED TO (BOOKREC) EACH BOOK USED IN A COURSE BOOK-PUBLISHER PUBLISHER OF BOOK (BOOKREC) BOOK-QUARTER YEAR AND QUARTER (I.E. WINTER=1, (BOOKMSTR) SPRING=2, SUMMER=3, FALL=4) BOOK-REMARKS REMARKS PERTAINING TO A (REMREC) BOOK BOOK-TITLE TITLE OF TEXT (BOOKREC) CLASS-SECTIONS SECTIONS OF CLASS FOR WHICH BOOK (BOOKREC) IS USED, IF NOT ALL SECTIONS COPYRIGHT-YR COPYRIGHT YEAR OF BOOK (BOOKREC) COURSE-TITLE ENTRY FOR COURSE TITLE IF NOT (BOOKMSTR) ON CRSSEGM IN CRS DATA BASE DISCOUNT-PERCENT SPECIAL DISCOUNT OCCASIONALLY (INVOICE) GIVEN BY PUBLISHER DIVISIONS DIVISION (OR DIVISIONS) (BOOKREC) IN WHICH COURSE IS TAUGHT EDITION EDITION OF BOOK (I.E. LATEST, (BOOKREC) PAPERBACK ETC.) INVENTORY-DATE DATE INVENTORY WAS TAKEN (INVREC) INVENTORY-ON-HAND NUMBER OF BOOKS ON HAND (INVREC) INVOICE-DATE DATE OF INVOICE (INVOICE) INVOICE-DATE-RECEIVED DATE BOOK RECEIVED AT BOOKSTORE (INVOICE) INVOICE-NUMBER INVOICE NUMBER (INVOICE) ISBN INTERNATIONAL STANDARD BOOK (BOOKREC) NUMBER MARKUP-PERCENT PERCENT MARKUP ON COST PRICE (INVOICE) NAME-PUBLISHER PUBLISHER NAME (PUBLMSTR) NAME-PUBLISHER-SHORT PUBLISHER ABBREVIATION (PUBLMSTR) NEW-USED-KEY KEY FOR INVREC SEGMENT (INVREC) VALUE EITHER 'NEW' OR 'USED' ORDER-ADDRESS PUBLISHER/VENDOR ADDRESS TO ORDER (PUBLMSTR) BOOKS (NEW OR USED) ORDERED-LAST-YR QUANTITY OF BOOKS REQUESTED BY (BOOKREC) INSTRUCTOR LAST YEAR PHONE-ORDER PHONE NUMBER ASSOCIATED WITH (PUBLMSTR) ORDERING BOOKS FROM PUBLISHER PHONE-RETURN PHONE NUMBER ASSOCIATED WITH (PUBLMSTR) RETURNING BOOKS TO PUBLISHER PRIOR-PERMISION-RETURN IS PRIOR PERMISSION REQUIRED TO (PUBLMSTR) RETURN BOOK TO PUBLISHER? Y/N PUBLISHER-CODE 5 DIGIT CODE OF PUBLISHER/VENDOR (PUBLMSTR, PORDREC) FROM WHOM BOOKS ARE ORDERED PURCHASE-ORDER-DATE DATE OF PURCHASE ORDER (PORDREC) PURCHASE-ORDER-NUMBER PURCHASE ORDER NUMBER (PORDREC) PURCHASE-ORDER-QUANTITY NUMBER OF BOOKS ORDERED (PORDREC) QTY-USED-LAST-YR QUANTITY OF BOOKS SOLD LAST (BOOKREC) YEAR QUANTITY-NEEDED NUMBER OF BOOKS NEEDED FOR (BOOKREC) ALL SECTIONS FOR WHICH THE BOOK IS USED QUANTITY-RECEIVED QUANTITY OF BOOKS RECEIVED (INVOICE) FROM THE PUBLISHER RETAIL-PRICE RETAIL PRICE OF BOOK (INVOICE) (OPTION TO BE CALCULATED BY SYSTEM) REMARK-NO KEY TO THE REMARK SEGMENT (REMREC) VALUE = '01', '02' ETC. RETURN-ADDRESS PUBLISHER/VENDOR ADDRESS WHERE (PUBLMSTR) BOOKS MAY BE RETURNED RETURNED-CODE CODE SIGNIFYING WHY BOOK IS (RETNREC) BEING RETURNED RETURNED-DATE DATE BOOK WAS RETURNED TO (RETNREC) PUBLISHER RETURNED-PRINT-FLAG HAS RETURN SLIP BEEN PRINTED? (RETNREC) BLANK = NO, '1' = YES RETURNED-QUANTITY NUMBER OF BOOKS BEING RETURNED (RETNREC) RETURNED-WEIGHT WEIGHT OF BOOKS BEING RETURNED (RETNREC) RETURNED-INS-COST COST OF INSURANCE FOR RETURNING (RETNREC) BOOKS (IF APPLICABLE) SHELF-LOCATION SHELF LOCATION IN BOOKSTORE (BOOKREC) WHERE BOOKS ARE TO BE SHELVED TEXTBOOK-REQUIRED FLAG - USED ONLY WHEN NO (BOOKREC) TEXT IS REQUIRED FOR COURSE TIME-LIMIT-RETURN TIME LIMIT, IN DAYS, THAT (PUBLMSTR) BOOKS MAY BE RETURNED COST-PRICE COST PRICE OF BOOK (INVOICE) 4.0 PROGRAM DOCUMENTATION: --------------------- THE FOLLOWING SUMMARIZES THE PROGRAMS WHICH COMPRISE THE BOOKSTORE SUBSYSTEM: SCREENS ------- BKS010 ADD/UPDATE/DELETE BOOKS BKS020 BOOK INQUIRY BKS025 CHANGE RECORD NUMBER BKS030 INVENTORY UPDATE ONLINE BKS040 PURCHASE ORDER UPDATE BKS045 PURCHASE ORDER INQUIRY BKS050 INVOICE UPDATE BKS060 RETURN BOOKS BKS070 ADD/UPDATE/DELETE PUBLISHER BATCH UPDATES ------------- BKS300 COPY NEW QUARTER FROM PREVIOUS YEAR BKS350 PRINT PURCHASE ORDERS AND UPDATE BOOKSTORE DB BKS400 DELETE PREVIOUS QUARTERS BKS450 PRINT RETURN SLIPS BATCH REPORTS ------------- BKS500 BOOK REQUEST FORMS BKS510 BOOK LIST BKS520 LIST OF BOOKS BY PUBLISHER BKS530 LIST OF BOOKS BY DIVISION/DEPARTMENT BKS540 SUMMARY OF BOOK REQUESTS BKS550 PRINT PUBLISHER LIST BKS560 PRINT SHELF LABELS BKS570 CONVERTED ETXT510 (TEXTBOOK REQUEST LIST BY COURSE) BKS580 CONVERTED ETXT520 (BUY BACK LIST BY AUTHOR) BKS650 PRINT SELECTED PURCHASE ORDERS 5.0 INPLEMENTATION PROCEDURE: ------------------------ TO BE DEFINED. 8.0 CHANGE HISTORY -------------- 8.1 VERSION NO: V4.09 CHANGE DATE: 12/12/89 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION TO ADD PROGRAM BKS650 AND TO OMIT PROGRAM BKS080 FROM THE 4.0 PROGRAM DOCUMENTATION SECTION.