MNd9b6PW

1drop database if exists University;
2create database University;
3use University;
4show tables;
5
6create table Student (
7	StuID int,
8    StuName char(10),
9    Address char(30),
10    Major char(10),
11    primary key(StuID)
12);
13insert into Student
14values (32151675, '박범준', '인천광역시', '소프트웨어학과'),
15	   (32141850, '이건희', '서울특별시', '전자전기공학과'),
16       (32172458, '백준영', '경기도', '공연영화학과');
17create table Course(
18	CouNo char(10),
19    CouName char(15),
20    Professor char(10),
21    primary key(CouNo)
22);
23insert into Course
24values ('388080-1', '이산수학', '정규혁'),
25	   ('452660-5', '데이터베이스기초', '이석균'),
26       ('39160-30', '일반화학1', '조동회');
27create table Course_taken (
28	CtNo int not null auto_increment,
29    ID int,
30    CourseNo char(10),
31    Grade char(1),
32    primary key(CtNo),
33    foreign key(ID) references Student(StuID),
34    foreign key(CourseNo) references Course(CouNo)
35);
36insert into  Course_taken (ID,CourseNo,Grade)
37values (32151675, '388080-1', 'B'),
38	   (32151675, '452660-5', 'A'),
39       (32141850, '39160-30', 'A'),
40       (32172458, '388080-1', 'C'),
41       (32172458, '39160-30', 'F');
42
43select * from Student;
44select * from Course;
45select * from Course_taken;
46SELECT Student.StuName, Course.CouName, Course_taken.Grade
47FROM Student, Course, Course_taken
48WHERE Student.StuID = Course_taken.ID AND Course.CouNo = Course_taken.CourseNo;