+
Related Flashcards
Cards In This Set
| Front | Back |
|
Consists of a group or programs that manipulate the database and provide an interface between the database and the user or the database and the application program
|
DBMS (definition)
|
|
DBMS (functions)
|
-Storing important data for individuals, groups, and organizations, including numbers, text, visual images, audio signals, and so on-Preforming routine tasks, such as helping an individual prepare income tax forms of helping an organization produce paychecks for its employees
- Providing information to help people, group, and organizations make better decisions by asking questions of the database and creating reports-Ensuring that the data is protected and safe from attacks and unauthorized access |
|
Individuals use personal databases to...
|
Store addresses and contact information, keep track of important dates, and keep track of valuables
|
|
The table in a Database has rows and columns
|
Relational
|
|
A column in a table and contains values of the same type
|
Attribute
|
|
A field in a record that is used to identify the record
|
Key
|
|
Uniquely identifies the record so that they can be accessed, organized, and manipulated
|
Primary key
|
|
The Database model is the most popular
|
Relational
|
|
A specific language provided with the DBMS that allows people and other databases users to access, modify, and make queries about data contained in the database and to generate reports
|
Data Manipulation Language (DML)
|
|
The process of extracting data from a data warehouse
|
Data mining
|
|
Allows the actual data to be spread across several databases at different locations
|
Distributed database
|
|
Helped move e-commerce from desktops to mobile devices
|
Wi-Fi technologies
|
|
Credited with having created a market for online mobile apps
|
IPhone
|
|
Function and examples of transaction processing systems (TPS)
|
-Function: to see which items are selling and which are not. Includes capturing input data, making calculations, storing information in a database, and producing various forms of output (i.e. receipts and purchase orders)-Examples: checkout system on Amazon.com; checkout system at a bookstore; ATM at your bank; keypad on a gas station filling pump
|
|
Examples of business-to-business systems
|
Usually done through e-commerce- raw materials for production of products- tools, parts, and machinery for the production line- office furnishings, equipment, and products- transportation and shipping services
|
