Question

answer the above mentioned question I will mark your answer as brainlist​

Answer 1

a) Two suitable datatype for school database are Student Details and Student Performance.

b) Student Details:

• Name  char(200)  
• Name_of_Father   char(255)
• DOB   date
• Address     char(255)
• Class  char(10)
• Roll_No.     int       Primary Key/ Foreign Key

  Student Performance

• Roll_No. int     Primary Key/ Foreign Key
• marks    int

c) CREATE TABLE Student_Details (

      Name  char(200)  

      Name_of_Father    char(255)

      DOB   date

      Address     char(255)

       Class char(10)

       Roll_No.     int  

      );

d) INSERT INTO Student_Details ( Name, Name_of_Father, DOB, Address, Class,Roll_No.)

    VALUES ( 'RAM SHARMA', ' VISHNU SHARMA','2003-01-26', 'DELHI', 'X', '1');

e) SELECT*FROM Student_Details

   WHERE Class = 'X';

f) UPDATE Student_Performance

   SET marks = marks + 5;