Database - A highly organized, multi-table digital storage system designed to hold information on a computer, DBA - The IT role is responsible for the configuration, management, and support of database applications., Queries - A request for data from a database from an end-user, Reports - Easy to read and understand output from queries of databases, Structured data - Divides information into clear, separate categories, Non-structured Data - Information that doesn't have a clear order or pattern, Semi-structured Data - Data doesn't fit neatly into rows and columns like a table, but it still shares some common features., Relational database - Structured database in which information is stored in tables where columns represent typed data fields and rows represent records., Schema - The overall structure of a particular database and its relations (set of rules), Non-Relational db - Handles data in different formats, making it easier to organize semi-structured and unstructured data., Key-value database - A type of non-relational database. It stores data using a unique key that helps you find or save the matching value., Document database - A type of non-relational database manage and track data that doesn't fit into neat and orderly tables., Records - Rows in a database, Fields - Columns in a database, Primary Key - A special identifier that makes each record unique, Foreign Key - What the primary key from the other table is called,

Module 9 Databases

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?