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;
8 Cards in this Set
- Front
- Back
focuses on how the database structure will be used to store and manage end-user data. |
Database design |
|
the first step in designing a database, refers to the process of creating a specific data model for a determined problem domain. |
Data Modeling |
|
A ____ _____ is relatively simple representation, usually graphical, of more complex real-world data structures. In general terms, a model is an abstraction of a more complex real-world object or event. |
data model |
|
Data Model Basic Building Blocks: It is a person, place, thing, or event about which data will be collected and stored. |
Entity |
|
Data Model Basic Building Blocks: It is a characteristic of an entity. |
Attribute |
|
Data Model Basic Building Blocks – It describes an association among entities. |
Relationship |
|
Three (3) types of relationships: |
• One-to-one (1:1) relationship • One-to-many (1:M) relationship • Many-to-many (M:M) relationship |
|
Importance of Database Models |
Data models can facilitate interaction among the designer, the applications programmer, and the end user. A welldeveloped data model can even foster improved understanding of the organization for which the database design is developed. The importance of data modeling cannot be overstated. Data constitutes the most basic information used by a system. Applications are created to manage data and to help transform data into information, but data is viewed in different ways by different people. |