Create an appropriate database for a study centre management system. (Perform Normalization till the required levels) with meaningful data of 10 records each per table

To design a database for a Study Centre Management System, we need to identify key entities and their relationships that are crucial for the system's functionality. The study centre will likely handle data such as student information, courses, instructors, enrollment details, and possibly schedules. Below is a step-by-step approach to creating the database, followed by normalization to ensure the data is efficiently stored and avoids redundancy.

Step 1: Identify Entities

Based on the system's requirements, the following entities can be identified:

• Students: Information about each student enrolled in the study centre.
• Courses: Information about the courses offered by the study centre.
• Instructors: Details about the instructors teaching the courses.
• Enrollments: Records of which students are enrolled in which courses.
• Schedule: Timings of the courses and instructors assigned to them.

Step 2: Define Attributes __________ _______ ______ ____ _________ ________ _______ ____ _________.
_________ ______ _______ _________ ____ __________ ________ ____ ______ ____ _____ _______.
_______ ___ _________ ______ _________ ______ ____ ___.
_________ _________ _________ _________ _______ _____ ___ _______ ____ __________ _______.
__________ ________ ___ _______ _____ ___ ___ __________ _________.
________ __________ _____ _________ ______ ___ _______ ________ _____ __________ ___ ___.
___ _________ ___ ___ _________ ________ _____ ________ ____ _________ ____.
______ ____ ____ ___ _____ ____ ________ ______ _________ ____ ___.
_________ _____ ____ _________ ______ _____ _______ ____.
__________ ___ ___ _________ _________.
_______ ___ ______ _____ __________ ____.
________ ____ ________ __________ ___.
________ ________ ____ _________ ______.
____ ______ ________ ____ ____ ______ _____ _______ ________ __________ _______.
_________ ________ _____ ___ ___ __________ _________ ________ ________ _______ _____.
______ ______ _____ __________ _______ ________.
__________ ____ _____ ____ ______ _________ ___ _________.
____ ______ _____ _____ ________ ________ __________ ____.
_____ __________ ________ ______ __________ ________ _____ _________ __________ _______.
__________ _____ _________ ______ _______ _________ ______ ________ __________ ____ _______ ___.
______ ______ ________ _____ ____ ____.
___ ___ ____ _____ __________ ____ _______.
______ _____ _______ ______ _____ _____ _______ __________ _________ _________ __________.
_______ _______ ____ ___ _____ ______ ______ ______ ________ ____.
___ _______ ___ ______ _____ ___ _______.
________ _______ __________ __________ __________ _______.
_______ _______ __________ ___ ______ _____ _______ ________ __________ ______ ________ _____.
____ ______ __________ __________ ________ _____ ________ ____ ______ ____ _________.
___ __________ _____ ____ ________ __________ _______ ________ _____ _______.
____ _________ _________ __________ ______ _________ ________ _________ _____ ________ _______.
____ _____ ____ _____ ______ ___ ______ ___ ______ ___ __________.
_______ _____ _______ _______ _________.
_______ __________ ___ _____ ___ ___ ____ _____ __________ ____.
_______ ______ _________ ________ ___ ______ _________ ___.
________ ______ _________ ________ _________ _________ ___ __________ ___.
_______ _____ __________ _______ ______.
____ _______ _____ ____ ________ _________ __________ __________ ____.
_______ ___ _________ ________ _________ __________ ___ _______ ______ _________.
____ ___ ____ ______ _______ ____ ______ ________ ________.
__________ __________ ________ ______ _________ ________ ___ ____ __________.
________ _____ ________ _______ __________ _____.
____ ________ ____ ________ ________ ___ ____ _________ _____ __________ __________.
____ _____ _______ ________ _________ ___.
___ _________ ______ __________ _________ ___ ________ _____ ___ ______.
_______ _______ _____ _________ _________ ______ _____ ___.
__________ __________ _____ _____ ____ ____ ___ __________ ____ __________ _________ ____.
_________ _______ _______ ________ _________ ____ ______ ______ _______.
______ __________ _________ _____ ___.
_______ ________ _______ _____ ______ ________ ___ _______ _________ __________ __________ __________.
__________ _________ _________ ____ __________ ____ _______ ______ _____ _______ ________ __________.
________ __________ ____ ___ _______ _______ __________ ___ _____ ___ ______ _______.
______ ________ ________ ____ ________ ___ ___ _________ ___.
__________ _________ ____ ______ ________ ________ _______ ____ _______ ___ _____ ___.
________ ________ _____ __________ _______ ______ ________ ______.
________ ________ __________ _____ ________.
______ ______ __________ _________ ________ __________ _____ ________ __________ _________ _____.
_____ __________ _________ ___ _____ ______ ___ _____ _______ __________.
______ ______ ________ ____ __________ ________ _______.
__________ _______ ____ _______ _______ _________ _____.
_______ ______ __________ _______ _______ ____ ____.
_____ _______ _____ ___ ______ _______ ______ __________ ________ ________ ________.
_________ ___ __________ __________ __________ __________ _________.
________ _________ ______ _____ ______ _____ ______.
________ ____ ______ __________ _____ _______ _____ _________ ___ _____ ____ ______.
____ ___ ________ ________ _____ _____ _________ __________.
_____ __________ _________ _____ __________ _____ ___ _____ _______ __________ _______ ___.
_________ ______ ________ ______ ___ ____ ____ ________.
___ _____ ____ ____ ________ ______.
_________ ___ _______ ________ __________ ______ ________ ______ ___.
____ ___ _________ __________ _____ __________ ________ __________.
________ _____ _______ _____ _______ _______.
_________ ____ ________ _____ ___ _______ ___ __________ ______ _______ _____ ________.
___ __________ ____ _________ ____.
________ ______ ___ _______ ____ ___ ____ __________.
_______ _______ ___ ____ ________.
_________ _________ ____ ___ ______ ________.
___ __________ ___ _______ ___ _______ ____ ________.
__________ _____ ____ _____ __________.
Get Full Answer on WhatsApp