21.

Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:

TABLE: CARDEN

Ccode	CarName	Make	Color	Capacity	Charges
501	A-Star	Suzuki	RED	3	14
503	Indigo	Tata	SILVER	3	12
502	Innova	Toyota	WHITE	7	15
509	SX4	Suzuki	SILVER	4	14

TABLE: CUSTOMER

CCode	Cname	Ccode
1001	Hemant Sahu	501
1002	Raj Lal	509
1002	Feroza Shah	503
1004	Ketan Dhal	502

Give the output of the following SQL queries:

1. SELECT COUNT(DISTINCT Make) FROM CARDEN;
2. SELECT MAX(Charges),MIN(Charges) FROM CARDEN;
3. SELECT COUNT(*),Make FROM CARDEN;
4. SELECT CarName FROM CARDEN WHERE Capacity=4;

Verify the following using truth table:

1. X’=0
2. X+1=1

Write the equivalent Boolean Expression for the following Logic Circuit:

Write the SOP form of a Boolean Function F, which is represented in a truth table as follows:

Reduce the following Boolean Expression using K-Map:
F(A,B,C,D) = ∑(2,3,4,5,6,7,8,10,11)

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

Write one advantage of Bus Topology of the network. Also, illustrate how 4 computers can be connected with each other using star topology of the network.

Workalot consultants are setting up a secured network for their office campus at Gurgaon for their day-to-day office and web-based activities. They are planning to have connectivity between 3 buildings and the head office situated in Mumbai. Answer the questions (i) to(iv) after going through the building positions in the campus and other details, which are given below:

Number of Computers:

1. Suggest the most suitable place (i.e. building) to house the server of this Also give a reason to justify your suggested location.
2. Suggest a cable layout of connection between the buildings inside the
3. Suggest the placement of the following device with justification:
   1. Switch
   2. Repeater
4. The organization is planning to provide a high-speed link with its head office situated in MUMBAI using a wired Which of the following cables will be most suitable for this job?
   1. Optical Fiber
   2. Co-axial Cable
   3. Ethernet Cable

Give one suitable example of each URL and Domain Name.

Name two Proprietary software along with their application.