R

Ranjeet • 34.60K Points
Instructor I 

Q. Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation

(A) i and ii
(B) ii and iii
(C) i and iv
(D) Professor(professor, project) Professor( professor, project, dept) Student (student no, st_name, dept)
Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. When an ADT is implemented as a C++ class, which of the following should normally be true?

Q. dual of (p V q)٨ r is..

Q. What is true about an ensembled classifier? 1. Classifiers that are more “sure” can vote with more conviction 2. Classifiers can be more &

Q. The device shown here is most likely a

Q. It is possible to define a class within a class termed as nested class. There are _____ types of nested classes.

Q. The main reason for transition from IPv4 to IPv6 is _________

Q. (P->Q)-> (^Q) is __________.

Q. Which of the following parameters can be tuned for finding good ensemble model in bagging based algorithms? 1. Max number of samples 2. Max features 3

Q. Which of the following metrics, do we have for finding dissimilarity between two clusters in hierarchical clustering? 1. Single-link 2. Complete-link

Q. ……………… clause is an additional filter that is applied to the result.

Question analytics