Skip to main content

MySQL - ASSIGNMENT | 10th March 25

 

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.

 


Comments

Post a Comment

Popular posts from this blog

PYTHON - MYSQL CONNECTIVITY CODE

  #INSERTION OF DATA import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="root", database="school" ) print("Successfully Connected") #print(mydb) mycursor=mydb.cursor()   v1=int(input("enter ID:")) v2=input("enter name:") v3=input("enter Gender:") v4=int(input("enter age:")) sql='insert into TEACH values("%d","%s","%s","%s")'%(v1,v2,v3,v4) print(sql) mycursor.execute(sql) mydb.commit() print("record added") #MYSQL Connection code – Deletion on database SOURCE CODE: s=int(input("enter id of TEACHER to be deleted:")) r=(s,) v="delete from TEACH where id=%s" mycursor.execute(v,r) mydb.commit() print("record deleted") MYSQL Connection code – Updation on database SOURCE CODE: import mysql.connector mydb = mysql.connector.c...
Post a Comment
Read more

REVISION IF CONSTRUCT | CLASS TEST

                                                                                     CLASS TEST 1. Write a Python program that asks the user for their age, gender, and current fitness level (beginner, intermediate, or advanced). Based on this information, suggest a suitable fitness plan using if-else statements. Requirements: Inputs : Age (integer) Gender (male/female) Fitness level (beginner/intermediate/advanced) Outputs : Recommend a fitness plan that includes: Suggested workout duration. Type of exercises (e.g., cardio, strength, flexibility). Rest days. Logic : Use if-else to determine the plan based on conditions such as: Age group (e.g., <18, 18–40, >40). Fitness leve...
Post a Comment
Read more