H

@herlinajelmatury

Sports Team Management

MySQL
19 hours ago
CREATE TABLE Teams ( TeamID INT AUTO_INCREMENT PRIMARY KEY, TeamName VARCHAR(100) NOT NULL, City VARCHAR(100), FoundedYear INT, Stadium VARCHAR(100) ); CREATE TABLE Players ( PlayerID INT AUTO_INCREMENT PRIMARY KEY,

MOVIE RENTAL STORE

MySQL
1 week ago
CREATE TABLE Customers ( customer_id INT PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR(50), last_name VARCHAR(50), email VARCHAR(100) UNIQUE, phone VARCHAR(20), address TEXT, registration_date DATE );

SCHOOL CLUB MEMBERSHIPS MANAGEMENT

MySQL
1 week ago
CREATE TABLE Students ( student_id INT PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR(50), last_name VARCHAR(50), grade INT NOT NULL, email VARCHAR(100) UNIQUE NOT NULL ); CREATE TABLE Clubs ( club_id INT PRIMARY KEY AUTO_IN

ONLINE STORE

MySQL
2 weeks ago
CREATE TABLE Categories ( CategoryID INT PRIMARY KEY AUTO_INCREMENT, CategoryName VARCHAR(255) NOT NULL, Description TEXT ); CREATE TABLE Products ( ProductID INT PRIMARY KEY AUTO_INCREMENT, ProductName VARCHAR(255) NOT NULL,

VENUE ORGANIZER_SQL

MySQL
4 weeks ago
CREATE TABLE Venues ( venue_id INT AUTO_INCREMENT PRIMARY KEY, venue_name VARCHAR(255) NOT NULL, location VARCHAR(255) NOT NULL, capacity INT NOT NULL ); CREATE TABLE Organizers ( organizer_id INT AUTO_INCREMENT PRIMARY KEY,

STUDENT GRADE TRACKER

MySQL
1 month ago
CREATE TABLE Students ( StudentID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), DateOfBirth DATE, GradeLevel INT, Email VARCHAR(100) ); CREATE TABLE Teachers (

SCHOOL LIBRARY SYSTEM_SQL

MySQL
1 month ago
CREATE TABLE Books ( BookID INT PRIMARY KEY, Title VARCHAR(255) NOT NULL, Author VARCHAR(255) NOT NULL, Genre VARCHAR(100) NOT NULL, PublishedYear INT NOT NULL, CopiesAvailable INT NOT NULL ); CREATE TABLE Students (

GROUP_CONTACTS

MySQL
1 month ago
CREATE TABLE Contacts ( ContactID INT AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), BirthDate DATE ); CREATE TABLE Addresses ( AddressID INT AUTO_INCREMENT PRIMARY KEY, ContactID INT,

educonnectshoot1

MySQL
1 month ago
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), Accreditation V

EDUCONNECTSHOOT

MySQL
1 month ago
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), Accreditation V

PUBLISHER_SQL

MySQL
2 months ago
CREATE TABLE Publishers ( publisher_id INT PRIMARY KEY, name VARCHAR(100), address TEXT, contact VARCHAR(100) ); CREATE TABLE Books ( book_id INT PRIMARY KEY, title VARCHAR(255), ISBN VARCHAR(20),

EDUCATION HUB

MySQL
2 months ago
CREATE TABLE Students ( StudentID INT PRIMARY KEY AUTO_INCREMENT, StudentFirstName VARCHAR(50), StudentLastName VARCHAR(50), DateofBirth DATE, Address VARCHAR(100), StudentEmail VARCHAR(100), StudentPhone VARCHAR(20),

INSTITUTION_SQL

MySQL
2 months ago
CREATE TABLE Institutions ( institution_id INT PRIMARY KEY, institution_name VARCHAR(255), location VARCHAR(255), institution_contact VARCHAR(255), website VARCHAR(255) ); CREATE TABLE Courses ( course_id INT PRIMARY KEY,

BOOTCAMP_2

MySQL
2 months ago
CREATE TABLE Students ( StudentID INT PRIMARY KEY, StudentFirstName VARCHAR(50), StudentLastName VARCHAR(50), DateOfBirth DATE, GradeLevel INT, Address VARCHAR(100), StudentEmail VARCHAR(100), StudentPhone VARCHAR(20)

BOOTCAMP_MYSQL

MySQL
2 months ago
CREATE TABLE Students ( StudentID INT PRIMARY KEY, StudentFirstName VARCHAR(50), StudentLastName VARCHAR(50), DateOfBirth DATE, GradeLevel INT, Address VARCHAR(100), Email VARCHAR(100), Phone VARCHAR(20) );

LIBRARY_BOOKS

MySQL
2 months ago
CREATE TABLE Authors ( AuthorID INT PRIMARY KEY, AuthorName VARCHAR(100), BirthYear INT, Nationality VARCHAR(50) ); CREATE TABLE Publishers ( PublisherID INT PRIMARY KEY, PublisherName VARCHAR(100), Address VARCHAR (200),

SCHOOL_DATA

MySQL
2 months ago
CREATE TABLE Students ( StudentID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Grade INT); CREATE TABLE Result( StudentID INT PRIMARY KEY, Subject VARCHAR(50), Marks INT); INSERT INTO Students (StudentI

INTRO_DBMS

MySQL
2 months 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(1, 'Harry Potter', 'J.K. Rowling', 'Fantasy',