Each year Adventure Zone Amusements, headquartered in Calgary, Alberta, runs a major amusement park $($Wander Wonder$)$ in Southern Alberta. Adventure Zone Amusements has developed a growing customer base due to family$-$centered marketing, sensible cost$-$management $($avoiding new, expensive, unproven rides$)$ and innovative use of technology. Adventure Zone Amusements$$ president Angela Kurusugawa and the board of directors are championing a refresh of the company that will cover everything from their branding and marketing to their facilities and technology.

$$Let me describe my vision$,$ Angela said. $$For admissions, we will replace the traditional $$ticket$$ by adopting a computer$-$based RFID smartband system to use as passes. RFID smartbands, with a small scannable tag that contains the pass$$s ID number, will account for almost all sales. Each pass has a pass$-$type: from the pass$-$type we will know the initial credit balance. Each admission will then be a debit against the pass until it has no credit left. Our database will track passes and their associated admissions, but not tickets.$$

$$WanderWonder currently tracks $140$ attractions, which we identify by an AdventureZone$-$generated ID number $($only $100$ attractions are active at any one time$).$ For each attraction, we track its manufacturer$$s name, descriptive name, gross weight $($in kilograms$),$ minimum height for a child to ride and quantity of credits needed for admission, as well as an attraction$-$type code, which will be one of: rida $($adult ride$),$ prea $($premium adult ride$),$ ridc $($child ride$),$ prec $($premium child ride$),$ dsen $($display for entertainment$),$ dsps $($display for public service$)$ and spcn $($special concert$).$ For each of these seven attraction$-$types, we track whether or not it is tax$-$deferred.

$$Passes are one of ten types, as shown in the table below. Initial balance can be credits or rides, depending on the type of pass...$$

Pass type code Pass type description Initial balance Suggested list price Days before expiry

smca small credit$-$pass: adult attractions $1510\mathrm{.}000$

lgca large credit$-$pass: adult attractions $5030\mathrm{.}002$

smcc small credit$-$pass: child attractions only $157\mathrm{.}000$

lgcc large credit$-$pass: child attractions only $5020\mathrm{.}002$

mdrc medium ride$-$pass: child rides only $3030\mathrm{.}001$

mddc medium ride$-$pass: displays and concerts only $5050\mathrm{.}001$

daa day$-$pass: adult attractions $999999965\mathrm{.}000$

dac day$-$pass: child attractions only $999999950\mathrm{.}000$

wka week$-$pass: adult attractions $9999999340\mathrm{.}006$

wkc week$-$pass: child attractions only $9999999240\mathrm{.}006$

$$Passes can be purchased in the park from any of the kiosks $(20$ in total$)$ we track each kiosk$$s AdventureZone$-$created ID number, its location on the park grid, the minimum number of staff for the kiosk, the amount of electricity watts needed by the kiosk for signage and also the watts needed for interior lighting. For each pass purchased, the kiosk # and selling employee$$s ID # are recorded. Also, the customer can optionally fill out a form $($rarely done except for more expensive passes$)$ including their family name, given names, email address, $$snail mail$$ address $($which involves five fields: two separate $$address$$ lines as well as municipality, province$\_$state and postal$\_$code$)$ as well as the estimated number of monthly park visits. In response to that form, a customer ID number is also created. Our database currently tracks $3400$ customers.$$

$$Whether or not the customer submits a form, they can use their pass for admission to attractions. The admitting employee will pass an electronic reader over their pass and can instantly tell if the pass has sufficient credit remaining and if the pass$-$type is denied from admission to the chosen type of attraction. Note: all types of passes allow admission to all types of attractions, except for those $35$ or so combinations recorded as $$denials$$ for example: in one denial, a small child$-$ride pass$-$type $($smcc$)$ is denied admission to regular adult rides $($rida$).$ Whenever a particular pass$-$type $/$ attraction$-$type combination is to be denied, it is also given a denial ID number, a denial begin$-$date and possibly an end$-$date.$$

If the customer$$s pass is not denied and has sufficient credit, then the database records the admission. That admission is included in calculating the $$total credits used$$ for any future use of the pass. If a customer ever challenges the correctness of the computer records about his pass, one of the kiosks can print out a pass$-$report, something like the three admissions for pass $27311,$ below:$$

Pass #: $\_\_27311\_$ Purchase Date: $\_2021-$Aug$-23\_$ Cancelled Date: $\_\_\_\_\_\_\_\_\_\_\_\_$ Selling Kiosk #: $\_17\_$ Selling Emp#:

$\_102\_$ Cust #: $\_\_701\_\_\_$ Cust Name: $\_$Peters, Joe$\_$

Pass Type: $\_\_$lgca$\_\_$ Initial Balance: $\_\_\_50\_$

Admission# Attraction# Attraction

Name Admitting Emp# Admission

Date$-$Time Cancelled Date$-$Time Credits

$3140917146$ Zipper $1198/23/2021-19$:$574$

$314092311$ Sky Launcher $1048/23/2021-20$:$1230$

$314092947$ Dragon Coas