Database Gateway Dance Theatre (GDT) is an urban arts multifaceted…

Question Database Gateway Dance Theatre (GDT) is an urban arts multifaceted… Database Gateway Dance Theatre (GDT) is an urban arts multifaceted program to provide quality arts programming. Gateway Dance Theatre achieves its mission through:? Weekly Classes – to introduce participants to the music and dance cultures of the world.? Residency Program – hosting nationally recognized dancers and musicians.? Workshops – programs designed to bring dance demonstrations and the rhythms of the world to organizations and educational institutions.? Performances – incorporating music, dance, lighting and sound, performances provide an opportunity for participants to develop discipline, teamwork skills and self-esteem.? Outreach – to take the GDT experience to other locationsAdditional details can be found at gatewaydance.org. GDT wants your help to set-up a database that will help manage its activities including managing its students, members, donors, volunteers, and teachers. One of the aims is to record information about different sessions, participants, teachers, and other details. Other goals include donor management, event management, and grant management.GDT studio is also available to outside groups to rent. These groups may use the studio for regular classes or for other non-recurring events.People can register for individual or group classes that GDT offers. Each group class requires exactly one teacher. Individual classes (often considered practice sessions) are often done without a teacher. For each person, GDT wants to store their first name, family name, and birth date. You can assume that each person has a unique id number. GDT also needs to record the teaching expertise and experience level (years of teaching) of each teacher. A person can be a teacher of 1 class and participant in another class (either individual or group class). GDT would like to also include information about people (e.g., prospects) that have not participated in any classes yet, or trainers (e.g., interns) that have not taught any group class yet.For each class, the date and starting hour should be recorded. For group class, the type of class also should be stored (e.g., hip hop, ballet, etc.). Classes are offered on a predetermined schedule for the year. Make an Extended Entity Relationship model and convert the model into a data base schema. The data base schema should indicate the primary and foreign keys. The EER model only needs to show the primary key for the relation. Specifically, do the following.  1. Identify the entity type (name)2. Identify the relationship types and assert their degree (unary, binary, ternary)3. Assert the cardinality ratios and participation constraints (total versus partial participation) E.g., 1-N, M-N, etc.4. Identify the attribute types and assert whether they are simple or composite, single- or multi-values, derived, or not. (name the attribute type, viz, labels)5. Link each attribute type to an entity type or a relationship type (show via ovals or list for each entity)6. Denote the primary key attribute type(s) of each entity type7. Identify the weak entity types and their partial keys (show what are primary keys)8. Apply abstractions such as generalization/specialization, categorization, and aggregation9. Assert the characteristics of each abstraction such as disjoint or overlapping, total, or partial.10. Convert the EER model to data base schema.11. Convert the entity types to relations12. Denote the primary and foreign key attribute types for each relation type.Note:If you need additional details, you may contact GDT or visit their operations.  Computer Science Engineering & Technology MYSQL MIS 320 Share QuestionEmailCopy link Comments (0)