Theater Company

The Actors table stores detailed information about the actors involved in the theater company. It includes personal information such as First Name, Last Name, Gender, Date Of Birth, Phone Number, and Address, along with any other actor-specific details. This table acts as a central registry for all actors, making it easy to manage and track the talent pool of the company.

The Actors Roles table links actors to the specific roles they play in productions. It contains fields like Production Part Name, Actor Name, and the dates during which the actor played the role (Date Played From, Date Played To). This table is key for tracking the history of an actor's performances and managing casting records over time.

The Actors Types table categorizes the actors based on their type or specialization. Fields like Actor Type help distinguish between different kinds of actors, such as lead, supporting, or guest performers, providing a clearer understanding of the casting dynamics within the company.

The Productions table contains information about the theater company’s productions, including Title, Playwright, and the production dates (Date From, Date To). This table helps the company keep a log of all the performances they’ve put on, as well as key production details that are relevant for future references or archives.

The Production Categories table categorizes productions by type or genre. It includes fields like Production Title and Category, allowing the theater company to organize its productions into different themes or artistic styles, which helps in production planning and marketing.

The Production Parts table details the roles or parts in each production. It includes fields such as Name, Production Title, Type, and Age Group, which help in organizing and casting roles. This table allows the company to outline specific parts for each production, making the casting process more streamlined.

Overall, this database helps manage the administrative and artistic aspects of running a theater company, ensuring that actors, roles, and productions are well-coordinated and tracked.