question 1 explain er modelquestion 2 what are

Question

Question 1 Explain ER model

Question 2 What are the characteristics of a computer provided information?

Question 3 What are facts and guidelines to be considered when selecting a character set?

Question 4 Explain

• altering tables
• Dropping table

Question 5 Write an SQL query to create the student table with the necessary columns and check whether that column allows null values.

Question 6 Create a student table with the following attributes Student name, student roll no, 5 different subjects. Write SQL query for the following conditions

1. Add column to display the total marks of a particular student
2. Add column display the Grade of the student >60 First > 40 & < 60 Second < 40 Fail
3. Group all the students who got Fail grade