Part 1:Fill in the blanks [30]1) ______________________________ integrity constraint is define by : If foreign key exists in a relation, either foreign key value must match a candidate key value of some tuple in its home relation or foreign key value must be wholly null 2) A "collection of normalized relations with distinct relation names" is called a ___________________________3) Each operation in the relational algebra takes one or two relations as operands. How many new relation(s) does it produce as the result of the operation. ___________________________ 4) ___________________________________ operation extracts tuples which satisfy a given condition from a single relation 5) ___________________________________ is defined by: “Number of participating entities in relationship” 6) ___________________________ is defined by:“A set of objects with the same properties, which are identified by a user or organization as having an independent existence.”7) An attribute that holds multiple values for an entity occurrence is called a:___________________________ 8) An attribute that represents a value that is derivable from value of a related attribute, or set of attributes, not necessarily in the same entity, e.g. Age (can be derived from Date of Birth and system date) is called a___________________________ attribute
2) A "collection of normalized relations with distinct relation names" is called a ___________________________3) Each operation in the relational algebra takes one or two relations as operands. How many new relation(s) does it produce as the result of the operation. ___________________________
4) ___________________________________ operation extracts tuples which satisfy a given condition from a single relation
5) ___________________________________ is defined by: “Number of participating entities in relationship”
6) ___________________________ is defined by:“A set of objects with the same properties, which are identified by a user or organization as having an independent existence.”7) An attribute that holds multiple values for an entity occurrence is called a:___________________________ 8) An attribute that represents a value that is derivable from value of a related attribute, or set of attributes, not necessarily in the same entity, e.g. Age (can be derived from Date of Birth and system date) is called a___________________________ attribute