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

Q. ____________ is preferred method for enforcing data integrity

View solution

Q. Which of the following gives a logical structure of the database graphically ?

View solution

Q. The entity relationship set is represented in E-R diagram as

View solution