DatabaseMySQL [3i Infotech Placement]: Sample Questions 110  112 of 162
Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more for all subjects of your exam.
Question 110
MySQL
Explanation
F to be minimal if it satisfies the following conditions:
 Every dependency in F has a single attribute for its right hand side.
 It cannot replace any dependency X ⇾ A in F with a dependency Y ⇾ A where Y is a proper subset of X and still have a set of dependency that is equivalent to F.
 We cannot remove any dependency from F and still have set of dependency that is equivalent to F.
Question 111
MySQL
Explanation
REPLACE  TRANSLATE 






Question 112
MySQL
Explanation
 Relational calculus is an query language which is non procedural, and instead of algebra it uses mathematical predicate calculus.
 The relational calculus is not the same like that of differential and integral calculus in mathematics, but takes its name from a branch of symbolic logic termed as predicate calculus.
 When applied to databases, it is found in two forms. These are
 Tuple relational calculus which was originally proposed by Codd in the year 1972 and
 Domain relational calculus which was proposed by Lacroix and Pirotte in the year 1977