Related Questions

When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.
A True
B False
An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.
A True
B False
If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?
A Derived attribute
B Optional one cardinality
C Multi-valued attribute
D Weak entity
In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.
A True
B False
In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.
A True
B False
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
A Supertype entity
B Subtype entity
C Archetype entity
D Instance entity
Which of the following database activities allow for the actual retrieval and use of a database?
A Enterprise modeling
B Logical database design
C Physical database design and definition
D Database implementation
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
A Transitive Dependency
B Insertion Anomaly
C Referential Integrity Constraint
D Normal Form
During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.
A True
B False
If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
A Data modeling
B Database design
C Metadata
D All of the above

Next steps