GATE Papers >> CSE >> 2009 >> Question No 56

Question No. 56 CSE | GATE 2009

Consider the following relational schema:

Suppliers(sid:integer, sname:string, city:string, street:string)
Parts(pid:integer, pname:string, color:string)
Catalog(sid:integer, pid:integer, cost:real)

Assume that, in the suppliers relation above, each supplier and each street within a city has a unique name, and (sname, city) forms a candidate key. No other functional dependencies are implied other than those implied by primary and candidate keys. Which one of the following is TRUE about the above schema?

Answer : (B) The schema is in 3NF but not in BCNF.

rIXDku waldorf doll

Posted on  09/01/2021 14:52:20  by  johnanz
F7WQ0K xnxx

Posted on  29/06/2021 12:32:35  by  Merziuziy

Posted on  03/08/2021 14:58:21  by  johnanz

Posted on  09/01/2021 10:35:20  by  dobson
write my essays

Posted on  22/07/2021 22:43:17  by  johnansog

Posted on  03/08/2021 15:06:41  by  johnanz
r4VMCC write my essay

Posted on  04/12/2020 00:34:01  by  dobson
EJ3PQV xnxx videos

Posted on  12/12/2020 22:06:54  by  johnan

Posted on  26/01/2021 15:40:57  by  markus

Posted on  27/01/2021 14:48:15  by  markus
I study here vporn Big job announcements from Apple, Eli Lilly and Co and eBay Inc's Paypal have helped offset the worst ofthe jobs crisis, with public service numbers still falling andIreland's stricken banks still laying off staff.

Posted on  11/08/2021 23:37:03  by  Francesco
I'm a housewife xnxx Even some of Norway’s green groups, staunchly opposed to whaling on principle, are content these days to maintain a death watch for a way of life they expect to disappear within a generation. They can afford to wait it out. With the North Atlantic minke whale population estimated at a healthy 130,000 animals, Norway’s modest annual catch is considered highly sustainable. It is the whalers who are heading for extinction.

Posted on  11/08/2021 23:37:04  by  Alvaro
SZjnbR levitra nizagara

Posted on  18/10/2020 13:34:27  by  dobsonz

Posted on  13/12/2020 06:05:07  by  dobson

Posted on  15/12/2020 07:05:08  by  dobson
Leave a comment