Instdept Id Name Salary Dept Name Building Budget Is Decomposed #545
Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into</p> <pre><code class="language-sql">instructor (ID, name, dept name, salary) department (dept name, building, budget)</code></pre> <p>This comes under
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Normalization in Database Management System - Functional-Dependency Theory - Quiz No.1.
Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into
instructor (ID, name, dept name, salary) department (dept name, building, budget)
This comes under
Lossy-join decomposition
Lossy decomposition
Lossless-join decomposition
Both Lossy and Lossy-join decomposition
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes