@Praj_Cocer

CREATE TABLE Books ( BookID INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255) NOT NULL, author VARCHAR(255) NOT NULL, price DECIMAL(10, 2) NOT NULL ); CREATE TABLE Customers ( CustomerID INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL,

CREATE TABLE Books ( BookID INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255) NOT NULL, author VARCHAR(255) NOT NULL, price DECIMAL(10, 2) NOT NULL ); CREATE TABLE Customers ( CustomerID INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL,

CREATE TABLE Students ( StudentID INT PRIMARY KEY AUTO_INCREMENT, student_name VARCHAR(100) NOT NULL, age INT, grade CHAR(1) ); CREATE TABLE Quizzes ( QuizID INT PRIMARY KEY AUTO_INCREMENT, quiz_name VARCHAR(100) NOT NULL,

CREATE TABLE Student ( StudentID INT PRIMARY KEY AUTO_INCREMENT, student_name VARCHAR(100) NOT NULL, age INT, grade CHAR(1) ); -- Create the Result Table CREATE TABLE Result ( ResultID INT PRIMARY KEY AUTO_INCREMENT,

CREATE TABLE Patients ( PatientID INT PRIMARY KEY AUTO_INCREMENT, FirstName VARCHAR(100) NOT NULL, LastName VARCHAR(100) NOT NULL, DOB DATE NOT NULL, Gender VARCHAR(10), Phone VARCHAR(15), Email VARCHAR(100) UNIQUE, Address VARCHAR(255)

CREATE TABLE Customers ( CustomerID INT PRIMARY KEY AUTO_INCREMENT, FirstName VARCHAR(100) NOT NULL, LastName VARCHAR(100) NOT NULL, Email VARCHAR(100) UNIQUE, Phone VARCHAR(15), DateOfBirth DATE, JoinDate DATE NOT NULL );

xCREATE TABLE Customers ( CustomerID INT PRIMARY KEY AUTO_INCREMENT, FirstName VARCHAR(100) NOT NULL, LastName VARCHAR(100) NOT NULL, Email VARCHAR(100) UNIQUE, Phone VARCHAR(15), DateOfBirth DATE, JoinDate DATE NOT NULL );

CREATE TABLE Users( UserID INT PRIMARY KEY AUTO_INCREMENT, Username VARCHAR(200) NOT NULL, First_Name VARCHAR(50) NOT NULL, Last_Name VARCHAR(50) NOT NULL, Email VARCHAR(50), Date_of_Birth VARCHAR(20), Join_Date VARCHAR(20) );

CREATE TABLE movies ( Movies_id INT PRIMARY KEY, title VARCHAR(100), genre VARCHAR(50), release_year INT, rating DECIMAL(3, 1), box_office DECIMAL(15, 2), director_id INT, FOREIGN KEY (director_id) REFERENCES directors(director_id) );

CREATE TABLE movies ( id INT PRIMARY KEY, title VARCHAR(100), genre VARCHAR(50), release_year INT, rating DECIMAL(3, 1), box_office DECIMAL(15, 2) ); INSERT INTO movies (id, title, genre, release_year, rating, box_office) VALUES (1, 'Inception', 'Sci-Fi', 2010, 8.8, 829895144.00), (2, 'Titanic', 'Romance', 1997, 7.9, 2187463944.00), (3, 'The Dark Knight', 'Action', 2008, 9.0, 1004558444.00),

-- 1. Table Creation -- Table creation for Institution CREATE TABLE Institution ( InstitutionID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(255) NOT NULL, Address VARCHAR(255), Phone VARCHAR(20), Email VARCHAR(100), Website VARCHAR(100), Type VARCHAR(50),

-- 1. Table Creation -- Table creation for Institution CREATE TABLE Institution ( InstitutionID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(255) NOT NULL, Address VARCHAR(255), Phone VARCHAR(20), Email VARCHAR(100), Website VARCHAR(100), Type VARCHAR(50),

CREATE TABLE Students(StudentID INT PRIMARY KEY AUTO_INCREMENT, Name VARCHAR(100), Subject VARCHAR(100), Marks VARCHAR(4)); Insert INTO Students(Name, Subject, Marks)Values ('Prajwal','Literature','100%'), ('Sophie','Math','97%'), ('Brandon','Science','99%'), ('Tony','History','100%'),

CREATE TABLE Users(UserID INT Primary Key AUTO_INCREMENT, Username VARCHAR(200) NOT NULL, First_Name VARCHAR(50) NOT NULL , Last_Name VARCHAR(50) NOT NULL , Email Varchar(50), Date_of_Birth Varchar(20), Join_Date varchar(20)); CREATE TABLE Posts(PostID INT Primary Key AUTO_INCREMENT, UserID INT,