ISM 4011 EXAM 2 VERIFIED STUDY GUIDE
Databases - Answers - Computer programs that contain large volumes of information
- organize and keep track of things
DBMS - Answers - a database management system is designed to manage a database.
It can be used to create a database, change the structure, or do analysis
database administrator (DBA) - Answers - is responsible for making sure data is
available, protected, and monitoring/improving performance
what are the tasks of DBA - Answers - many tasks that full under some broad
categories such as operation, development, security, backup and recovery
SQL - Answers - structured query language
international standard
used by most popular DBMS
NoSQL - Answers - NotRelational DBMS
supports very high transaction rates. relatively simple data structures, replicated on
many servers in the cloud
concurrency - Answers - Database Concurrency Conflicts: Most database applications
are multi-user applications. This means at any given point in time you can expect
multiple persons and/or processes reading and writing to a database.
multi-user processing problem - Answers - at any given point in time you can expect
multiple persons and/or processes reading and writing to a database. with multiple
people/processes updating data in a database, it is only a matter of time before two
separate processes will try to update the same piece of data
parts of a database - Answers - Tables, Records (rows), and Fields (columns)
tables - Answers - a collection of related data where data in a database is stored
rows - Answers - also known as records
each row represents a complete record/ entry in the database
columns - Answers - also known as fields. will always have data of the same type
Primary key - Answers - uniquely identify a record in the table
- must have value
must be UNIQUE (not repeated in that column)
, can only have one primary key for each table
foreign key - Answers - a field in the table that is primary key in another table
- links tables together
-can have more than one foreign key in a table
relationship types - Answers - one to one
one to many
many to many
One to One - Answers - a row in a table can be associated with one row in another table
one to many - Answers - a row in a table can be associated with one or more rows in
another table. one employee can sell many of one item
many to many - Answers - one or more rows in a table can be associated with one or
more rows in another table. each book can have one or more authors and each author
could have written multiple books
four database operations - Answers - inert
read
modify
delete data
CRUD - Answers - create
read
update
delete
Cloud - Answers - elastic leasing of pooled computer resources over the internet
Flexibility - Answers - to meet unpredictable demand while limiting financial risks
cloud services/types - Answers - Cloud services can provide a lot of value but it needs
to be examined on a case by case basis.
IaaS - Answers - Infrastructure as a Service
in general this is
Paas - Answers - Platform as a Service
server platform is maintained and updated by the host
SaaS - Answers - Software as a Service
software is licensed on a subscription basis and is centrally hosted- everything is
provided to operate the needed applications
Databases - Answers - Computer programs that contain large volumes of information
- organize and keep track of things
DBMS - Answers - a database management system is designed to manage a database.
It can be used to create a database, change the structure, or do analysis
database administrator (DBA) - Answers - is responsible for making sure data is
available, protected, and monitoring/improving performance
what are the tasks of DBA - Answers - many tasks that full under some broad
categories such as operation, development, security, backup and recovery
SQL - Answers - structured query language
international standard
used by most popular DBMS
NoSQL - Answers - NotRelational DBMS
supports very high transaction rates. relatively simple data structures, replicated on
many servers in the cloud
concurrency - Answers - Database Concurrency Conflicts: Most database applications
are multi-user applications. This means at any given point in time you can expect
multiple persons and/or processes reading and writing to a database.
multi-user processing problem - Answers - at any given point in time you can expect
multiple persons and/or processes reading and writing to a database. with multiple
people/processes updating data in a database, it is only a matter of time before two
separate processes will try to update the same piece of data
parts of a database - Answers - Tables, Records (rows), and Fields (columns)
tables - Answers - a collection of related data where data in a database is stored
rows - Answers - also known as records
each row represents a complete record/ entry in the database
columns - Answers - also known as fields. will always have data of the same type
Primary key - Answers - uniquely identify a record in the table
- must have value
must be UNIQUE (not repeated in that column)
, can only have one primary key for each table
foreign key - Answers - a field in the table that is primary key in another table
- links tables together
-can have more than one foreign key in a table
relationship types - Answers - one to one
one to many
many to many
One to One - Answers - a row in a table can be associated with one row in another table
one to many - Answers - a row in a table can be associated with one or more rows in
another table. one employee can sell many of one item
many to many - Answers - one or more rows in a table can be associated with one or
more rows in another table. each book can have one or more authors and each author
could have written multiple books
four database operations - Answers - inert
read
modify
delete data
CRUD - Answers - create
read
update
delete
Cloud - Answers - elastic leasing of pooled computer resources over the internet
Flexibility - Answers - to meet unpredictable demand while limiting financial risks
cloud services/types - Answers - Cloud services can provide a lot of value but it needs
to be examined on a case by case basis.
IaaS - Answers - Infrastructure as a Service
in general this is
Paas - Answers - Platform as a Service
server platform is maintained and updated by the host
SaaS - Answers - Software as a Service
software is licensed on a subscription basis and is centrally hosted- everything is
provided to operate the needed applications
