Info Systems Chapter 1
How many entities are depicted by the following requirements? "School XYZ keeps track of its 100 students, 10 teachers, and 5 classrooms."
3
Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application. True or False?
False
Functions of the Database Application
-Create and process forms -Process user queries -Create and process reports -Execute application logic -Control application
Nonrelational Database (NoSQL)
A database that does not use SQL. The need for these arose out of the development of Web 2.0 applications, which allowed the user to create and store data that would be displayed on a web page. (Facebook, Twitter, Pinterest)
Database Management System (DBMS)
A large, complicated program used to create, process, and administer a database.
The creation of a database and its tables is a function of which component of the database system?
DBMS
Microsoft SQL Server is an example of a:
Database Management System
A database is a set of one more computer programs that serves as an intermediary between the users and the database management system (DBMS). True or False?
False
In the general division of labor between database applications and the DBMS, the processing of forms is considered a DBMS task. True or False?
False
Relational Database
Stores data in the form of tables - the tables are designed so that each table stores data about a single theme
Metadata
This term is associated with a database being self-describing because it contains a description of its contents within itself.
What are the components of a database system?
The database, the database management system (DBMS), one or more database applications, and users.
Database Servers
The storage of the database is spread over many different disks - perhaps even over different specialized computers.
Enterprise-Class Database Systems
This type of database contains hundreds of tables with millions of rows of data and supports thousands of concurrent users. Includes multiple applications that might be written in multiple languages. (Examples are Microsoft SQL, Oracle MySQL, and Oracle Database Express)
Personal Database System
This type of database only has one user of the application containing only a few tables and each table only has at most several hundred rows. It provides functionality for application development and database management. (Example is Microsoft Access)
By separating data into tables containing data on only one theme each, making changes to the data is simplified. True or False?
True
What are the contents of a database?
User data, metadata, supporting structures (such as indexes) and sometimes application metadata
Structured Query Language (SQL)
an international language for processing tables in relational databases - you can use this to join together and display data stored in separate tables, create new tables, and query data from tables in many ways. -Can also be used to insert, update and delete data
The component of a database that makes it self-describing is the:
metadata