D

@devojayjay

Student Data

SQL
2 hours ago
-- create a table CREATE TABLE students ( student_id INTEGER PRIMARY KEY, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, Grade INT ); CREATE TABLE Results( student_id INT PRIMARY KEY,

Homeowrk DBMS

SQL
3 hours ago
-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, student_name TEXT NOT NULL, subject TEXT NOT NULL, marks INTEGER NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'Math',81); INSERT INTO students VAL

SQL Leonce

SQL
3 days ago
CREATE TABLE Books( Book_ID INT, TITLE TEXT, Author TEXT, Genre TEXT, Publication );

School Club Membership Management

MySQL
1 month ago
CREATE TABLE Students (student_id INT AUTO_INCREMENT PRIMARY KEY, student_name VARCHAR(100) NOT NULL, grade_level INT NOT NULL); CREATE TABLE Clubs( club_id INT AUTO_INCREMENT PRIMARY KEY, club_name VARCHAR(100) NOT NULL, adviso

Online Store Inventory Management_1

MySQL
1 month ago
CREATE TABLE Categories ( category_id INT AUTO_INCREMENT PRIMARY KEY, category_name VARCHAR(50) NOT NULL ); CREATE TABLE Products ( product_id INT AUTO_INCREMENT PRIMARY KEY, product_name VARCHAR(100) NOT NULL,

Event Management System_1

MySQL
1 month ago
-- Create a table to store event information CREATE TABLE Events( event_id INT AUTO_INCREMENT PRIMARY KEY, event_name VARCHAR(100) NOT NULL, event_date DATE NOT NULL, location VARCHAR(100) );

Grade Tracker

MySQL
1 month ago
-- Create a table to store student information CREATE TABLE Students( student_id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, grade VARCHAR(10) NOT NULL ); -- Insert sample student

Books

MySQL
2 months ago
CREATE TABLE Borrowers ( borrower_id INT AUTO_INCREMENT PRIMARY KEY name VARCHAR(50) NOT NULL grade VARCHAR(10), UNIQUE (name,grade) ); CREATE TABLE BorrowingRecords ( record_id INT AUTO_INCREMENT PRIMARY KEY, book_id INT, b

Tables

MySQL
2 months ago
-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M'); INSERT INTO students VALUES (2, 'Joanna', 'F'); INSERT INTO stude