What is the attribute/s which acts as both determinant and...
Write the primary key (type answer in lowercase)
...
Write the candidate keys (type answer in...
A relation is in nNF implies it should be in...
Normal forms applied at the logical...
A table can have more than one foreign keys
Referential integrity should be maintained for each table...
If a column is a candidate key then it should be a super key
No of unique keys >= No of primary keys in a relation
A NOT NULL constraint can have duplicate values
Foreign key should be...
The number of Fully FD’s >= No of FD’s in a...
{ C1, C2 } -----> { C3} implies C1, C2 dependent...
C1----> C5 then what is determinant...
Is the relation is in 3NF?
In a table If a primary key is composite then implies foreign key in...
FD is also called left irreducible...
Does the below table design contains any insert anomoly
...
Ship(BoatId, NbrOfPools, YearMade, Tonage, CompanyId, CompanyName)
...
A relation is in 2NF implies all the determinants should be primary...
Dependent is Primary key implies
If a relation is in 2NF means update anomaly is eliminated
...
You are given the table below for a relation R(A,B,C,D,E). You do not...
You are given the following functional dependencies for the...
Employee(EmpId, EmpSSNO, EmpName, EmpAddress, EmpSalary, EmpAge)
...
In a relation all functional dependents should become a fully...
Books(Title, Author, YrPub, Publisher)
...
When a relation is in 3NF implies the relation does not have any...
Cars(Vin, Make, Style, Price, Year, Color)
...