RDBMS
1 .CREATE DEPARTMENT TABLE create table department( department_id number, department_name varchar( 30 ), department_block_number number, constraint pk primary key(department_id) ); There are more available on https://play.google.com/store/apps/details?id=com.master.askmastermaterial 2 .CREATE STUDENT TABLE create table student( student_id number, student_name varchar( 30 ), address varchar( 40 ), city varchar( 30 ), department_id number, constraint pk primary key(student_id), constraint fk foreign key(department_id) references Department(department_id) ); 3 .CREATE MARK TABLE create table mark( value number, subject_id number, student_id number, constraint pk primary key(subject_id,student_id), constraint fk foreign key(subject_id) references Subject(subject_id), foreign key(student_id) references student(student_id) ); 4 .CREATE SUBJECT TABLE create table subject( subject_id number, subject_name varchar( 30 ), subject_code varchar( 10 ), staff_