xef1BfX5

1DROP DATABASE IF EXISTS db;
2CREATE DATABASE db;
3USE db;
4
5CREATE TABLE Student(
6	id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
7	S_name VARCHAR(256) NOT NULL,
8    Age INT NOT NULL,
9    GPA FLOAT NOT NULL
10);
11
12CREATE TABLE Grades(
13	G_id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
14	StudentId INT NOT NULL,
15    GradeBG INT NOT NULL DEFAULT 2,
16    GradeMath INT NOT NULL DEFAULT 2,
17    GradeSubd INT NOT NULL DEFAULT 2,
18    
19    FOREIGN KEY (StudentId) REFERENCES Student(id)
20);
21
22INSERT INTO Students VALUES(1, 'Александър', 18, 634.6);
23INSERT INTO Students VALUES('Сашко', 19, 0.01);
24INSERT INTO Students VALUES('Алекс', 2, -5);