TECHNICAL EDUCATION AND SKILLS DEVELOPMENT AUTHORITY
National Assessment for
PROGRAMMING NC IV (COC 1 DEVELOP OBJECT – ORIENTED APPLICATION)
INSTRUCTIONS TO THE CANDIDATE
INSTRUCTION FOR THE CANDIDATE Qualification
Programming NC IV
Certificate of Competency Title:
Develop Object Oriented Ori ented Application
PART I. Designing Program Logic A. Perfor Performan mance ce Crit Criteri eria a In developing the design, the following items must be executed: •
•
• •
•
•
•
• • • • • •
Determines design approach to be taken in coding and the modules and links required is determined Structures diagrams of program flow and modules according to project standards Documents program scope and limits according to project standards Documents or references special routines or procedures according to project standards Identifies and revises references for tables, files, inputs, outputs, and other program functionalities according to program r equirements Chec Checks ks prog progra ram m flow flow,, stat states es or cond condit itio ions ns for for inte interf rfac aces es and and compliance to design documentation requirements Dete Determi rmine nes s prog progra ram m activ activiti ities es and and sele select cts s appr approp opria riate te prog progra ram m development approach Creates an initial plan to guide the program development process Uses documentation tool for program development Draws program structure and organization Defines and uses proper naming conventions Documents input and output forms accordingly Documents program flow and processes accordingly
B. Requir Required ed Evide Evidence nce Program logic design C. Collection of Evidence
The collection of evidence for this activity will be done through analysis of the program logic design you submitted. Questioning shall be conducted to reinforce the evidence collected from this demonstration. D. Time Time Allo Allotm tmen entt You have one (1) hour to complete the activity
ICTPRG405-0609
2
E. Asse Assess ssme ment nt Tas Tasks ks 1. Develo velop p and illu illus stra trate the the pro progra gram logi logic c for for the the “Se “Search rch Boo Book Collection Facility” and “Log in Facility”. You may use any of the following tools to demonstrate the required performances (refer (refer to Performance Criteria for more details). details). o Flow chart o Data flow o Pseudo code 2. List the input inputs, s, variables variables and and outputs outputs of those those you will will be incorpora incorporating ting in your design. 3. Refer Refer to projec projectt descri descripti ption on for the TESDA TESDA Learning Learning Resourc Resource e Center Center Application for more details. PART II. Writing Program Code A. Perfor Performan mance ce Crit Criteri eria a In developing the design, the following items must be executed: •
• •
• • • • • • •
•
• •
• •
• •
ICTPRG405-0609
Observes basic language syntax rules and best practices Uses language data-types, operators and expressions Uses appropriate language syntax for sequence, selection and iteration constructs Uses modular programming approach Uses arrays and arrays of objects Implements class that contains primitive member/instance variables Implements class that contains multiple options for object construction Uses class user defined aggregation Implements inheritance to at least 2 levels of depth Uses polymorphism at a simple level through inheritance to enable easy code extension Uses Uses an inte integr grat ated ed deve develo lopm pmen entt envi enviro ronm nmen ent, t, part partic icul ular arly ly the the language debugging facilities Uses program debugging techniques to detect and resolve errors Follows guidelines for developing maintainable code adhering to a set of coding standard Follows and uses internal documentation standards and tools Devel Develop ops s and conduc conducts ts simple simple tests tests to confi confirm rm the coding coding proce process ss meets design specification Documents tests performed Makes corrections to the code and the documentation as needed
3
B. Requir Required ed Evide Evidence nce Program code C. Collec Collectio tion n of Eviden Evidence ce The collection of evidence for this activity will be done by analyzing and testing the program code you submitted. The more set/sub-systems you accomp accomplis lished hed,, the better better your your chance chances s of demon demonstr strati ating ng the require required d perf perfo orma rmance nces. The The coll colle ected ted evide idence nce shall hall be valid lid only nly if the the progra program/su m/sub-s b-syst ystem em is runnin running g accor accordin ding g to the design design specif specifica icatio tion. n. Questioning shall be conducted to reinforce the evidence collected from this demonstration. D. Time Time Allo Allotm tmen entt You have five (5) hours to complete the activity E. Assessment Tasks
1st Set 1. Indicate the language of your preference ___________________________ _______________________________. ____.
for
this
activity.
2. Chec Check k your your work workst stat atio ion. n. Your our work workst stat atio ion n will will have have a vari variet ety y of Integ Integrat rated ed Devel Developm opmen entt Envir Environm onment ents s (IDE) (IDE) for variou various s langua language ge however if you opt to use another IDE, make arrangement with your assessor. 3. Demonstrate the required performance for this assessment activity by
writing the program code for the “Search Book Collection” and “Log in” Facility (refer to Performance Criteria for more details). Make sure that you design your code as re-usable as possible for the proceeding set of activities. 4. You You may may use use and and enha enhanc nce/ e/mo modi dify fy the the data databa base se incl includ uded ed in this this package (library.mdb) or you may create your own. 5. Run Run the the test test case case scen scenar ario io (Tes (Testt Case Cases s #1) #1) usin using g your your prog progra ram. m.
Debug if needed. 6. Refer Refer to projec projectt descri descripti ption on for the TESDA TESDA Learning Learning Resourc Resource e Center Center Application for more details. 7. When you are sure that your application is running as required in the
project description, call the attention of your assessor and submit your project.
ICTPRG405-0609
4
2nd Set 1. Make a second copy of the project from the 1st Set. 2. Improve Improve your your project project by writing writing a code for for the following following sub-sys sub-systems: tems: a. Rese Reserva rvatio tion n faci facilit lity y b. Borrow Borrow transact transaction ion facility facility (through (through reser reservation vation)) c. Retu Return rn faci facili lity ty d. Borro Borrow w transac transaction tion facili facility( ty(man manual ual)) 3. Run Run the the test test case case scen scenar ario io (Tes (Testt Case Cases s #2) #2) usin using g your your prog progra ram. m. Debug if needed. 4. Refer Refer to projec projectt descri descripti ption on for the TESDA TESDA Learning Learning Resourc Resource e Center Center Application for more details. 5. When you are sure that your application is running as required in the
project description, call the attention of your assessor and submit your project.
ICTPRG405-0609
5
TESDA Electronic Learning Resource Center
Test Cases #1 Case 1: Open the TESDA Electronic Library Application, the first panel that you should see is the Search and Reserve Facility. There should be forty five (45) titles from the book collection. Case 2: Filter the book collection, set the category to “databases” then click search. The collection should be limited to twelve (12) titles. Case 3: Filter the book collection, collection, set the category category to “databases.” In the title textbox enter “Microsoft” then click search. The collection should be limited to six (6) titles. Case 4: Filter the book collection, collection, set the category category to “databases.” In the title textbox enter “Microsoft” and in the author textbox enter, “Lisa.” Then click search. The collection should be limited to two (2) titles. Case 5: Filter the book collection, collection, set the category category to “databases.” In the title textbox enter “Microsoft” and in the author textbox enter, “Lisa” and in the ISBN textbox “0324785151” then click search. The collection should be lim ited to one (1) title. Case 6: Filter the book collection, set the category to “All” clear all the textboxes except the ISBN textbox, enter “0324785151” then click search. The collection should be limited to one (1) title.
Case 7: 1. Click log in button button,, the log in panel panel should should appear appear in modal modal mode. mode.
2. Log Log in to the the sy syst stem em Username: admin Password: administrator 3. Your progr program am should should generate generate the the following following output: output: “Sorry invalid username or password”
TESDA Electronic Learning Resource Center
Test Cases #1 Case 8: 1. Click log in button button,, the log in panel panel should should appear appear in modal modal mode. mode.
2. Log Log in to the the sy syst stem em Username: admin Password: admin 3. Your progr program am should should generate generate the the following following output: output: Welcome Josephine!
4. Then Then the log in in panel panel will will close. close. 5. Once logged in, you should be redirected to administrator facilities,
Borrow transaction pane to be exact. In the panel, the account information should display,”Welcome Josephine! You are logged in as administrator” administrator”. .
6. Logou Logoutt to the system system.. 7. Once logout the account information inf ormation on the administrator’s panel
should display, “Welcome guest!” Case 9 1. Click log in button button,, the log in panel panel should should appear appear in modal modal mode. mode.
2. Log Log in to the the sy syst stem em Username: brian Password: b 3. Your progr program am should should generate generate the the following following output: output: Welcome Brian!
4. Then the system system will redirect redirect the user user to the member’s member’s panel panel 5. Once logged in, account information i nformation on the member’s panel should
display, “Welcome Brian! You are logged in as member”. The cart panel should also become active. 6. Logou Logoutt to the system system.. 7. Once logout the account information inf ormation on the member’s’ panel should
display, “Welcome guest!” The cart cart panel panel should should be inactive. inactive.
TESDA Electronic Learning Resource Center
Test Cases #1 Case 10: 1. Click log in button button,, the log in panel panel should should appear appear in modal modal mode. mode.
2. Log Log in to the the sy syst stem em Username: lorna Password: l 3. Your progr program am should should generate generate the the following following output: output: “Sorry your account is currently inactive. Please update your membership account before you can continue.”
4. When When you close the me message ssage box, box, the system should should autom automatically atically clear the inputs from f rom the password.
TESDA Electronic Learning Resource Center
Test Cases #2 Case 11: 1. Log Log in to the the sy syst stem em Username: Username: brian Password: b
2. Add the the books books with the followin following g ISBN to your your cart cart a. 0826906311 b. 2002102792 3. Remove the book with ISBN 2002102792 from the cart.
4. Your applicat application ion should should confirm the removal removal of the title title from the list. list.
5. Reserve Reserve the remaining remaining title title to your your account account..
6. Your application application should should generate generate the the output output “You reserved books in your account.”
Case 12: 1. Using Using the same same accou account nt Username: Username: brian Password: b
2. Reserve Reserve the the following following book to your your account account a. 0826906311 b. 2002102792 3. Remove the book with ISBN 2002102792 from the cart.
4. Your applicat application ion should should confirm the removal removal of the title title from the list. list.
5. Reserve Reserve the remaining remaining title title to your your account account..
6. Your application application should should generate generate the the output output “You reserved books in your account.”
TESDA Electronic Learning Resource Center
Test Cases #2 Case 13: 1. Using Using the same same accou account nt Username: Username: brian Password: b
2. Reserve Reserve the the following following book to your your account account a. 0826906311 b. 2002102792 3. Remove the book with ISBN 2002102792 from the cart.
4. Your applicat application ion should should confirm the removal removal of the title title from the list. list.
5. Reserve Reserve the remaining remaining title title to your your account account..
6. Your application application should should generate generate the the output output “You reserved books in your account.”
7. Log Log out out to Brian Brian’s ’s acc accou ount nt
Case 14: 1. Log in to admi adminis nistra trato tor’s r’s accou account nt Username: admin Password: admin 2. Go to borrow transaction manual entry tab and search the book with
ISBN 0766813916 3. Add the book to the cart then lend the book to Agnes with members
ID 7 4. Your application application should should generate generate the the output output “You lend the book to .”
5. Then it should should generate generate a printable printable output output of the transact transaction. ion.
TESDA Electronic Learning Resource Center
Test Cases #2 Case 15: 1. Using Using the same same accou account nt Username: admin Password: admin
2. Borrow Borrow transactio transaction n reserva reservation tion tab 3. Look for the member’s ID No. 2
4. Your applicat application ion should should display the the reservatio reservation n made by Brian. Brian. 5. Lend the book to Brian 6. Your application application should should generate generate the the output output “You lend the book to .”
7. Then it should should generate generate a printable printable output output of the transact transaction. ion. Case 16: 1. Using Using the same same accou account nt Username: admin Password: admin
2. Go to retu return rn tran transac sactio tion n 3. Look for the member’s ID No. 7 4. The system system should should display display a book title with with an ISBN 07668139 0766813916 16
5. Retu Return rn the the boo book k 6. Your application application should should generate generate the the output output “ by .”
7. Then it should should generate generate a printable printable output output of the transact transaction. ion.
Project Description TESDA Learning Resource Center Application Test Project for the Develop Object Oriented Application.
© 2009 TESDA
Table of Contents TECHNICA TECH NICAL L EDUCA EDUCATION TION AND SKILL SKILLS S DEVELO DEVELOPME PMENT NT AUTH AUTHORITY ORITY.......... .............. ....... ... 1 Qualificatio Qualif ication n................................. ..................................................................... ................................................................ ............................2 2 Programming Programm ing NC IV....... .............. .............. .............. ............... ............... .............. .............. .............. ............... ............ ........ ........ ...... ..2 2 Certificate Certi ficate of Com Competen petency cy Title: ................................... ......................................................... .............................. ........2 2 Develop Object Oriented Application....... .............. ............... ............... .............. .............. .............. ............ ......... ......2 Table of Content Contents s................................... ....................................................................... ............................................... .................. .......1 1 Overview of the Project........ ............... .............. .............. .............. ............... ............... .............. ............ ......... ........ ........ ........ ......1 Technical Tech nical Specifica Specifications tions.................................. ........................................................................ ............................................. .......1 1 Environm Envir onment ent................................ ............................................................................... .......................................................... .............. ...1 1 Users User s................................................ ................................................................................. ............................................ ..................... ............ ..1 1 Policies Policie s................................. ..................................................................... ..................................................................... .................................2 Sub-syste Sub-s ystems ms...................................................................... ................................................................................. ...................... .............3 Transactio Trans actions ns................................... ........................................................................ ................................................ ................... ........15 15 Database Design....... .............. ............... ............... .............. .............. .............. ............... ............... .............. ............ ......... ........ ....16 16
© 2009 TESDA All Rights Reserved Reserved
Overview of the Project The TESDA Learning Resource Center, formerly known as Information and Documentation Services (INFODOS) is currently under the supervision of the Qualifications and Standards Office. Its main function is to support the research and training objective of the agency by providing resources and information. Currently, it is serving policy makers, school administrators, trainers, teachers, curriculum developers, students, workers, employers and others. The number of clients served by the center has doubled yearly from its first year of operation. It started with an average of twenty (20) clients per day. Now after 5 years of operation, it is serving an average of eighty (80) clients per day. The center is currently operating using manual m anual recording of transaction method which results in poor services and operations for its clients. As a solution, the management decided to commission programmers to design an automated system for the center that will be used for the next fi ve (5) years of operation.
Technical Specifications Environment The application to be developed should be a stand-alone desktop application and in graphical user interface (GUI) mode.
Users The system shall have following users: 1. Ad Admi mini nist stra rato torr
Administrator is the custodian or manager manager of the center. The tasks of the administrator are: a. b. c. d. e. f. g.
Add, delet delete e or modify modify titles titles from from the book book collect collection ion Add, susp suspend end,, activate activate or or revoke memb membersh ership ip Acknowle Acknowledge dge borrowed borrowed and retu returne rned d books books Canc Cancel el rese reserv rvat atio ion n Prepare transaction transaction reports for borrowed borrowed and returned books Prepare Prepare daily collect collection ion report report for for overdu overdue e fee fee Prepar Prepare e inven invento tory ry repo reports rts
2. Member
Member is a registered user. The privileges of a member are: a. He/she He/she can can view the the book book collectio collection n of the cent center er b. He/she can make make reservation reservation in borrowing borrowing books (books for pickup) c. He/she He/she can borrow borrow books books from from the the center center
© 2009 TESDA All Rights Reserved Reserved
Page|1
3. Guests
Guests are non-registered clients of the center. They can view or search the book collection of the center; however they cannot borrow a book.
Policies The system will be operating under following policies: 1. Rese Reserv rvat atio ion n Polic Policy y a. Only active members can make the reservation reservation of the the title b. Maximum of three books can be reserved by particular particular member, member, unless otherwise a new policy for allowable number of books to be borrowed is approved. c. Reservation Reservation is valid only for for twenty-four twenty-four (24) hours, unless otherwise a new policy on validity of reservation is approved. 2. Borr Borrow owin ing g Pol Polic icy y a. Only active active members members can borrow borrow books. books. b. One day/Overnig day/Overnight ht borrow borrow policy. policy. In In case of overdue overdue a fine fine of twenty pesos per day (Php 20.00/day) will be charged, unless otherwise a new policy on overdue fee is approved. c. Members who lost lost books books shall shall be fined with with exact cost of the book. d. Books can be borrowed only if stocks are available available (reserved (reserved books are considered borrowed unless the reservation has expired) e. Number of books books that can be borrowed by a particular particular member should be the same as the set maximum number of books allowed in the reservation. 3. Memb Member ersh ship ip Poli Policy cy a. All members members are required to register register (see registration registration form form for more details) b. Each member will be provided with unique unique identification identification number c. Membership Membership will expire one year year from the date date of registration registration unless otherwise new membership policy is approved. d. Renewal of membership membership is allowed. allowed. The The member member who will be availing this privilege will retain their original identification number. e. Members are inactive inactive when their membersh membership ip are expired or revoked.
© 2009 TESDA All Rights Reserved Reserved
Page|2
Sub-systems 1. Search Search Book Collectio Collection n Facility Facility a. Main Main Feat Featur ures es
This facility should have the following main features: •
•
Interface that allows user to browse through the book collection and display the following information: o Title of book o ISBN o Author o Abstract o Book Availability (Available/Not Available) Interface that filter the collection according to: o Category o Title o Author o ISBN
b. Interf terfa ace
The illustration below is the prescribed layout for the project.
5 6 1
3
Abstract
2
© 2009 TESDA All Rights Reserved Reserved
4
Page|3
c. Des Descrip cripti tio on
This interface is the first panel you will see when the electronic library is opened. This allows guest (not logged in user) to browse through the book collection. •
•
•
•
•
•
Book information panel (1) – This shows detailed information about a particular book in the collection. Navigation button (2) - There should be a navigation control that allows user to browse through the collection. Filter panel (3) – This input interface allows user to narrow down the book collection by providing the specific book category and key words from the book title and author. When ISBN entry has been provided, the search filter will focus only on the ISBN entry. Button (4) – This button is inactive while the user is not logged into the system. Details of this button are described under the reservation facility. Log in button (5) – This is the button that calls the log in interface of the system. “Search and Reserve” and Transaction Tab Control (6) – This allows allows user user to switch between the two panels however the transaction panel is not yet enabled at this stage.
2. Log Log in in Fac Facil ilit ity y a. Features
This facility should have the following features: •
The interface interface should accept only the the following following inputs: inputs: o Username o Password o Execute command o Cancel command
•
The interface interface should should automatically automatically detect the following following based on the username and password submitted: o o o
•
The interface interface should should automatically automatically filter the the following following o o
© 2009 TESDA All Rights Reserved Reserved
Validation of user Role of the user Validity of account (active in active)
Invalid username and password Inactive account
Page|4
b. Interf terfa ace
The illustrations below are the prescribed layout for the project. 3 1
Abstract
2
4
Abstract
5
© 2009 TESDA All Rights Reserved Reserved
Page|5
c. Des Descrip cripti tio on •
•
•
•
•
Log in/Log out button (1) – Initially the text in this button indicates “Log in”. This is used to call and show the log in panel. Once the user successfully logged in to the system, the text in this button will indicate log out. This button is now used to log out a user to the system. Log in panel (2) – This interface is where the user inputs the user account and executes the user validation process of the system (checking of authenticity of the user account and validity of membership). After the process it should render the following output: o Message box indicating the message “Welcome ” for valid user account o Message box indicating the message “Sorry invalid username or password” for invalid account entry. o Message box indicating “Sorry your account is currently inactive. Please update your membership account before you can continue.” Account information (3) – This indicates the first name and role of the logged user. It displays “Welcome Guest” with no user role if the current user has not logged into the system. Members Panel (4) – This is the same form with the guest panel. The difference is that there are elements of the form that is active once the member logs in. Administrator Panel (5) – This form is called and displayed when an administrator logs into the system. Elements of this panel is described under the borrow transaction facility.
3. Reserv Reservat atio ion n Facili Facility ty a. Features This facility facility is available only for members. members. It should should have the the following features: •
•
• •
•
© 2009 TESDA All Rights Reserved Reserved
The interface interface is active only when when the member is logged logged into the system. Derives the book to be borrowed from the search facility and stores the information into an electronic cart. Books included into the cart can be deleted from the list Automatic feedback indicating the number of books reserved through message box. Limit automatically the number of books that can be reserved by the user.
Page|6
b. Interf terfa ace
The illustration below is the prescribed layout for the project.
Abstract
1 2
3 4
c. Des Descrip cripti tio on •
•
•
•
© 2009 TESDA All Rights Reserved Reserved
Add to cart button (1) – Active only when a member logs in to the system. This control is used to add the current book in the book information panel to the cart panel. Cart panel (2) – This control is active only once the member logs into the system. This interface holds the list of the books selected from the collection. Remove selected book button (3) – This control removes the selected book from the cart. Reserve listed book button (4) – This control adds the books from the cart into the system database as reserved to the current member. Once a reservation has been made, the system will feedback “You reserved books in your account.”
Page|7
4. Borrowing Transaction Transaction Facility (Through (Through Reservation) Reservation) a. Features •
•
•
The system system should should have have an interface that allows allows searching searching of users that made book reservation via entry of member’s ID number. Books from the reserved list can be removed. Allows transfer of books from the reservation record into the borrow record.
•
Monitor the number of the borrowed book by the member.
•
Provide automatic feedback of the following: o The member member exceeds exceeds the allowable allowable number of books
that can be borrowed. o
Printable report on the transaction made.
b. Interf terfa ace
The illustrations below are the prescribed layout for the project.
1 2
3
© 2009 TESDA All Rights Reserved Reserved
Page|8
4
c. Des Descrip cripti tio on •
•
•
•
Borrow Transaction Tab (1) – Activate the panel for managing the borrow transaction. From Reservation Tab (2) – Activate the panel for searching reservation transaction record via entry of member’s ID number. List of reserved books (3) – This control displays the books reserved by the owner of the ID number. Books listed from here can be deleted or transferred to the borrow records. Generated printable report (4) – This report is generated once the “Lend listed item” button is clicked. This serves as proof that a borrow transaction has undertaken. Information indicated here are the following: o
Date borrowed
o
Due date
o Transaction Transaction number
© 2009 TESDA All Rights Reserved Reserved
o
List of books borrowed
o
Name of member
o
Member’s ID number
Page|9
5. Borrowin Borrowing g Transacti Transaction on Facilit Facility y (Manual (Manual Mode) Mode) a. Features This facility facility is similar with with the the search reservation facility. The differences are the following: •
•
•
This panel panel belongs belongs to administrator’ administrator’s s facilities facilities while while the reserve facility belongs to member’s facility. Instead of adding the listed book to the reservation records, it is added directly to the borrow facility. It generates feedback such as: o
Confirmation of member’s ID number
o The member member exceeds exceeds the allowable allowable number of books
that can be borrowed. o
Printable report on the transaction made.
b. Interf terfa ace
The illustrations below are the prescribed layout for the project.
1
2
© 2009 TESDA All Rights Reserved Reserved
Page|10
3
c. Des Descrip cripti tio on •
•
•
Add to cart button (1) – add the current book in the book information panel to the cart panel. Lend listed books (2) – transfer the listed books to the borrow records. Member’s ID confirmation box (3) – this panel asks the user of the ID number of the borrower.
Generated printable report (4) – This report is generated as proof that a borrow transaction has undertaken. 6. Retu Return rn Faci Facili lity ty •
a. Features This facility facility allows allows the the administrator administrator manage the book book return return transaction. It should have the following features: •
•
The panel panel should should have have a search search interface that can can be used in looking for the record of the member returning the book. There should should be be an interface that provides option for return transaction such as: o o o
•
•
© 2009 TESDA All Rights Reserved Reserved
Return only Pay overdue penalty only Pay overdue penalty and return
The system system should should generate report of the transaction transaction made made Automatically computes the individual book overdue and total overdue collectibles per transaction.
Page|11
b. Interf terfa ace
The illustrations below are the prescribed layout for the project.
1 2 3
4
5
6
© 2009 TESDA All Rights Reserved Reserved
Page|12
7
c. Des Descrip cripti tio on •
•
•
•
•
•
© 2009 TESDA All Rights Reserved Reserved
Return transaction tab (1) – This control activates the return transaction panel. Search member’s record interface (2) – This control can be used in looking for borrow and return transaction record of the member via entry of ID number. List of borrow and return transaction record(3) – This control displays the record of returned books with the following status: o
Returned book with unpaid penalty
o
Unreturned books with overdue penalty
o
Unreturned books without overdue penalty
Return option (4) – Allows user to set the type of transaction: o
Return only
o
Pay overdue only
o
Return and pay overdue
Add selected item (5) – Calls and shows the return transaction panel. Every time this button is clicked, the selected item from the list of transaction record is added to the return transaction list. Return transaction list (6) - Displays the list of books to be returned/paid. When process button is clicked returned items with no zero penalty will be marked Status-O K. This will remove the item from the the record of return transaction. Page|13
•
Generated printable transaction report (7) – Upon clicking the process button, the system will generate a printable output of the return transaction.
7. Member Member Transa Transactio ction n Record Recording ing Facili Facility ty a. Features This panel panel displays displays the unsettled unsettled personal transaction transaction of the member as reminder of their obligations.
b. Interf terfa ace
1
2
c. Des Descrip cripti tio on •
•
© 2009 TESDA All Rights Reserved Reserved
Transaction Transaction record record tab tab (1) (1) – This control is active only if the member log’s into the system. It is used to display the personal transaction record of the member. List of transaction record(2) - This control displays the list of unsettled transactions such as: o
Unreturned books without penalty
o
Unreturned books with penalty
o
Returned book with unsettled penalty.
Page|14
8. Collec Collectio tion n Main Mainten tenan ance ce
The maintenance facility of the book collection is not included in this project. 9. User User Mai Maint nten enan ance ce
The maintenance facility for user is not included in this project.
Transactions a. Borrowing
The administrator will register the books borrowed by the member. There are two ways of registering the books to be borrowed: (1) through manual entry of ISBN; (2) through the reservation records of the member. The maximum number of books that can be borrowed in one transaction is based on the borrowing policy. The system should record the name of borrower, the books borrowed, ISBN, transaction number and the date borrowed. b. Retu eturnin rning g
The administrator needs to acknowledge the return of the books. Books from single borrowing transaction can be returned on individual returning transaction. The system should record the name of borrower, the borrowing transaction number, title of book, date the book returned and status of return transaction. Status of return transaction can be: o
Return the book without penalty (Status OK)
o
Return the book with unsettled penalty
o
Unreturned book without penalty
o
Unreturned book with penalty
c. Rese eserva rvatio tion
The member can reserve the title of the book to be borrowed. The reservation policy should be strictly followed in this function. The system should record the name of borrower, the books borrowed, ISBN, transaction number and the date reserved
© 2009 TESDA All Rights Reserved Reserved
Page|15
Database Design Below is the proposed database design for the system
© 2009 TESDA All Rights Reserved Reserved
Page|16