Create Tables

1 create table students id int primary key name varchar(100) not null age int check age >= 0

2 create table employees id int primary key name varchar(100) not null email varchar(150) not null phone_number varchar(20)

3 create table users id int primary key username varchar(100) unique not null email varchar(150) unique not null

4 create table products id int primary key name varchar(100) not null price decimal(10,2) check price > 0 stock int check stock >= 0

5 create table orders id int primary key status varchar(50) default 'pending' created_at timestamp default current_timestamp

6 create table accounts id int primary key account_number varchar(50)
unique not null balance decimal(10,2) check balance >= 0

7 create table enrollments student_id int course_id int primary key (student_id, course_id)

8 create table departments id int primary key name varchar(100) not null
create table employees id int primary key name varchar(100) not null department_id int foreign key (department_id) references departments(id)

9 create table departments id int primary key name varchar(100) not null
create table employees id int primary key name varchar(100) not null department_id int foreign key (department_id) references departments(id) on delete cascade on update cascade