Q. Consider the employee work-team example, and assume that certain employees participate in more than one work team . A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________

View solution

Q. The completeness constraint may be one of the following: Total generalization or specialization , Partial generalization or specialization . Which is the default ?

View solution

Q. Functional dependencies are a generalization of

View solution

Q. A domain is ______ if elements of the domain are considered to be indivisible units.

View solution

Q. Identify the composite attributes

View solution

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