CREATE TABLE Student(
  stuid integer primary key,
  studname text not null,
  dob varchar not null,
  address varchar not null,
  phone integer(10)
);

CREATE TABLE Facutly(
  facucode integer primary key,
  facuname text not null,
  designation varchar not null,
  qualification varchar not null,
  doj varchar not null
);


CREATE TABLE Course(
  courseid integer primary key,
  coursename varchar not null,
  coursecredit varchar not null,
  noofhours integer(2),
  facuid integer foreign key,
  stuid integer foreign key
  );