Q. There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called

View solution

Q. If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has

View solution

Q. A _____________ constraint requires that an entity belong to no more than one lower-level entity set.

View solution

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