(Solved) : Help Please Database Screenshots Create Tables Following Relation Schema Student Name Stud Q27078369 . . . .

help! please ( database) with screenshots

create tables for the following relation schema. student(name,student, major

1. Create tables for the following relation schemas.
STUDENT(Name, studentNo, major)
GRADEREPORT(StudentNo, sectionID, Grade)
The required data type of each attribute is described asbelow:
• STUDENT.name is a variable length character string with no morethan 40 characters
(varchar2(40)).
• STUDENT.studentNo is a10-digitnumber, so isGRADEREPORT.StudentNo.
(number(10))
• STUDENT.major is a fixed-length string of 4 characters(char(4)).
• GRADEREPORT.sectionID is a 6-digit number(number(6)).
• GRADEREPORT.Grade is a single letter (char(1)).
Your SQL program should specify each attribute type accordingly andappropriate constraints
including primary keys and foreign keys, if any.
Tip: Run the drop table command first before the create tablecommand. Here is an