· 4 years ago · Mar 09, 2021, 02:56 PM
1CREATE TABLE IF NOT EXISTS student (
2 studentID INT NOT NULL PRIMARY KEY,
3 Name varchar(30),
4 Age varchar(4),
5 Mobile Varchar(10)
6);
7
8CREATE TABLE IF NOT EXISTS course (
9 courseID INT NOT NULL PRIMARY KEY,
10 studentID INT,
11 courseName varchar(100) REFERENCES tbl.student(studentID)
12);