Question

1.Explain difference be
2.a. Write SQL command to create the table club including the constraints as per details given
below:2
b. Write the command display the details of the all members whose type is permanent and fee
1
more than Rs. 1000.
Table-CLUB
Constraint
Column
Size
Datatype
Numeric
Mem_no
Primary key
4
Not null
Mem_name
Text
30
Address
Text
30
>=18
3
Numeric
Age
Text
10
Type
Numeric
6,2
Fees​

Answer 1

Answer:

Constraints can be column level or table level. Column level constraints apply to a column, and table level constraints apply to the whole table. The following constraints are commonly used in SQL: NOT NULL - Ensures that a column cannot have a NULL value.