MySQL - ASSIGNMENT | 16th March 26

 

MySQL

DATABASE QUESTIONS

GRADE XII

1.     What is a database? Name any two RDBMS softwares.

2.     Discuss features of SQL.

3.     Differentiate between ALTER and UPDATE statements.

4.     Elucidate the terms degree and cardinality of a relation.

5.     Answer the following questions on the basis of the given table:

Admno            Name              Subject           Gender            Average

1001                Amit                Math                M                     85.5

1002                Suman             English            F                      90

a)     How many attributes are there in above table?

b)    How many tuples are there in above table?

c)     What is the degree and cardinality of above table?

6.     Out of the following in ‘Employee’ table, which field is a primary key and why?

a)     Emp_id                                 c) emp_name

b)    Emp_salary                           d) emp_designation

7.     What is the difference between Char and Varchar?

8.     Write the command to create the following table: “STUDENT”.

Field Name                Data Type                   Constraint

Rollno                         Integer(5)                    Primary Key

Sname                         Varchar(30)

Contactno                   Char(10)                      Not Null

 

9.     Write the query to insert the following record in the above created table.

Rollno                         Sname                         Contactno

1                                  Amit                            1234567890

2                                                                      1231231234

10.  Consider a table EMPLOYEE with the following data and answer the SQL queries:

Eno                 Ename                        Salary             Age                 Gender           DOJ

1                      Ankit Singh                 60000              35                    F                      08-03-2007

2                      Ravi Raj                      50000              32                    M                     19-07-2009

3                      Udit Narayan              40000              32                    M                     03-01-2010

 

a)     Create a database OFFICE.

b)    Use the database OFFICE.

c)     Create a table EMPLOYEE and insert tuples in it.

d)    Display the details of all the EMPLOYEES.