Welcome to AssignmentCache!

Muscat Theatre House ERD

Availability: In stock

Regular Price: $12.00

Special Price: $10.00

Quick Overview

Muscat Theatre House ERD


Muscat Theatre House is a place where opera performances are being scheduled. A play is an opera performance acted by different actors/actresses having different roles. A play has id, title, description and category. In every play there will be one or more actors/actresses performing and an actor may perform in any number of plays or may not perform in a given play. Information about actor/actress includes id, name, contact number, nationality, birthdate, and address, which is composed of street number, city, state and country. The role and payment for each actor/actress is also being stored for every play they will perform since these vary from play to play. A schedule is being prepared for each play which details the date and time a play will be performed. A play will be scheduled at least once. Once the schedule is published, customers start reserving seats for a particular schedule or may reserve seat to more than one schedule. A schedule may or may not be reserved by any customer. Information about customer includes id, name and contact number. Whenever a customer reserves for a schedule of a play, it will be identified by a reservation number along with the seat number/s being reserved.

Muscat Theatre House ERD

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

  • Muscat Theatre House ERD

Regular Price: $12.00

Special Price: $10.00

Details

Muscat Theatre House ERD

Muscat Theatre House is a place where opera performances are being scheduled. A play is an opera performance acted by different actors/actresses having different roles. A play has id, title, description and category. In every play there will be one or more actors/actresses performing and an actor may perform in any number of plays or may not perform in a given play. Information about actor/actress includes id, name, contact number, nationality, birthdate, and address, which is composed of street number, city, state and country. The role and payment for each actor/actress is also being stored for every play they will perform since these vary from play to play. A schedule is being prepared for each play which details the date and time a play will be performed. A play will be scheduled at least once. Once the schedule is published, customers start reserving seats for a particular schedule or may reserve seat to more than one schedule. A schedule may or may not be reserved by any customer. Information about customer includes id, name and contact number. Whenever a customer reserves for a schedule of a play, it will be identified by a reservation number along with the seat number/s being reserved.

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.