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;
30 Cards in this Set
- Front
- Back
|
data hiearsi |
char-fiedl-record-files-database |
|
|
entity |
a general class of people, places or things for which data is stored |
|
|
attribute |
characteristic of an entity |
|
|
data item |
specific value of attribute |
|
|
database approcah |
traditional app to database management databse app to databse mana |
|
|
traditional approach to database management |
herkes kendine ait olan file i kullanir, payrool icin payrol fiel |
|
|
databse approcah to database management |
multiple information systems share a pool f related data |
|
|
data center |
a climate controlled buildings or set of buildings that house data server |
|
|
enterprise data modelling |
done at the level of entire enterprise |
|
|
entity relationships diagrams (ER) |
data models that use basic graphical symbols to show the organization and relationship between data |
|
|
realtional model |
2 dimenaasional table |
|
|
domain |
allowable values for data attributes |
|
|
selectiong |
manipulating data to eliminate rows according to certain crietria |
|
|
joining |
manipulation data to combine 2 or more tables |
|
|
projectiing |
projectiong manipulating the data to eliminate the columns |
|
|
linking |
abilityto combine 2 or more tables through a common data attributes to form a new table |
|
|
satabase types |
flat file single user multiple users |
|
|
flat fiel |
simple database whose records have no relationships to another |
|
|
single user |
a database that is installed on a personal computer is typical meant to signal server |
|
|
multiple users |
business, orgaznitions |
|
|
schema
|
a description of the entire database |
|
|
data definition language |
data tanimlama simgeler, commandlaer vb |
|
|
data dictionary |
detailed description of the all the data used in the database |
|
|
concurrency control |
a method of dealing with a situation in which 2 oe more users or applications need to access the same record at the same time |
|
|
data manipualtiong languaage (DML) |
a specific language provided with a dbms, which allow users to access and modify the data , to make queries, and generate reports |
|
|
structured query language (SQL) |
BECAOME an integral part of most of the databsses |
|
|
data administor |
non technical
|
|
|
data warehosue |
a databse large that collects business info from many sources in the enterprise. covers all aspects of the company |
|
|
data mart |
a subset of a data warehouse, for small-mddim size business departments with in large organzaituiosn |
|
|
data mining |
an information analaysis tool that involves automated discovery of patterns and relationships in a data warehosue |
