Chavenia, Yezza Mhae U.
BSIT - III
Data Administration
CREATE TABLE students ( ('Ryan', 'Villalon', 'Web Development');
studentsID INT AUTO_INCREMENT PRIMARY
KEY, INSERT INTO courses (course_name,
fname VARCHAR(255), course_code) VALUES
lname VARCHAR(255), ('Data Administration', 'CS101'),
average DECIMAL(5, 2) ('Programming', 'CS102'),
); ('Visual Arts', 'ART101'),
('Research', 'RES101'),
CREATE TABLE teachers ( ('Web Development', 'WD101');
teachersID INT AUTO_INCREMENT PRIMARY
KEY, INSERT INTO enrollments (studentsID,
fname VARCHAR(255), teachersID, coursesID, grade) VALUES
lname VARCHAR(255), (5, 1, 5, 93.5),
subjects VARCHAR(255) (4, 1, 5, 93.4),
); (4, 2, 4, 93.5),
(2, 3, 3, 94.3),
CREATE TABLE courses ( (2, 5, 3, 94.3),
coursesID INT AUTO_INCREMENT PRIMARY (3, 4, 2, 94.3),
KEY, (1, 4, 2, 94.3),
course_name VARCHAR(255), (1, 5, 1, 95.5);
course_code VARCHAR(255)
); SELECT fname, lname, 'Web Development' AS
course_name
CREATE TABLE enrollments ( FROM students
enrollmentsID INT AUTO_INCREMENT WHERE studentsID IN (
PRIMARY KEY, SELECT studentsID
studentsID INT, FROM enrollments
teachersID INT, WHERE coursesID = 5
coursesID INT, );
grade DECIMAL(5, 2),
FOREIGN KEY (studentsID) REFERENCES SELECT * FROM teachers
students (studentsID), WHERE subjects='programming';
FOREIGN KEY (teachersID) REFERENCES
teachers (teachersID), SELECT * FROM enrollments
FOREIGN KEY (coursesID) REFERENCES WHERE coursesID=2;
courses (coursesID)
);
INSERT INTO students (fname, lname, average)
VALUES
('Jennelle', 'Arrogancia', 93.5),
('Dominique', 'Aquino', 93.5),
('Nicole', 'Marquez', 94.3),
('Angel', 'Latchica', 94.3),
('Jayvee', 'Crujido', 95.5);
INSERT INTO teachers (fname, lname, subjects)
VALUES
('Ryan', 'Villalon', 'Data Administration'),
('Jhunel', 'Penaflorida', 'Programming'),
('Jonathan', 'Marquez', 'Visual Arts'),
('Honesto', 'Camino', 'Research'),
('Angelo', 'Pera', 'Programming'),
