Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

______ data model ______ descriptive attributes ______ primary key ______ logica

ID: 3835204 • Letter: #

Question

______ data model ______ descriptive attributes ______ primary key ______ logical data schema ______ total participate of E for relationship R ______ identifying relationship ______ data inconsistency ______ mapping cardinality ______ database-management system(DBMS) ______ multi value attribute An attributes that is associated with a relationship A attribute that can hold multiple values The number of entities to which another entity can be associated via a relationship set. A collection of conceptual tools for describing data, data relationships, data semantics, and consistency constraints. The various copies of the same data may no longer agree to each other. It is chosen by database designer as the principal means of uniquely identifying members within an entity set. Data dictionary that describes each data item. A collection of interrelated data and set of programs to access those data A relationship associating the weak entity set with the identifying entity set. Every entity in E participates in at least one relationship in R.

Explanation / Answer

1.d

2.a

3.f

4.g

5.j

6.i

7.e

8.c

9.h

10.b

1.a collection of conceptual tools for describing data ,data relationships,data semantics,and consistency constraints is data model.

2.an attribute that is associated with a relationship is called descriptive attribute.

3.it is chosen by database designer as the principal means of uniquely identifying members within an entity set.

4.data dictionary that describes each data items(tables,views,triggers,constraints) is logical data model.

5.every entity in E participates in at least one relationship in R is total participation of E for relationship R.

6.a relationship associating the weak entity set with the identifying entity set is identifying relationship.weak entity does not have primary key.

7.the various copies of same data may no longer agree to each other is called data inconsistency.

8.the number of entities to which another entity can be associated via a relationship set is mapping carnality.

9.a collection of interrelated data and set of programs to access those data is called database management system(DBMS)

10.a attribute that can hold multiple values is multi value attribute.

phonephone number a person have more than one phone number.

email id's-a person have more than one mail id's.