Database Concepts Flashcards
Are pieces of information. Data can be measured, collected, analyzed and reported.
Data
It is an organized collection of information. The basic function of a database is to store data.
Database
It is designed to handle complex relationships between various items of data, and is correctly referred to as a relational database management system (RDBMS).
Database Applications
It is the standard language used to create and work with databases.
Structured Query Language (SQL)
A standard programming interface for accessing a number of different databases, including Access, DB2, SQL Server, and MySQL.
Open Database Connectivity (ODBC)
A standard programming interface for accessing Oracle databases, which run on the Java platform
Java Database Connectivity (JDBC)
It is a set of programming building blocks that specify how software components should interact.
Application programming interface (API)
Itis a Database Management System (DBMS) fromMicrosoftthat combines the relationalMicrosoftJet Database Engine with a graphical user interface and software development tools.
Microsoft Access
It is a field (or a combination of fields) that uniquely identifies each record stored in a table.
Primary key
It is equivalent to “unknown.” It is not the same thing as zero (0).
Null
A primary key that is comprised of a combination of fields is called a BLANK
Composite Key
It is a column (or combination of columns) in a table that references the primary key in another table.
Foreign key
Note that the primary key to which a foreign key maps is also known as a parent key BLANK
Parent key
There are three types of relationships that can be established between tables:
- One-to-One
- One-to-Many
- Many-to-Many
A relationship in which each record in Table A can have only one matching record in Table B
One-to-One
A relationship in which a record in Table A can have matching records in Table B, but a record in Table B has only one matching record in Table A
One-to-Many
A relationship in which one record in Table A or Table B can be related to many matching records in the other table
Many-to-Many
It represents a logical view of the entire database. It defines how the data is organized and how the tables within the database are related to one another.
Database schema
Works by checking table fields for entries that meet the criteria that you specify.
Queries
It can be strings of text, dates, or a number or range of numbers that you enter.
Criteria
It is not a static snapshot of records, but a dynamic changing subset of records.
Result set or Dynaset (dynamic subset)
Are tools that aid data entry and are user-friendly interfaces designed to help users enter specific data without becoming distracted or confused by other data that may be stored in a table.
Forms
Two basic types of web pages
- Static
- Dynamic
These types of pages display content that does not change (unless the web page developer edits what is on the page).
Static
These pages change every time they are loaded in the browser window. They change their content based on user actions.
Dynamic