Find the appropriate letter (A-Z) for each of the descriptions given. A. Attribu

Question

Find the appropriate letter (A-Z) for each of the descriptions given. A. Attribute B. Reflexive C. Cardinality D. Determinant E. Entity F. Foreign Key G. Subschema H. Referential Integrity I. Decomposition J. Authorization K. Data anomalies L. Dependent M. Domain N. Normalization O. Metadata P. Primary Key Q. Atomic R. Relationship S. Entity Integrity T. Business Rule U. Specialization V. Schema W. Derived X. Multiplicity Y. DBMS Z. Transitive Dependency The range of values that an attribute can legitimately take on A collection of programs that manages the database structure and controls access to the data stored in the database The left-hand side of a functional dependency Data about data through which the end-user data is integrated and managed Dependency of one nonprime attribute on another nonprime attribute. A brief concise, and unambiguous description of a policy Primary keys cannot be NULL A process to help reduce the likelihood of data anomalies Natural business association that exists between one or more entities A descriptive property, characteristic, or column of an entity Attribute not physically stored within the database Based on grouping unique characteristics and relationships of subtypes An attribute that cannot be broken down further Persons, places, objects, events, and concepts Logical organization of the entire database as seen by the Database Administrator

Explanation / Answer

the range of values that can be assigned to attributes are called as attributes

2)a collection of programs that manages the database structure and controls access to the data stored in the database is DBMS

3)The left-hand side of the FD is called the determinant

4)data about data, through which the end-user data are integrated and managed

is metadadta

5)dependency among non prime attributes is transitive dependency

6)a brief concise and unambiguous description of a policy is business rule

7)primary keys cannot be null foriegn key

8)Normalization is a process to help reduce the likelihood of data anomalies

9)A relationship is a natural business association that exists between one or more entities

10) An attribute is a descriptive property or characteristic of an entity..

11) a derived attribute need not be physically stored within the database.

12)generalization is based on grouping unique characteristics and relationships of the subtypes

13)an attribute that cannot be broken down into component parts

14)an entity is persons places objects events and concepts

15)Logical structures deal with the logical organization of data in a database

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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