Location: [CPSC 333] [Lab Exercise] [Previous Exercise] [Next Exercise] Exercise #6
The following exercise will be taken up in labs on February 26-27. If at all possible, you should try to solve these problems ahead of time, so that you can compare your own solutions to the ones presented during labs, or have questions ready to ask in case you had trouble solving them.
The first question is based on material presented in class on February 19, and the second is based on material presented in class on February 21.
Consider the simplified Library Information System. An entity-relationship diagram (and its data dictionary), and an event list are already available. A leveled set of data flow diagrams will soon be available as well, but they aren't really needed for this exercise.
Consider the event
Event Number: 11
Event Name: Loan is Renewed
Inputs: (Complete) ISBN number
Outputs: due date, status message
Error Conditions:
- Syntactically incorrect input
- ISBN number is not in use
- Corresponding book is not out on loan
Note, as well, that while ISBN number was defined to be a nine-digit long positive integer, a ``complete'' ISBN number is actually a string of length ten. The first nine characters in the string are digits - so that they represent a nine-digit integer - and the tenth character is either a digit or the letter ``X.'' This is a ``check'' symbol, that represents a function (mod 11) of the first nine digits, and is used for error checking.
Try to identify a set of tests corresponding to requirements for the above event, that you would include in a ``test plan'' that is part of a requirements specification for this system.
Produce a layout for a set of data tables corresponding to this system's entity-relationship diagram and its data dictionary.
Location: [CPSC333] [Lab Exercises] [Previous Exercise] [Next Exercise] [Exercise #6]