Observe the following table carefully and write the names of the most appropriate columns, which can be considered as (i) candidate keys and (ii) primary key.
Id | Product | Qty | Product | Transaction Date |
101 | Plastic Folder 12 inch | 100 | 3400 | 2014-12-14 |
104 | Pen Stand Standard | 200 | 4500 | 2015-01-31 |
105 | Stapler Medium | 250 | 1200 | 2015-02-28 |
109 | Punching Machine Big | 200 | 1400 | 2015-03-12 |
103 | Stapler Mini | 100 | 1500 | 2015-02-02 |
Consider the following DEPT and WORKER tables. Write SQL queries for (i) to(iv) and find outputs for SQL queries (v) to (viii):
Table: DEPT
DCODE | DEPARTMENT | CITY |
D01 | MEDIA | DELHI |
D02 | MARKETING | DELHI |
D03 | INFRASTRUCTURE | MUMBAI |
D05 | FINANCE | KOLKATA |
D04 | HUMAN RESOURCE | MUMBAI |
Table: WORKER
WNO | NAME | DOJ | DOB | GENDER | DCODE |
1001 | George K | 2013-09-02 | 1991-09-01 | MALE | D01 |
1002 | Ryma Sen | 2012-12-11 | 1990-12-15 | FEMALE | D03 |
1003 | Mohitesh | 2013-02-03 | 1987-09-04 | MALE | D05 |
1007 | Anil Jha | 2014-01-17 | 1984-10-19 | MALE | D04 |
1004 | Manila Sahai | 2012-12-09 | 1986-11-14 | FEMALE | D01 |
1005 | R SAHAY | 2013-11-18 | 1987-03-31 | MALE | D02 |
1006 | Jaya Priya | 2014-06-09 | 1985-06-23 | FEMALE | D05 |
Note : DOJ refers to date of joining and DOB refers to date of Birth of workers.
Derive a Canonical SOP expression for a Boolean function F, represented by the following truth table :
A | B | C | F(A,B,C) |
0 | 0 | 0 | 1 |
0 | 0 | 1 | 0 |
0 | 1 | 0 | 0 |
0 | 1 | 1 | 1 |
1 | 0 | 0 | 1 |
1 | 0 | 1 | 0 |
1 | 1 | 0 | 0 |
1 | 1 | 1 | 1 |
Reduce the following Boolean Expression to its simplest form using KâMap :
F(X,Y,Z,W) = ∑(0,1,6,8,9,l0,11,12,15)
Illustrate the layout for connecting 5 computers in a Bus and a Star topology of Networks.
Differentiate between ftp and http.
Difference between FTP and HTTP
FTP is a protocol to transfer files over the Internet.
HTTP is a protocol which allows the use of HTML to browse web pages in the World Wide Web.
Out of the following, which is the fastest (i) wired and (ii) wireless medium of communication?
Infrared, Coaxial Cable, Ethernet Cable, Microwave, Optical Fiber