Observe the following tables VIDEO and MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown below, Also, find the Degree and Cardinality of the final result.
TABLE: VIDEO

TABLE: MEMBER

FINAL RESULT

Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables.
Table: ACCOUNT

Table: TRANSACT

(i) To display details of all transactions of TYPE Deposit from Table TRANSACT.

(ii) To display the ANO and AMOUNT of all Deposits and Withdrawals done in the month of October 2017 from table TRANSACT.

(iii) To display the last date of transaction (DOT) from the table TRANSACT for the Accounts having ANO as 103.

(iv) To display all ANO, ANAME and DOT of those persons from tables ACCOUNT and TRANSACT who have done transactions less than or equal to 3000.

(v) SELECT ANO, ANAME FROM ACCOUNT
WHERE ADDRESS NOT IN (‘CHENNAI’, ‘BANGALORE’);

(vi) SELECT DISTINCT ANO FROM TRANSACT;

(vii) SELECT ANO, COUNT(*), MIN(AMOUNT) FROM TRANSACT
GROUP BY ANO HAVING COUNT(*)> 1;

(viii) SELECT COUNT(*), SUM(AMOUNT) FROM TRANSACT
WHERE DOT <= ‘2017-06-01’;

State any one Absorption Law of Boolean Algebra and verify it using truth table.

Draw the Logic Circuit of the following Boolean Expression:
(U’+V).(V’+W’)

Derive a Canonical POS expression for a Boolean function FN, represented by the following truth table:

Reduce the following Boolean Expression to its simplest form using K-Map:

G(U,V,W,Z) = Σ (3,5,6,7,11,12,13,15)

Differentiate between Bus Topology and Star Topology of Networks. What are the advantages and disadvantages of Star Topology over Bus Topology?

Classify each of the following Web Scripting as Client Side Scripting and Server Side Scripting:
(i) JavaScripting (ii) ASP (iii) VB Scripting (iv) JSP

Write the expanded names for the following abbreviated terms used in Networking and Communications:
(i) SMTP (ii) VoIP (iii) GSM (iv) WLL

CASE STUDY BASED QUESTION:

Ayurveda Training Educational Institute is setting up its centre in Hyderabad with four specialised departments for Orthopedics, Neurology and Pediatrics along with an administrative office in separate buildings. The physical distances between these department buildings and the number of computers to be installed in these departments and administrative office as given as follows. You as a network expert have to answer the queries as raised by them in (i) to (iv).

Shortest distances between various locations in metres:

Number of Computers installed at the various locations are as follows:

(i) Suggest the most suitable location to install the main server of this institution to get efficient connectivity.

(ii) Suggest the best cable layout for effective network connectivity of the building having server with all the other buildings.

(iii) Suggest the devices to be installed in each of these buildings for connecting computers installed within the building out of the following:
-Gateway
-Modem
-Switch

(iv) Suggest the topology of the network and network cable for efficiently connecting each computer installed in each of the buildings out of the following:
Topologies : Bus topology, Star Topology
Network Cable: Single Pair Telephone Cable, Coaxial Cable, Ethernet Cable