Database Query Using–SQL — Computer Science STD 12 Science — Question

Observe the table ‘Club’ given below:

Table: Club

Member_id	Member_Name	Address	Age	Fee
M001	Sumit	New Delhi	20	2000
M002	Nisha	Gurgaon	19	3500
M003	Niharika	New Delhi	21	2100
M004	Sachin	Faridabad	18	3500

(i) What is the cardinality and degree of the above given table?

(ii) If a new column contact_no has been added and three more members have joined the club then how these changes will affect the degree and cardinality of the above given table.

Name one client side scripting language and one server side scripting language. 

What is the importance of a Primary Key in a table? Explain with a suitable example.

Write the full form of DDL and DML?

What is the difference between video conferencing and chat?   

Write SQL commands for the statements (a) to (h) on the table HOSPITAL
(a) To insert a new row in the HOSPITAL table with the following data: 11,’ Kasif’, 37,’ENT’,’2018-02-25’, 300, ’M’.
(b) To set charges to NULL for all the patients in the Surgery department.
(c) To display patient details who are giving charges in the range 300 and 400 (both inclusive).
(d) To display the details of that patient whose name second character contains ‘a’.
(e) To display total charges of ENT Department.
(f) To display details of the patients who admitted in the year 2019.
(g) To display the structure of the table hospital.
(h) Write the command to create the above table.

A school with 20 stand -alone computers is considering to network them together and adding a server. State two advantages of doing this.

Write one advantage of Star Topology of network? Also, illustrate how 5 computers can be connected with each other using Star topology of network.

Write the difference single row and multiple row function.

Out of the following, identify client side script(s) and server side script(s):

(a) ASP

(b) JavaScript

(c) VBScript

(d) JSP