S

@Shriyanthehacker

homework bootcamp p2

MySQL
2 hours ago
CREATE TABLE Subjects( SubjectID INT AUTO_INCREMENT PRIMARY KEY, Subjectname VARCHAR(50) ); CREATE TABLE Quizzes( QuizID INT AUTO_INCREMENT PRIMARY KEY, Quiz VARCHAR(500), Subject_ID INT );

Institution project

MySQL
2 hours ago
CREATE TABLE Insitutions( Institution_ID INT PRIMARY KEY, Name VARCHAR(255), Location VARCHAR(255), Contact VARCHAR(255), Website VARCHAR(255) ); CREATE TABLE Courses( Course_ID INT PRIMARY KEY,

homework bootcamp p2

MySQL
2 hours ago
CREATE TABLE Subjects( SubjectID AUTO_INCREMENT PRIMARY KEY, Subjectname VARCHAR(50) ) CREATE TABLE Quizzes( QuizID AUTO_INCREMENT PRIMARY KEY, Quiz VARCHAR(500), Subject_ID INT )

School enrollment project.

MySQL
1 week ago
CREATE TABLE Students( StudentID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), DateOfBirth DATE, GradeLevel INT, Address VARCHAR(100), Email VARCHAR(100), Phone VARCHAR(20) );

boot camp part 1 homework

MySQL
3 weeks ago
CREATE TABLE Quiz( Students VARCHAR(100), Quizzes VARCHAR(100), Questions VARCHAR(500), Answers Varchar(500), Responses VARCHAR(500), Grades INT ); INSERT INTO Quiz (Students, Quizzes, Questions, Answers, Responses, Grades)

Boot Camp part 1

MySQL
3 weeks ago
-- Create Students Table CREATE TABLE Students ( StudentID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), DateOfBirth DATE, GradeLevel INT, Address VARCHAR(100), Email VARCHAR(100), Phone VARCHAR(20)

School data homework part 2

MySQL
1 month ago
-- Create the CollegeStudents table CREATE TABLE CollegeStudents( StudentID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50) ); -- Insert data into CollegeStudents INSERT INTO CollegeStudents (StudentID, FirstName, LastN

Book Library Database

MySQL
1 month ago
-- create a table CREATE TABLE Authors( AuthorID INT PRIMARY KEY, AuthorName VARCHAR(100), BirthYear INT, Nationality VARCHAR(50) ); CREATE TABLE Publishers( PublisherID INT PRIMARY KEY,

Student homework part 1

MySQL
1 month ago
CREATE TABLE College_Students ( Student_id INT PRIMARY KEY, Name VARCHAR(50), Age INT, Grade VARCHAR(50) ); CREATE TABLE Result( Student_id INT PRIMARY KEY, Subject VARCHAR(50),

School data part 2

MySQL
1 month ago
-- create a student table CREATE TABLE Students ( StudentID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Grade INT ); -- Create a result table CREATE TABLE Result(

School data homework

MySQL
1 month ago
CREATE TABLE Student ( student_id INT PRIMARY KEY, name VARCHAR(50), subject VARCHAR(50), marks INT ); -- Insert details of 5 students INSERT INTO Student (student_id, name, subject, marks) VALUES

Database

MySQL
1 month ago
CREATE TABLE Books ( Book_ID INT, Title TEXT, Author TEXT, Genre TEXT, Publication_Year INT ); desc Books;

Database

SQL
1 month ago
CREATE TABLE Books( book_id INT, Title Text, author Text, Genre Text, publication_year INT ); desc Books; INSERT INTO Books(book_id, Title, Author, Genre, publication_year) VALUES