Show:
DBMS Components
Why DBMS?
DBMS Models
SQL Language
100
A person, place or thing.
What is an Entity?
100
The creation of the proper structure of database tables, the proper relationships between tables, appropriate data constrains, and other structural components of the database.
What is database design?
100
Organizes data in a tree like structure according to record types.
What is Hierarchical database management systems?
100
The basic form os SQL Queries
What is SQL SELECT/FROM/WHERE framework?
200
Last name, first name, street address.
What is and Entity attribute?
200
Help people keep track of things
What is the purpose of a database?
200
Represents data in the form of objects.
What is an Object-oriented database management system?
200
SQL asterisk (*)
What is a wildcard character used to indicated that we want all the columns displayed?
300
This may contain numbers, text calculations, etc.
What is the properties of a field?
300
relational database
What is the most commonly used type of database?
300
One record type (called tables) can relate any number of other record types.
What is a Network database management system?
300
SELECT * FROM SKU_DATA WHERE = Department='Water Sports';
What is the SQL command used to gather all the rows for the Water Sports department in SKU_DATA relation?
400
Rules that the data must adhere to to be saved AND built-in, user defined routines that occur when data is manipulated.
What are constraints and triggers?
400
The simultaneous access of data should not impact this.
What is performance of data access?
400
Provides a response for information instead of a complete file.
What is Client Server Model?
400
SELECT * FROM SKU_DATA WHERE SKU > 200000;
What is the command to select the SKU rosw with a value greater than 200,000?
500
Name at least three functions of a DBMS
Create database, create tables, create supporting structures, modify database data (insert, update, delete), read database data, maintain database structures, enforce rules, control currency, perform backup and recovery
500
users, database applications, SQL, DMBS, and Database
What are the components in a database system with SQL?
500
System of tables with a common field that relates one table to another.
What is a Relational database management system?
500
SQL SUM, AVG, MIN, MAX
What are some SQL built-in functions?