Ask a Question

In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?

in Education by
In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ? (a) Dept name, year->size (b) Year->size (c) Dept name->size (d) Size->year The question was asked by my school teacher while I was bunking the class. This interesting question is from Database Design Process in section Normalization of Database Management

1 Answer

0 votes
by
The correct answer is (a) Dept name, year->size To explain: The process of taking a normalized schema and making it nonnormalized is called denormalization.

Related questions

0 votes
Q: 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
    Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 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: A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
    A relational database system needs to maintain data about the relations, such as the schema of the relations. ... in division Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
    R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
    Which one of the following is used to define the structure of the relation, deleting relations and ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Which is the process of breaking a relation into multiple relations:
    Which is the process of breaking a relation into multiple relations: (a) Functional dependency (b) ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
    Relational Algebra is a __________ query language that takes two relations as input and produces another relation ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 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: Name 5 mobile applications that you have learned during this pandemic which
    Name 5 mobile applications that you have learned during this pandemic which are helpful in your studies. Select the correct answer from above options...
asked Nov 28, 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: How many active assignment rules can you have in a lead/ case?
    How many active assignment rules can you have in a lead/ case?...
asked Nov 11, 2020 in Technology 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

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

...