The Area being Modelled is :-
A Talent Management Agency.

ASPECTS TO BE DISCUSSED :-
Assumptions to be discussed :-
1) No Payment details are included.

2) Is it required to hold details of Client Categories,
   for example, the kind of Roles that an Actor might specialize in.
   Examples are shown on the Theater Company Data Model.
3) We have assumed that Appointments can be made by an Agent, (called the appt_made_by_customer_id).
   for a third party,(called the appt_with_customer_id).  
   Is this correct ?

A. DESIGN NOTES :
From the User Requirements defined below, we can derive the following Business Rules :- 
B. The Things of Interest, ('THINGS'), include :-
B.1 Actors.
B.2 Agents.
B.3 Appointments.
B.4 Auditions
B.5 Casting Director.
B.6 Clients
B.7 Photographs of Clients.
B.8 Schedules.

C. These THINGS are Related as follows :-
C.1 An AGENT or CASTING DIRECTOR will call to request an AUDITION with an ACTOR.
C.2 A CLIENT can have zero, one or many Photographs.

D. Other Characteristics of these THINGS include :-
D.1 

E. Sample Data includes :-
E.1 

F. Typical Enquiries include :-
F.1 


This is a Statement of the User Requirements.

From:   Rick@Gemstone Talent - Rick@GemTal.com

Hi!

Just found your site while looking for ideas to create a Scheduling Program for a 
Talent Management business where Modelling is one aspect ofwhat we do. 

But it is generally getting a call from an AGENT or CASTING DIRECTOR and 
they will request an AUDITION with one of the ACTORS we represent.

We have been using ACT! for years but it is too slow and cumbersome.

Scheduling the Appointment, creating an email with the details and
maintaining the schedule to prevent conflicts is the goal. 

Right now we manually complete an appointment sheet, type it into ACT, 
then cut and paste into Eudora to send the email. 

This is taking up to 15 minutes per Appointment, when it 
should take 60 seconds with the right programming,IMHO.

Another goal is to allow clients to update their own record on the Internet, 
and then merge those changes in to our local database. 

There are lots of bells and whistles, including the ability to see a
picture of the clients while on their record, etc. 


Thanks and Regards,
Rick