Q. Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.

View solution

Q. The total participation by entities is represented in E-R diagram as

View solution

Q. Which of the following is a low level operator?

View solution

Q. A window into a portion of a database is

View solution

Q. The entity set person is classified as student and employee. This process is called _________

View solution

Q. Which relationship is used to represent a specialization entity ?

View solution

Q. The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.

View solution

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