create database mydb;

use mydb;

create table Students (
	stId integer auto_increment primary key,
    stName char(50) not null,
    stClass integer,
    stClassId char,
    stClassNum integer
);

create table Subjects (
	subId integer auto_increment primary key,
    subName char(50)
);

create table Grade (
	subId integer,
    stId integer,
    grade integer
);

insert into Students(stName, stClass, stClassId, stClassNum)
values("Simeon", 11, "v", 22);
insert into Students(stName, stClass, stClassId, stClassNum)
values("Alekscho", 11, "v", 1);
insert into Students(stName, stClass, stClassId, stClassNum)
values("Metodi", 11, "v", 19);
insert into Students(stName, stClass, stClassId, stClassNum)
values("Silvina", 11, "v", 21);
insert into Students(stName, stClass, stClassId, stClassNum)
values("Bogdan", 11, "v", 5);

insert into Subjects(subName)
values("Literature");
insert into Subjects(subName)
values("Biology");
insert into Subjects(SubName)
values("Mathematics");
insert into Subjects(subName)
values("Technology of programming");
insert into Subjects(SubName)
values("Computer architecture");

select * from Students;
select * from Subjects;

drop table Students;
drop table Subjects;