Module 1 Flashcards
Structure to put data in
Database
Traditional databases typically hold this kind of data
alphanumeric or structured
RDBMS are used to manage ___________ data
structured
Having data is not the problem. The problems are
size, security, ease of updating, accuracy, redundancy and importance
Collection of interrelated data
database
A program to enable creation and maintenance of a database, and then to enter, manipulate and retrieve the data it stores.
DBMS
Combination of a DBMS and a database
database system
The file-based approach to databases (in the 60s and 70s) had these issues…
redundant data, manually programmed queries, storage loss due to redundancy, strong dependency between apps and data, difficulty integrating apps
SQL
Structured Query Language
A basic unit of data. Can be a letter, number or special symbol.
character
A group of related characters is called a
field
A collection of fields is called a
record
A group of records about the same type of entity is stored in a
file
When creating a physical database, a field is commonly referred to as a
column
When creating a physical database, a record is commonly referred to as a
row
When creating a physical database, a file is commonly referred to as a
table
A _____ is a person, place or thing with characteristics or attributes that will be included in the system.
entity
A ____ is a diagram that identifies the entities in the database and shows how entities are related to one another.
E-R model
NoSQL stands for
not only SQL
Big Data storage systems are also called
NoSQL systems
Known facts that have meaning, that can be recorded, that have implicit meaning
data
Information stored in a database catalog
meta-data
Where is meta-data stored
catalog
DBA stands for
database administrator
Data abstraction used to provide a conceptual representation
data model
People whose jobs require access to the database for querying, updating, generating reports
end users
People whose jobs require access to the database for querying, updating, generating reports
end users
Popular high level conceptual data model
Entity Relationship model
The description of a database is call the
database schema
The ______ ________ ________ is used by the DBA and by database designers to define conceptual and internal schemas.
data definition language DDL
Once the database is compiled and populated with data the ___________ ___________ language is used to manipulate the data
data manipulation language (DML)
Property that describes an entity is called an
attribute
A user machine that provides user interface and local processing is called a
client
A type of database that stores and provides access to data points that are related to one another
relational database
