Spaces:
Sleeping
Sleeping
File size: 805 Bytes
bd72e7f | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | create database hello;
use hello;
CREATE TABLE sampleStudent (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
subject1 INT,
subject2 INT,
subject3 INT
);
CREATE TABLE grade_rules (
id INT AUTO_INCREMENT PRIMARY KEY,
min_avg INT,
max_avg INT,
grade VARCHAR(2)
);
INSERT INTO grade_rules (min_avg, max_avg, grade) VALUES
(90,100,'A'),
(75,89,'B'),
(60,74,'C'),
(40,59,'D'),
(0,39,'E');
CREATE TABLE personality_traits (
id INT AUTO_INCREMENT PRIMARY KEY,
grade VARCHAR(2),
trait VARCHAR(100)
);
INSERT INTO personality_traits (grade, trait) VALUES
('A','Highly Disciplined & Leader'),
('B','Confident & Responsible'),
('C','Hardworking & Consistent'),
('D','Needs Motivation'),
('E','Requires Improvement');
|