School Database Query:
————————————-
CREATE DATABASE SchoolManagementSystem;
USE SchoolManagementSystem;

CREATE TABLE Grades (
GradeID INT PRIMARY KEY IDENTITY(1,1),
GradeName VARCHAR(50) NOT NULL
);

CREATE TABLE Subjects (
SubjectID INT PRIMARY KEY IDENTITY(1,1),
SubjectName VARCHAR(50) NOT NULL
);

CREATE TABLE Classes (
ClassID INT PRIMARY KEY IDENTITY(1,1),
ClassName VARCHAR(50) NOT NULL,
GradeID INT NOT NULL,
FOREIGN KEY (GradeID) REFERENCES Grades(GradeID)
);

CREATE TABLE Teachers (
TeacherID INT PRIMARY KEY IDENTITY(1,1),
TeacherName VARCHAR(50) NOT NULL,
Email VARCHAR(100) NOT NULL,
Phone VARCHAR(20) NOT NULL,
Address VARCHAR(100) NOT NULL
);

CREATE TABLE Students (
StudentID INT PRIMARY KEY IDENTITY(1,1),
StudentName VARCHAR(50) NOT NULL,
DateOfBirth DATE NOT NULL,
Gender VARCHAR(10) NOT NULL,
Address VARCHAR(100) NOT NULL,
Phone VARCHAR(20) NOT NULL,
Email VARCHAR(50) NOT NULL,
DateEnrolled DATE NOT NULL
);

CREATE TABLE ClassTeachers (
ClassID INT NOT NULL,
TeacherID INT NOT NULL,
PRIMARY KEY (ClassID, TeacherID),
FOREIGN KEY (ClassID) REFERENCES Classes(ClassID),
FOREIGN KEY (TeacherID) REFERENCES Teachers(TeacherID)
);

CREATE TABLE Enrollments (
EnrollmentID INT PRIMARY KEY IDENTITY(1,1),
StudentID INT NOT NULL,
ClassID INT NOT NULL,
EnrollmentDate DATE NOT NULL,
FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
FOREIGN KEY (ClassID) REFERENCES Classes(ClassID)
);

CREATE TABLE Assignments (
AssignmentID INT PRIMARY KEY IDENTITY(1,1),
AssignmentName VARCHAR(50) NOT NULL,
SubjectID INT NOT NULL,
ClassID INT NOT NULL,
TeacherID INT NOT NULL,
DueDate DATE NOT NULL,
FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID),
FOREIGN KEY (ClassID) REFERENCES Classes(ClassID),
FOREIGN KEY (TeacherID) REFERENCES Teachers(TeacherID)
);

CREATE TABLE GradesSubjects (
GradeID INT NOT NULL,
SubjectID INT NOT NULL,
PRIMARY KEY (GradeID, SubjectID),
FOREIGN KEY (GradeID) REFERENCES Grades(GradeID),
FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID)
);

new video aagya
https://youtu.be/MiuoElqOETQ

🌱SQL Handwritten Notes
Follow @coder_baba #coderbaba #SQL
SQL is the one of the important topic of any technical interview.
Make sure you are well prepared for it.

I am sharing this simple and scrips notes on SQL, hope it helps you understand SQL in simple way.

Do not forget to follow @coder_baba for more such awesome technical notes.

credit : Unknown

LINQ in .NET
👇👇👇💪superb short video ye nahi dekha to kya dekha💪👇👇👇
https://youtube.com/shorts/O8pL-e7eODw?feature=share

Microsoft Giving Free Machine Learning Course: Enroll Now
Name: Foundations of data science for machine learning
Duration: 12 Hours 45 mins
Number of Modules: 14
Difficulty level: Beginner
Offered By: Microsoft
Rating: 4.8/5

Click here to enroll now
Link: https://bit.ly/3Av8SW7

Hi guys 🌞

Don't miss this opportunity!

Bookmark this page and dive into my curated curriculum.

Eager to learn Data Engineering?

Ive crafted a comprehensive, free Data Engineering course just for you!

Free lessons to get you interview-ready and move ahead of 90% of people.

1. Master Python: https://lnkd.in/e5rCbvP8

2. Learn SQL: https://lnkd.in/efMKFkfX

3. Learn MySQL: https://lnkd.in/efk-Mi3c

4. Learn MongoDB: https://lnkd.in/eMKPWtqX

5. Dominate PySpark: https://lnkd.in/exwA2hKz

6. Learn Bash, Airflow & Kafka: https://lnkd.in/eyN6u2yd

7. Learn Git & GitHub: https://lnkd.in/eX_Q8s99
8. Learn How to Structure Project: https://lnkd.in/dWwnYbA3

9. Learn CICD basics: https://lnkd.in/epKGVFY

10. Decode Data Warehousing: https://lnkd.in/eKnVbFAB

11. Leam DBT: : https://lnkd.in/eG9eaEuE

12. Learn Data Lakes: https://lnkd.in/eQ9xxAJT

13. Learn DataBricks: https://lnkd.in/ePZpCv86

14. Learn Azure Databricks: https://lnkd.in/eBij4akJ

15. Leam Snowflake: https://lnkd.in/erETmtFU

16. Learn Apache NiFi: http://bit.ly/43btwy

17. Leam Debezium: http://bit.ly/3K6W5gL

👇
Subscribe my YT channel: https://youtu.be/dVLGhhEUvBc
Join my Telegram @Coder_Baba

Free SQL Course:
https://www.codecademy.com/learn/learn-sql

Become Expert in GitHub
https://www.udemy.com/course/git-expert-4-hours/

🧜‍♂️Free Project with source code:🧜‍♂️
👇👇👇👇👇👇👇👇👇

1-Online Shopping Website
2-Weather Updates
3-Library Project
4-Hospital Project in C
5-Banking Application
6-BusReservation
7-MovieTicket
8-Food Ordering

Follow👉🏻 @Coder_Baba