(A) R has no duplicates and S is non-empty
(B) R and S has no duplicates
(C) S has no duplicates and R is non-empty
(D) R and S has same numbers of tuples
Related Posts 👇
-
In airline reservation system the enteies are date, flight number, place of departure, destination, type of plan and seats available?
(A) flight number
(B) flight number + place of departure
(C) flight number + date
(D) flight number + destination
-
Which of the following desired features are beyond the capabilty of rational algebra?
(A) Aggregate computation
(B) Multiplication
(C) Finding transtive clousure
(D) All of the above
-
The data flow model of an application mainly shows?
(A) the underlying data and the relations among them
(B) processing requirments and the floe of data
(C) decesion and control information
(D) communication and network structure
-
What are the potental problems when a DBMS executes multiple transections concurrently?
(A) The lost update problem
(B) The dirty read problem
(C) The unrepeatable read problem
(D) All the three
-
The column of a table is reffered to as the?
(A) tuple
(B) attribute
(C) entity
(D) degree
-
If every non key attrebute is functionaly dependent on the primary key then the relation will be in?
(A) first normal form
(B) second normal form
(C) third normal form
(D) fourth normal form
-
The concept of locking can be used to solve the problem?
(A) lost update
(B) uncommitted dependency
(C) inconsistant data
(D) All the three
-
Which normal form is considerd adequate for rational database design?
(A) 2NF
(B) 3NF
(C) 4NF
(D) BCNF