This repository contains a SQL script developed by Ankita Chougule for creating a database and several tables to store information related to a school.
The purpose of this script is to set up a database named "school" and define tables to store essential data for managing courses, students, and their enrollments. It establishes a relational schema to manage the following entities:
-
CourseMaster Table:
- Stores information about different courses offered by the school, including course ID, name, category, and fee.
-
StudentMaster Table:
- Contains details of students enrolled in the school, such as student ID, name, origin, and type.
-
EnrollmentMaster Table:
- Represents the enrollment records of students in various courses, capturing details like course ID, student ID, date of enrollment, fee waiver flag, and grade.
- Run the script in a SQL Server environment to create the "school" database and the associated tables.
- The script also includes sample data insertion statements to populate the tables for testing and demonstration purposes.
- Additionally, the script provides various SQL queries for performing data analysis and retrieving specific information from the database.