1. (TCOs 9 and 10) The value that is recorded in an attribute if a user does not

Question

1. (TCOs 9 and 10) The value that is recorded in an attribute if a user does not specify one is known as the (Points : 3) domain. key. default value. data type. None of the above

Question 2. 2. (TCOs 9 and 10) A descriptive property or characteristic of an entity is (Points : 3) a domain. an attribute. an entity instance. an entity existence. None of the above

Question 3. 3. (TCOs 9 and 10) A key value whose structure communicates data about an entity instance (Points : 3) is known as an intelligent key. should be avoided (suggested by the authors of your book). is randomly assigned. can only use alphabetic codes. All of the above

Question 4. 4. (TCOs 9 and 10) During requirements analysis, what order of model development is used to arrive at the logical data model? (Points : 3) Context data model; fully attributed data model; key-based data model Key-based data model; fully attributed data model; context data model Context data model; key-based data model; fully attributed data model None of the above

Question 5. 5. (TCOs 9 and 10) A code that assigns sequentially generated numbers to entity instances is known as (Points : 3) a serial code. a sequential code. an alphabetic code. a significant position code. None of the above

Question 6. 6. (TCOs 9 and 10) The physical implementation of a data attribute, it is the smallest unit of meaningful data to be stored. (Points : 3) A field A file A record A key None of the above

Question 7. 7. (TCOs 9 and 10) An attribute or concatenated attribute whose values divide all entity instances into useful subsets is known as (Points : 3) primary criteria. secondary criteria. alternate criteria. subsetting criteria. None of the above

Question 8. 8. (TCOs 9 and 10) An entity that inherits its primary key from more than one entity is called a(n) (Points : 3) associative entity. concatenated entity. ternary. many-to-many cardinality. None of the above

Question 9. 9. (TCOs 9 and 10) An entity whose instances store attributes that are common to one or more entities is a (Points : 3) supertype. subtype. compound type. default type. None of the above

Question 10. 10. (TCOs 9 and 10) The process that prepares a data model for implementation as a database is known as (Points : 3) contextualization. normalization. data analysis. both normalization and data analysis. None of the above

Question 11. 11. (TCOs 9 and 10) When a nonkey attribute is dependent on another nonkey attribute (other than by derivation), this is known as (Points : 3) an associative dependency. a concatenation dependency. a transitive dependency. a derived dependency. None of the above

Question 12. 12. (TCOs 9 and 10) A Gender field can hold only the values M or F. This is an example of (Points : 3) key integrity. domain integrity. referential integrity. logical integrity. schema integrity.

Question 13. 13. (TCOs 9 and 10) What attributes would you have in a table to describe an entity called Student? What would you use as the primary key? What would be the relationship between Grade and Student? Assume that a student can have many grades. (Points : 4)

Explanation / Answer

1. Default value

An attribute can be given a default value when the user does not supply any value for it. Default value is to be specified while creating the entity. If the user gives a value for the attribute while inserting, the same value will be recorded. In case the user does not specify any value for the attribute, then default value specified while creating the entity will be recorded.

2. Attribute

An entity is a person, place, event, idea or any real object for which user wants to store in the database. Entity is the basic block for building the data collected about person, place, event, or thing. Entities has attributes that describe the entity. An attribute is a descriptive property or characteristic of an entity

3.   Intelligent key

An intelligent key is a key that is made up by considering certain columns. It is used where there is no good candidate key. It is a structure that tells about an entity instance.

4.

During requirements analysis, following order of model development is followed to arrive at the logical data model:

context data model

key-based data model

fully attributed data model

normalized data model

5.   Serial code

A serial code is the code that assigns sequentially generated numbers to entity instances.

6. Field

It is a data given to a attribute. A record is a collection of fields. A file is a collection of group of records. Field is the smallest unit of meaningful data to be stored.

7.   Subsetting criteria

Subsetting criteria is made up of an attribute or concatenated attribute whose values divide all entity instances into useful subsets.

8.   Associative entity

An entity that inherits its primary key from more than one entity is called associative entity. Associative entity support many-to-many relationship in the database. It associates more than one entity type. It also contains attributes that describe the uniqueness of entity instances.

9.    Supertype

The super type relationship is an entity type that has the relation with one or more subtypes      and it contains the common attributes of its sub types.

10. Normalization and data analysis

The process used to minimize data redundancy and dependency in a relational database is        known as normalization.

11. Transitive dependency

If any non-primary key attributes are functionally depending on any other non-primary key   attribute, then it is termed as transitive dependency. It means that no other non-primary key attributes should describe any other non-primary key attribute

12. Domain integrity

The set of values or range of values that are allowed for an attribute is known as domain.

Example: The domain for gender column is {male, female} or {M, F}

Domain integrity constraint limits the set of values that are allowed for an attribute. It validates

By specifying domain integrity constraint for a column in a relation, only valid data for a column will be stored in the relation. Thus the integrity of the database is preserved.

13.

The attributes to be used to describe an entity called Student are StudentID, StudentName, DOB, Age, Gender, Address, Course, Grade

A primary key is an attribute that uniquely identifies each row in the database table. A primary key must contain unique values. A primary key cannot contain null values.

The primary key for the student entity will be StudentID.

As the student can have many grades, there exists many to many relationship between student and grade.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.