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.


Comments
rIXDku http://waldorfdollshop.us/ waldorf doll

Posted on  09/01/2021 14:52:20  by  johnanz
F7WQ0K https://xnxxx.web.fc2.com/ xnxx

Posted on  29/06/2021 12:32:35  by  Merziuziy
https://beeg.x.fc2.com/sitemap1.html https://beeg.x.fc2.com/sitemap2.html https://xnxxx.web.fc2.com/sitemap1.html https://xnxxx.web.fc2.com/sitemap2.html https://xvideoss.web.fc2.com/sitemap1.html https://xvideoss.web.fc2.com/sitemap2.html

Posted on  03/08/2021 14:58:21  by  johnanz
ItujN4 https://writemyessayforme.web.fc2.com/octavio-paz-essay-day-of-the-dead.html

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

Posted on  22/07/2021 22:43:17  by  johnansog
https://xvideoss.web.fc2.com/

Posted on  03/08/2021 15:06:41  by  johnanz
r4VMCC https://www.quora.com/What-the-top-SEO-keywords-for-essay-you-know/answer/Alan-Smith-1772 write my essay

Posted on  04/12/2020 00:34:01  by  dobson
EJ3PQV http://xnxx.in.net/ xnxx videos

Posted on  12/12/2020 22:06:54  by  johnan
weXTEY https://beeg.x.fc2.com/

Posted on  26/01/2021 15:40:57  by  markus
UbElYe https://buyzudena.web.fc2.com/

Posted on  27/01/2021 14:48:15  by  markus
I study here http://tubeadvisor.online 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 http://tubereviews.online 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 http://pills2sale.com/ levitra nizagara

Posted on  18/10/2020 13:34:27  by  dobsonz
l6aoNF https://writemyessayforme.web.fc2.com/

Posted on  13/12/2020 06:05:07  by  dobson
5THfjV https://writemyessayforme.web.fc2.com/#writemyessay

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