Can you envision more than one instance of the entity?
Is there a variation over time?
Is the item to be modeled a person, place, thing, or an event?
Is the item to be modeled an attribute?
developing a database model that will support company operations.
developing a thorough understanding of what needs to be done in developing a database.
translating the conceptual design into the selected model for use in a database system.
understanding the business and its functional areas or business processes.
a primary field uses an index.
adding an index to a table might decrease overall database performance slightly.
an index can reduce the amount of time it takes for Access to run queries and reports.
indexes are created using the Index property type.
(TCO 2) Which of the following is NOT a step in the Database Life Cycle?
(Points : 4)
Maintenance and Redevelopment
a relationship that guarantees that a record is unique.
an association between a record and its fields.
used to describe attributes.
when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.
used to identify primary keys between tables.
a child of two parent tables that are in a many-to-many relationship.
an integrity element within a table relationship.
a tool that allows you to locate an excel file.
The same data exists in multiple tables.
The data is always in linked tables.
Data updating must be done in multiple table locations.
Data redundancy can result in data anomalies.
field size property.
Many matching records exist between several tables.
Two different tables use the same primary key.
Exactly one record exists in the first table for each record in the second table.
It may be used for security reasons to protect data availability.