Questions by Deepanshu / GATE Overflow for GATE CSE

1 votes

0 answers

81

DOUBT
IN SQL WHILE WE USING UNIQUE CONSTRAINT , ARE WE ALLOWED TO USE NULL VALUE OR NULL VALUES OR NONE OF THEM ????????

IN SQL WHILE WE USING UNIQUE CONSTRAINT , ARE WE ALLOWED TO USE NULL VALUE OR NULL VALUES OR NONE OF THEM ????????

486 views

asked Aug 13, 2018

4 votes

0 answers

82

SELF DOUBT GATE2009-56
I AM NOT GETTING THIS QUESTION CONCEPT . PLEASE HELP 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) ... is in 3NF but not in BCNF The schema is in 2NF but not in 3NF The schema is not in 2NF

I AM NOT GETTING THIS QUESTION CONCEPT . PLEASE HELPConsider the following relational schema:Suppliers(sid:integer−−−−−−−−, sname:string, city:string, str...

1.5k views

asked Aug 11, 2018

0 votes

0 answers

83

SELF DOUBT gate 2002 normalisation
PLEASE SOMEONE EXPLAIN ME THAT WHY 2ND OPTION IS TRUE ? I AM NOT GETTING THIS OPTION HELP ME R(A,B,C,D) is a relation. Which of the following does not have a lossless join, dependency preserving BCNF decomposition? A→B,B→CD A→B,B→C,C→D AB→C,C→AD A→BCD

PLEASE SOMEONE EXPLAIN ME THAT WHY 2ND OPTION IS TRUE ? I AM NOT GETTING THIS OPTION HELP ME R(A,B,C,D) is a relation. Which of the following does not have a lossless joi...

253 views

asked Aug 10, 2018

3 votes

0 answers

84

MadeEasy Test Series: Compiler Design - Lexical Analysis

833 views

asked Aug 9, 2018

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true