A relation is a table having atomic values, unique row and unordered rows and columns. The relational model represent data and relationship among data by a collection of tables known as relation, each of which has a number of columns with unique names.

Cardinality is defined as the number of rows in a table. Degree is the number of columns in a table.
e.g. consider the following table:
Table: Account

Cardinality: 3
Degree : 2

Candidate keys: Id, Product
Primary key: Id

Degree is the number of attributes or columns present in a table.
Cardinality is the number of tuples or rows present in a table.
Degree: 4
Cardinality: 5

(i) We cannot use Qty as primary key because there is a duplication of values and primary key value cannot be duplicate.
(ii) Degree: 4
Cardinality: 5

(a) import MySQLdb
db = MySQLdb.connect('localhost' ,'FacAdmin','FacAdmin@pwd','college')
cursor=db.cursor()
sql="""select* from Faculty where salary>%F""",
search_ value=(12000,)
try:
cursor.execute(sql.search_ value)
result=cursor. fetchall()
print("ID, Name, Hiredate")
for row in result:
ID=row[0]
name-row[1]-" "row[2]
Hiredate=row[2]
print (ID,name, Hiredate)
print cursor.rowcount, "Records found"
except:
print ("Error: can't Fetch records")
cursor.close()
db.close()
(b) import MySQLdb
db=MySQLdb. connect('localhost' ,'FacAdmin','FacAdmin@pwd','college')
cursor=db.cursor()
sql="""select * from courses where Fees between %F and %F"""
search_value=(15000,50000)
try:
cursor.execute(sql, search_value)
results = cursor.fetchall()
print ("CID Faculty Course Fee")
for row in results:
print (row[0],row[1], row[2], row[3])
print (cursor.rowcount, "Records Found")
cursor.close()
db.close()
(c) import MySQLdb
db=MySQLdb.connect('localhost' ,'FacAdmin','
FacAdmin@pwd','college')
cursor = db.cursor()
sql= Update Courses set Fees = Fees+500
where Cname=%s"''''
update value = ('System Design',)
try:
cursor.execute(sql, update_value)
db.commit()
print (cursor.rowcount, "record updated")
except
db. rollback.
cursor.close()
db.close()
(d) import MySQLdb
db = MySQLdb.connect('localhost' ,'FacAdmin',"FacAdmin@pwd',' college')
cursor=db.close()
sql="""select count (Distinct F_ID) from Courses"""
try:
cursor.execute(sql)
print (row[0], "unique F_ID exist")
except:
print ("Error could not Fetch records")
cursor.close()
db.close()

import MySQLdb
db = MySQL.connection('localhost' ,'FacAdmin','FacAdmiil@123','XYZHOS')
cursoredb.cursor()
cursor.execute("DROP TABLE IF EXISTS Hospital")
sql="""Create Table Hospital('Hospital _ id',
INT NOTNULL, 'Hospital_name' CHAR(50)
NOTNUL
'Bed_Count' INT, PRIMARY KEY ('Hospital_id')
)"""cursor.~xecute(sql)
cursor.elose()
db.close()

import MySQLdb
db = MySQLdb.connect('localhost' ,'HosAdmin','HosAdmin@123' ,'XYZHospital')
cursor=db.cursor()
cursor.execute("DROP TABLE IF EXISTS DOCTORS")
sql="""Create Table Doctors (,DoctocId' INT NOTNULL, 'Doctor_Name' Char(50) NOTNULL, 'HospitalId' INT NOTNULL, 'Joining Date' Date NOTNULL, 'Speciality' char(50), 'Salary'
Float' 'Experience' Float PrimaryKey
(Doctor_ Id,))"""
cursor.execute(sql)
cursor.close()
db.close()

A Candidate Key can be any column or a combination of columns that can qualify as unique Key in database. There can be multiple Candidate keys in one table. Where as A Primary Key is a column or a combination of columns that uniquely identify a record. There can be only one primary key in one table
Degree: It is the total number of attributes (number of columns) in the table.
Cardinality: It is the total number of tuples (number of rows) in the table.

The wildcards are incorrect. The corrected query is SELECT NAME FROM TEACHER WHERE NAME LIKE' _ _ 0%';