Database System Concepts

Description

• cours magistral
• cours - matière potentielle : organization

Database System Concepts Dr. Hisham Saied, 2007-2008 Faculty of Eng., Tanta University

• perface
• history of database research over the past 40 years
• relational language components
• basic sql query language
• database system concepts
• consistent data
• sql

Sujets

• Cours magistral
• Organization
• Hisham
• University of Tanta
• Kaufman
• Kaufmann
• Microsoft
• Database
• Language
• Relational

Informations

• Publié par: nosheng
• Nombre de lectures: 35
• Langue: English
• Poids de l'ouvrage: 5 Mo

Extrait

blackbaud’s solution for
Arts and Cultural
Organizations™Blackbaud’s Arts & Cultural Solutions Arts & Cultural Solution is the answer to all your ticketing, fundraising, membership, web site,
fnancial management, and retail sales needs. It is the only single, complete solution for all the various
operational and reporting needs of your fnance, development, and retail departments; visitors’ and admissions’
ofces; and box ofce.
“Since we started using Table Of Contents
®The Patron Edge Online, we
have seen our online sales Ticketing: Box Ofce and Visitor Services Management 1
grow 30 percent. We recently Online Ticketing 2
had one of our best selling Fundraising, Relationship Management, & Membership 4
shows in the history of the Accounting/Financial Management 7
theater, and I’m convinced Online Content Management 10
that we would not have been Retail Point of Sale 11
able to sell that many tickets
on the old system.”

— Sarah Coco,
Director of Patron Services,
Hartford Stage Company ticketing:
Box Ofce and Visitor Services Management
Te Patron Edge® is a comprehensive ticketing management solution specifcally
designed to help organizations that do general admission and reserved seating boost
attendance and increase revenue Te Patron Edge meets the specifc, complex
needs of busy box ofces and visitor centers In addition to tracking all the details
associated with building a strong relationship with each patron or visitor, Te Patron
The Patron Edge General Admission Edge gives ticketing professionals the tools they need to manage daily operations —
Sales Touch Screen
from selling tickets to tracking and reporting on those sales
manage ticketing operations:
|| Sell tickets quickly and efortlessly with user-friendly touch screens
|| Tailor the sales fow to meet your business needs for walk-up and
phone room sales
|| Efciently add multiple events, memberships, donations, renewals, and
merchandise to a virtual “shopping basket” for payment
|| Create and view fully customizable venue maps, best-available seat charts,
fxed-series seats, and more
|| Keep data current and allow staf access to biographical and demographic
information on customers, as well as purchase and payment histories
|| Save time with easy hall layout design, including theaters, classrooms,
and studios
|| Allow package funtionality and membership benefts that provide the ability
to give discounts automatically based on your business rules
boost ticket sales and cut expenses:
|| Capture all purchases by always being ready to sell and serve
|| Increase revenue with simple ticket design, allowing for additional
advertising opportunities with image printing on front and back
|| Improve productivity with customizable sales fow, user-defned screens,
and the ability to defne process based on business rules, as well as pop-up
summaries and recap information
|| Save money on direct mail by capturing current customer information
during any transaction
|| Share key biographical data across your fundraising and ticketing systems to
eliminate double data-entry and decrease overall cost
1build and strengthen relationships with patrons:
|| Personalize interaction with customers using bar-code scanning
|| Automate individual recognition and beneft association
|| Enable pop-up comments so box ofce staf are better able to personalize
interactions with key patrons, donors, and visitors
|| Provide convenient methods of purchase and communication (via the
Internet or kiosk)
demonstrate increased financial accountability,
fostering a positive community image:
|| Create custom reports to be housed within or outside Te Patron Edge®
using third-party reporting tools such as SQL Reporting Services and
Crystal Reports®
|| Combine donor and patron/visitor data for a complete history and
view of activity Te Patron Edge® Seat Map
|| Get a single view of patrons and donors
|| Eliminate unnecessary time and expense to fnd or share information
between your box ofce or visitor center and development ofce
| | Readily share ticket purchase and donor data with the interface between Te
Patron Edge and Te Raiser’s Edge®, Blackbaud’s award-winning fundraising
solution, regardless of which system initially received the information
|| Fine-tune your marketing eforts with a variety of marketing analysis reports
“We chose The Patron Edge
because it will not only Online Ticketing
handle our ticketing needs,
Your patrons want to buy tickets online, not in line! Once regarded as an ofering but it will also work hand-
of convenience that only large organizations could aford, online ticket sales in-hand with The Raiser’s
are now a necessity for general admission and reserved seating organizations Edge to provide a complete
of all sizes Today’s Web-savvy patrons and donors demand the convenience patron management
and control of selecting seats, purchasing tickets, renewing memberships, and solution. Blackbaud was the
making donations quickly and easily from the comfort of their homes and ofces only vendor that could meet
Furthermore, nonprofts recognize the benefts of online ticket sales in helping to our complex requirements
dramatically boost operational efciency and organizational reach, which results for both ticketing and
in lower costs and higher revenue development while helping
us best serve the people who
the patron edge online is an online ticketing solution care most deeply about
that can help your organization easily and systematically our mission.”
build its online presence. with it, you can:
— Brad Heiser,
Western Pennsylvania Conservancy || Drive revenue by setting and retaining all online per-ticket fees
(no extra fees to vendors)
2|| Reduce expenses and staf requirements by empowering your patrons and
donors to order tickets and update biographical information and interests in
real time with “self-service” functionality
|| Choose to sell live inventory via your Web site or limit online sales to a
segment of available seats
|| Accept memberships, series, and subscription sales and renewals
|| Instantly recognize and apply member privileges and discounts
|| Allow customers to choose their own seats with easy-to-understand seating
charts, without leaving single seats
|| Ofer “view from this seat or area” ability for customers to choose best-
available or self-selected seats
|| Give customers the ability to print tickets at home
|| Capture customer information and preferences; allow patrons to update
their memberships, demographic information, and interests in real time, and
apply benefts automatically
And best of all, Te Patron Edge® Online fully integrates with Te Patron Edge,
Sample Patron Edge Online Web Siteour back-end ticketing solution, to extend your ticketing operation to the Web

“Ticket sales are up since
we implemented The Patron
Edge Online; in fact, our
Internet sales have almost
doubled in one year. Online
sales in 2005 were 23% of our
total sales, whereas this year
they increased to 38%. One
component for increased
ticket sales overall is that we
are better able to handle the
volume of orders better than
ever before with The Patron
Edge and The Patron
Edge Online.”
— Dale Manning,
IS Manager,
American Players Theatre
3Fundraising, Relationship Management,
and Membership
Te Raiser’s Edge® puts the power of change in your hands Designed for
organizations of all shapes and sizes, it’s the trusted solution of more than 15,000
organizations worldwide
Te Raiser’s Edge works by giving you the tools you need to cultivate lifelong
Constituent Record in The Raiser’s Edge
relationships with patrons, save time and money by streamlining your important
daily processes, and demonstrate increased accountability Tink of an
investment in Te Raiser’s Edge as insurance for your organization’s future
with the raiser’s edge, you can:
|| Enjoy a complete view of relationships by recording every interaction you
“The Raiser’s Edge has have with patrons, donors, visitors, volunteers, prospects, and members
helped us build and maintain
|| Eliminate unnecessary time and expense required to locate or share
strong relationships with
information between your development ofce and box ofce or visitor center
our constituents by giving
by integrating with Te Patron Edge®, Blackbaud’s ticketing and admissions
us a complete view of their
management solution
interactions with us. It saves
|| Access and create detailed or summary reports for patrons, staf, us time and helps us run our
and board members business.”
— Laurie Conkerton,
|| Review snapshots of every aspect of your organization with
Vice President for Development,
“at-a-glance” reports Audobon Nature Institute,
New Orleans, LA
|| Give patrons the option of electronic, hassle-free giving online
24 hours a day/7 days a week
K