Chapter 1 - Getting Started Flashcards
Why are Databases Important?
Everything that uses the internet relies on databases to function.
Why do we use Databases?
Databases are used to keep track of things. They store more complicated information than simple lists like a spreadsheet.
What are the Issues encountered with Lists (Spreadsheets)?
A major issue with lists are problems with modifications. Redundancy and multiple themes create problems editing, updating, and inserting records.
What is a Relational Model? What is a Relational Database?
A relational model is a methodology used for database design
A relational database contains a selection of separate tables
What are Tables, Columns, and Rows?
Table - Holds data about only one theme
Columns - Stores a characteristic common to all rows (aka Fields)
Rows - Has data about an occurrence (aka Records)
What is SQL?
SQL is structured query language. It is the international standard for creating, processing, and querying databases.
What are the Four Components of a Database System?
Users
Database application
Database management system (DBMS)
Database
What is a Database?
It is a self-describing collection of related tables.
Self-describing means a description of the structure of the database is contained within the database itself.
Metadata is data about the structure of the database
What is a Referential Integrity Constraint? What are some examples?
Referential integrity constraints are rules enforced by the DBMS to ensure values of a column in one table are valid when compared to values in another table.
What is the difference between Personal and Enterprise-Class Database Systems? When would you use each?
A personal database system is used by only one person and an enterprise database system is used in international orgs.
Personal is good for individuals or small companies, and large enterprises should use the enterprise systems.
What is a Web Database Application?
An application with a Web user interface that is dependent on a database to store the data needed by the application.
What is a BI System?
A business intelligence system consists of tools used to analyze and report on company data.
What is Big Data and what is their association with Nonrelational Databases?
Big Data is the enormous datasets generated by Web and mobile applications.
Nonrelational databases are used to store Big Data (aka NoSQL)
What is Cloud Computing?
It is the use of another company’s hardware to conduct business via an internet connection or through a web server.
Some examples include Amazon Web Services (AWS) or Google Cloud
