Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
Five steps in database design
|
1) system analysis: initial planning to determine the need for and feasibility of developing a new system
2) conceptual design: developing different schemas for the new system at the conceptual, external and internal levels 3) physical design: translating the internal-level schema into the actual database structures 4) implementation and conversion: activities associated with transferring data from existing system to the new database 5) using and maintaining the new system: monitoring system performance and user satisfaction |
|
data modeling
|
the process of defining a database so that it faithfully represents all aspects of the organization, including its interactions with the external environment; occurs in stage one and two (system analysis and conceptual design)
|
|
entity-relationship (E-R) diagram
|
a graphical technique for portraying a database schema; shows the various entities being modeled and the important relationship among them
|
|
entity
|
anything about which the organization want to collect and store information
|
|
REA data model
|
developed specifically for use in designing AIS, focuses on the business semantics underlying an organization's value-chain activities
|
|
resources
|
have economic value ex: cash and inventory
|
|
events
|
various business activities about which management wants to collect information for planning or control purposes ex: sales and receive cash
|
|
agents
|
people and organizations that participate in events ex: employees and customers
|
|
cardinalities
|
describe the nature of he relationship between two entities by indicating how many instances of one entity can be linked to each specific instance of another entity
|
|
price and cost data
|
general rule is that time-independent data should be stored as an attribute of a resource or agent, but data that varies across time should be stored with event entities or M:N relationship that link a resource and an event
|
|
concatenated keys
|
multiple-attribute primary keys
|