D

@debolina19

Social media database

MySQL
1 hour ago
CREATE TABLE users( user_id INT PRIMARY KEY, username VARCHAR(50) UNIQUE, first_name VARCHAR(50), last_name VARCHAR(50), dob DATE, join_date DATE, gender VARCHAR(50), email_id VARCHAR(50) UNIQUE

banking system

MySQL
3 weeks ago
CREATE table customer( cust_id INT PRIMARY KEY, cust_name VARCHAR(50), phone VARCHAR(50), email VARCHAR(50), address VARCHAR(50) ); CREATE TABLE accounts( account_no INT PRIMARY KEY, cust_id INT,

bookstore online database

MySQL
1 month ago
Create table books( book_id INT PRIMARY KEY, title VARCHAR(50), author VARCHAR(100), price DECIMAL(10,2), genre VARCHAR(50) ); CREATE TABLE customers( customer_id INT PRIMARY KEY, customer_name VARCHAR(100),

quiz database

MySQL
2 months ago
CREATE TABLE Student( student_id INT PRIMARY KEY, student_name VARCHAR(50), email VARCHAR(50), mob_no VARCHAR(50), dept VARCHAR(50) ); CREATE TABLE Teacher( teacher_id INT PRIMARY KEY, teacher_name VARCHAR(50),

hospital database

MySQL
2 months ago
CREATE TABLE patients ( patient_id INTEGER PRIMARY KEY, name VARCHAR(50), gender VARCHAR(10), date_of_birth DATE, phone_no VARCHAR(40), email VARCHAR(100) ); CREATE TABLE MedicalStaff ( staff_id INTEGER PRIMARY KEY,

Bootcamp

MySQL
5 months ago
CREATE TABLE students ( student_id INTEGER PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), dob DATE, grade INT, address VARCHAR(100), phone VARCHAR(40), email VARCHAR(150) );

JOIN operations

MySQL
6 months ago
-- create a table CREATE TABLE students ( student_id INT PRIMARY KEY, name VARCHAR(50), grade VARCHAR(50) ); CREATE TABLE course ( course_id INT PRIMARY KEY, course_name VARCHAR(50), s_id INT

Database Bookshelf

MySQL
7 months ago
CREATE TABLE author( author_id INT PRIMARY KEY, author_name VARCHAR(50), birth_year INT, nationality VARCHAR(50) ); CREATE TABLE publisher( publisher_id INT PRIMARY KEY, publisher_name VARCHAR(50), publisher_address VARCH