Intro Flashcards
(15 cards)
What is the Data Model
Tells you the general form of data that’s going to be stored in the database.
Explain Schema vs Data
Schema is the types (GPAs, id’s) data is the variables in the types.
What is a data definition Language
Used to set up the schema
What is done with a data modifying language
For querying and modifying the database
What does a DBMS Implementor do?
Person who builds the system
What does a Database Designer do
establishes the schema for the database
how we’re going to structure the data
What does the Database application developer do
Programs that operate on the database
What does the database administrator do
person who loads the data
gets the whole thing running and maintain
very difficult
What is a database
A set of named relations/tables
What is a relation made up of?
A set of named attributes/columns
Where is the data stored in a table?
a tuple/row which has a value for each attribute
What is the schema?
the structural description of relations in the database
Why us NULL in a database?
Used to indicate a value is unknown or undefined.
What is a key?
A attribute or combination of attributes where every value for that attribute is unique
What is a key used for?
to identify specific types and store data in a particular way to make querying very efficient.
