UD Events

1
UD Events Solution Package
2
Integrated Solution
code
1,N
0,N
0,N
Customer Type
Customer
name
discount
description
id
1,1
privileges
name
name
description
description
date
quantity
name
number
code
label
1,N
Venue Type
Event Type
1,N
Order
Ticket Type
1,N
0,N
0,N
1,N
1,N
0,N
0,N
0,N
HL
1,1
0,1
HL
number
1,N
Ticket
Sale (Delivery)
0,1
1,1
seat
invoice number
1,1
status
date
1,N
1,1
1,1
HL
0,N
1,1
1,N
Event
Venue
1,N
Manager
Performer
0,N
1,N
0,1
code
address
code
code
contact person
date
name
phone number
name
seating capacity
3
Most performers (gt80) have a manager In case a
performer has a manager, .
A
B
We record at most one manager for each performer.
C
Often, a manager represents more than one
performer.
D
Only managers that represent at least one
performer should be recorded in UDEs enterprise
system.
A
HL
Manager
Performer
1,N
0,1
C
B
D
A
1
4
A
Each event .. can have more than one performer
(but at least one).
B
Only performers that are associated with an event
are included in UDEs enterprise system.
C
Hootie and the Blowfish will perform at the UD
football stadium on November 1 and Actually,
Hootie and the Blowfish performed at Clayton Hall
(a venue) two years ago ? the same performer
(e.g. Hootie and the Blowfish) can perform at
more than one event.
Performer
Event
1,N
1,N
C
B
A
2
5
A
Each event has exactly one venue.
B
It is important to record potential venues. We
consider the Tyler Atrium in Lerner Hall as a
venue but we havent used it for any event yet.
C
We try to organize a big concert at the football
stadium every semester.
Event
Venue
1,1
0,N
C
A
B
3
6
A
We record exactly one event type per event.
B
It should be possible to add a new event type
before an event of that type occurs.
C
Hootie and the Blowfish will perform at the UD
football stadium on November 1 (concert) and
Actually, Hootie and the Blowfish performed at
Clayton Hall (a venue) two years ago (concert).
? the two Hootie and the Blowfish events are
both of type concert.
Event
Event Type
1,1
0,N
C
A
B
4
7
A
and exactly one venue type per venue.
B
Only venue types for which at least one venue
exist are considered.
Venue
Venue Type
1,N
1,1
B
A
5
8
A
Concerts must take place in a stadium, in a
conference hall, or on a parking lot . ? An
instance of Event Type (e.g. concert) can
participate many times in the policy relationship.
B
Concerts must take place .. in a conference
hall. Academic lectures must take place in a
conference hall. ? An instance of Venue Type
(e.g. conference hall) can participate many times
in the policy relationship.
C
There are policies for all event types and for
all venue types.
Policy (We explicitly record the policies in our
database)
Event Type
Venue Type
1,N
1,N
A
C
B
C
6
9
A
There is exactly one event for each ticket i.e.,
tickets are valid for one event only.
B
There are many tickets available for each event
(sometimes thousands).
Ticket
Event
1,1
1,N
A
B
7
10
A
There is exactly one ticket type for each ticket.
B
Z should be recorded in the enterprise system.
However, there has never been an event for which
tickets of type Z have been available.
C
5 different types of tickets tickets
available for each event (sometimes thousands)
Ticket
Ticket Type
1,1
0,N
B
A
C
8
11
A
There are always E tickets (tickets of type E)
available for each event.
B
There are A,B,C,D and E tickets available for the
Hootie and the Blowfish concert.
C
There are A,B,C,D and E tickets available for
the Hootie and the Blowfish concert. There
are A, B, and E tickets available for the Stephen
Framil cello recital. ? the same ticket type
(e.g. A) is available for more than one event.
D
Z should be recorded in the enterprise system.
However, there has never been an event for which
tickets of type Z have been available.
Ticket Type
Event
1,N
0,N
C
D
B
A
9
12
A
For each order, the customer needs to specify how
many seats (quantity) are needed per ticket type.
B
For example, one of our customers ordered 2 seats
of ticket type A and 2 seats of ticket type B for
the Hootie and the Blowfish concert.
C
For example, one of our customers ordered 2 seats
of ticket type A and 2 seats of ticket type B for
the Hootie and the Blowfish concert. Another
customer ordered 3 seats of ticket type A for the
Stephen Framil cello recital. ? There is more
than one order for the same ticket type (A).
D
However, there has never been an event for which
tickets of type Z have been available. ? It is
impossible to have an order for ticket type Z
quantity
Order
Ticket Type
1,N
0,N
B
A
C
D
10
13
A
UDE, usually delivers the actual tickets to the
customer within two weeks.
B
Partial deliveries of tickets are rare but they
occur.
C
There is at most one order per
delivery/sale. Sometimes, customers can buy the
tickets at the event i.e., there is no order.
D
This is only true for 10 of the sales.
D
HL
Order
Sale (Delivery)
0,N
0,1
B
A
C
11
14
A
We didnt sell a single ticket for the Cougar
Banana Symphony event that was scheduled last
night (we never received an order). We had 500
tickets available for this event (and thus
recorded in our database).
B
A ticket can be sold only once (by UDE).
C
There is at least one ticket per sale.
We sell most of our tickets (85).
D
D
HL
Sale
Ticket
1,N
0,1
A
B
C
12
15
A
An order always applies to one specific event.
B
There can be multiple orders for the same event.
C
We didnt sell a single ticket for the Cougar
Banana Symphony event that was scheduled last
night (we never received an order). In most
cases, customers order tickets for an event.
Order
Event
1,1
0,N
C
B
A
13
16
A
We record exactly one customer for each order.
B
Only customers that have placed at least one
order are recorded in our enterprise system.
Order
Customer
1,1
1,N
A
B
14
17
A
Not all customers are assigned a customer type.
B
the same customer can be assigned more than
one customer type.
C
We currently have more than 5,000 customers of
(customer) type Student.
D
We just created a new category Local Business.
However, we dont have any customer of this type
yet.
Customer
Customer Type
0,N
0,N
A
B
D
C
15
18
code
name
phone number
code
name
MANAGER
E
Manager
Performer
2
S
1
code
date
EVENT TYPE
VENUE
address
contact person
seating capacity
S
VENUE TYPE
Event
S
E
S
4
Venue
E
code
description
EVENT
TICKET TYPE
code
name
description
Event-TicketType
EventType
VenueType
EVENT TYPE
VENUE TYPE
E
E
E
ORDER
TICKET TYPE
E
quantity
EventType-VenueType
E
Order-TicketType
S
PERFORMER
EVENT
invoice number
name
ORDER
Performer-Event
S
number
date
EVENT
CUSTOMER
Sale
Order
2
3
4
E
1
E
number
seat
status
EVENT
SALE
TICKET TYPE
label
description
S
Ticket
TicketType
S
id
name
CUSTOMER TYPE
CUSTOMER
3
E
code
name
discount
privileges
S
Customer
CustomerType
Customer-CustomerType