Ask a Question

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

in Education by
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in (a) Fourth NF (b) BCNF (c) Third NF (d) Second NF I have been asked this question during an interview. The origin of the question is Database Design Process in chapter Normalization of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Correct answer is (b) BCNF The best I can explain: BCNF has only one normal form.

Related questions

0 votes
Q: In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?
    In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which ... from Database Design Process in section Normalization of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in
    The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. ... topic in division Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Given the following relation:Student (Std_ID, name, dept, totalcredit)
    Given the following relation: Student (Std_ID, name, dept, totalcredit) Now Create a view STDINFO (ID, name, ... the STDINFO view. Select the correct answer from above options...
asked Dec 10, 2021 in Education by JackTerrance
0 votes
Q: Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
    Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy ( ... topic in portion Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: We can use the following three rules to find logically implied functional dependencies. This collection of rules is called
    We can use the following three rules to find logically implied functional dependencies. This collection of ... Theory topic in chapter Normalization of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
    There are similarities between the instructor entity set and the secretary entity set in the sense that ... Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Functional Dependencies are the types of constraints that are based on______
    Functional Dependencies are the types of constraints that are based on______ (a) Key (b) Key revisited (c ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Functional dependencies are a generalization of
    Functional dependencies are a generalization of (a) Key dependencies (b) Relation dependencies (c) Database ... Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is
    Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then ... from Materialized Views topic in portion Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: How do I get the full name of the current user from a SQL Reporting Services 2008 report?
    I know that the name of the user account can be retrieved from the built in variable User!UserID but ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 15, 2022 in Education by JackTerrance
0 votes
Q: SQL Server 2008 need a simple method to get customer name, adress and so on from kundeliste
    SELECT TOP (1) Ordreliste.OrdreID, Ordreliste.KundeID, Ordreliste.OrdreDato, Ordreliste.Navn, Ordreliste.Farve FROM ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 7, 2022 in Education by JackTerrance
0 votes
Q: SQL Server 2008 need a simple method to get customer name, adress and so on from kundeliste
    SELECT TOP (1) Ordreliste.OrdreID, Ordreliste.KundeID, Ordreliste.OrdreDato, Ordreliste.Navn, Ordreliste.Farve FROM ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
Q: The number of attributes in relation is called as its
    The number of attributes in relation is called as its (a) Cardinality (b) Degree (c) Tuples (d) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: There are three boxes in a table. One of the box contains Gold and the other two are empty. A printed message contains in each box. One of the message is true and the other two are lies. The first box says 'The Gold is not here'. The Second box says 'The Gold is not here'. The Third box says 'The Gold is in the Second box'. Which box has the Gold?
    There are three boxes in a table. One of the box contains Gold and the other two are empty. A printed message contains in ... Gold is in the Second box'. Which box has the Gold?...
asked Feb 10, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...