Project Overview

Done By

• Mohammad Alkhayat
• Abdulaziz Shaheen
• Abdullah Almuaikel
• Nawaf Alghamdi

Programs Used

• LiveSQL
• Lucidchart
• Draw.io

About the Project

The project is about designing the database structure of Summer Activity Center, and use SQL to apply it. The project is done in 3 phases, which means you submit a process at a time and the final phase includes everything.

Contents

Project Scenario

Here is a brief overview of the project scenario. When you make a database scenario, you should explain each entity and their attributes, and relations too. (e.g. Each department has a unique ID, unique name, scope, and location)

The Summer Activity Center is a recreational facility that offers a variety of programs and activities based on age range during the summer vacation period. To efficiently manage the operations and provide a seamless experience to the participant, the center maintains a comprehensive database system.

Project Operations

• Insert operation: Insert new records into the database for departments, activities, instructors, and participants.
• Update operation: This operation allows for updates to be made, such as when a participant wishes to change the activity they are registered in, or when an instructor needs to modify the activity, they are presenting.
• Inquiring about the number of participants in a specific event: This operation allows to retrieve information on how many individuals are participating in a particular event.
• Determining the number of presenters for a specific event: This operation allows us to find out the count of presenters assigned to a particular event.
• Inquiring about the number of instructors in each department: This operation provides information about the count of instructors within each department.
• Inquiring about the number of activities in each department: This operation allows to retrieve data regarding the number of activities available within each department.