Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

"PE 4-8. Consider the following narrative (initially introduced in PE 2-8):
            Copies ’R’ Us (CRU) is a copy shop and office service center operating in downtown Boston. To be able to compete with the large chains, CRU is open twenty-four hours per day and offers a wide variety of printing and image processing services at affordable prices and with friendly service.
            CRU divides its main products and services into categories (such as black/white copies, color copies, collating, binding, computer usage, faxing, etc.). A large number of products and services belong to each category, and the categories, products, and allocation of products to categories change dynamically. A job consists of all products and services that a customer orders at the same time (for example, a marketing brochure job could consist of color copies, collating, folding, and binding). Currently, a customer comes to an agreement regarding the required job(s) with the service representative, who creates a service ticket that CRU technicians will use to perform the work. It is important that the system maintains information about the time when each job was entered into the system and details describing all the components of the job and any special requirements the job has. CRU maintains a priority order for the jobs. This order is normally based on the time a job was registered to the system, but the store manager on duty can override the priorities.
            CRU serves both individual and business customers. All business customers are identified by CRU before they can attain business-customer status, which allows them to be invoiced for the work they have requested CRU to perform. Each business customer negotiates a separate discount percentage for each of CRU’s product categories. CRU does not always know the identities of individual customers, but it encourages its customers to get a Most Valued Customer (MVC) card, which gives its holders volume discounts, depending on the amount of work they request CRU to perform annually. Getting an MVC card, of course, requires the customer to provide CRU with his contact information. Individual customers pay for their purchases at the time they pick up their jobs (either by cash or credit card); as mentioned earlier, business customers can also be invoiced periodically (e.g., once a month), and thus one invoice can cover multiple jobs.
            CRU has several resources that cannot be used by more than one customer at a time (such as a couple of conference rooms with videoconferencing capabilities and several computers). CRU needs to maintain reservations for these resources. Business customers can make multiple reservations. Only individual customers with the MVC card can make reservations at all, and an MVC customer can have only one reservation at a time.
            Use this domain Links to an external site.model in creating the UI models.
              A. Identify (with a brief label) all user stories and write out at least one of them (if any exist) for each of the following personas in the context of this narrative:
              a. Copies ’R’ Us individual customer
              b. Copies ’R’ Us business customer
              c. Copies ’R’ Us representative
              d. Copies ’R’ Us technician
              B. For each of these user stories, develop wireframe(s) that illustrate the key elements of the process the user will follow to achieve her/his goal(s) within the context of the user story. Illustrate the key navigation options between the wireframes.
              C. For each user story, select one wireframe and expand it to a mock-up by including the key controls and sample data.

RESERVATION
Reservation id
Reservation date
Special instructions
Start time
End time
Uses
RESOURCE
i
Resource
Resource name
Hourly rate
Resource type
COPIES
B/W price
Paper size
Quantity per box
Price
Color price
MVC #
YTD Sales
INDIVIDUAL
Discount rate
Member since
Product name
Product price
BUSINESS
Partnership ID
PRODUCT
Label height
Quantity par box
ADDRESS LABELS
Labels per sheet
Label width
Item
Item type
Customer id
Customer name
Customer type
id
End time
Start time
Service name
SERVICE
CUSTOMER
ITEM
LETTER HEADS
Pagety 5 box / 7
Quantity per box
-Bled via-
Job entry date and time
Agreed by
Priority
Amount
BUSINESS CARD
Business card size
Quantity per box
Business card type
Fold type
Price
-Contained-
TECHNICIAN
Technician id
Technician name
Assigned to (Technician skills)
BINDING
Spine type
Spine color
Cover type
Price per 100
DANIY MOKG SSIAMENT
CUSTOM NOTEPAD
Note par size
Quantity per box
Price
Billed
INVOICE
Invoice number
Invoice date
Discount offered
Amount due
Invoice total
expand button
Transcribed Image Text:RESERVATION Reservation id Reservation date Special instructions Start time End time Uses RESOURCE i Resource Resource name Hourly rate Resource type COPIES B/W price Paper size Quantity per box Price Color price MVC # YTD Sales INDIVIDUAL Discount rate Member since Product name Product price BUSINESS Partnership ID PRODUCT Label height Quantity par box ADDRESS LABELS Labels per sheet Label width Item Item type Customer id Customer name Customer type id End time Start time Service name SERVICE CUSTOMER ITEM LETTER HEADS Pagety 5 box / 7 Quantity per box -Bled via- Job entry date and time Agreed by Priority Amount BUSINESS CARD Business card size Quantity per box Business card type Fold type Price -Contained- TECHNICIAN Technician id Technician name Assigned to (Technician skills) BINDING Spine type Spine color Cover type Price per 100 DANIY MOKG SSIAMENT CUSTOM NOTEPAD Note par size Quantity per box Price Billed INVOICE Invoice number Invoice date Discount offered Amount due Invoice total
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education