Q. Consider the relation given below and ind the maximum normal form applicable to them
1. R(A, B) WITH productions { A --> B }

2. R(A, B) WITH productions { B --> A }

3. R(A, B) WITH productions {A —> B, B --> A }

4. R(A, B, C) WITH productions {A -->B, B --> A, AB --> C }

View solution

Q. Which one is based on multi-valued dependency:

View solution

Q. If a relation is in BCNF, then it is also in

View solution

Q. If every non-key attribute is functionally depedent primary key, then the relation will be in

View solution

Q. If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

View solution

Q. The term for information that describes what type of data is available in a database is:

View solution

Q. A data type that creates unique numbers for key columns in Microsoft Access is:

View solution

Q. A dependency exist between two columns when

View solution

Q. An ________ is a set of entities of the same type that share the same properties, or attributes.

View solution

Q. Entity is a _________

View solution

Q. The descriptive property possessed by each entity set is _________

View solution

Q. The function that an entity plays in a relationship is called that entity’s _____________

View solution

Q. The attribute name could be structured as a attribute consisting of first name, middle initial, and last name. This type of attribute is called

View solution

Q. The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is

View solution

Q. Not applicable condition can be represented in relation entry as

View solution

Q. Which of the following can be a multivalued attribute ?

View solution

Q. Which of the following is a single valued attribute

View solution

Q. In a relation between the entities the type and condition of the relation should be specified . That is called as______attribute.

View solution

Q. _____________ express the number of entities to which another entity can be associated via a relationship set.

View solution

Q. ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

View solution