Question

(4) Answer questions based on the table School bus given below:
TABLE: SCHOOL BUS
R. No. Area
Capacity Students Charges
1
Vasant Kunj 100
100
10000
2
Rohini
80
80
5000
3
Saket
120
120
10000
4
Janakpuri 50
50
4000
(a) Write a query to create above table
(b) Display Area, Students only.
(c) Degree of the table.
(d) Cardinality of the table.
(c) Attributes of the table
0 Assign one data type to each attribute of the table
(8) How many Tuples are there in the table?
(h) Write output of the following queries:
(A) Select Area from schoolbus;
(B) select Capacity from schoolbus where area = "Rohini"​

Answer 1

Answer:

nsnsjsjskdiisjsusyeyeyesshgesgyeysssysueyeyeyeeete