Answers
foreign key (FK) fields which establishes and enforces a link between the data in two
tables to control the data that can be stored in the foreign key table (w/red box).
Structured Query Language (SQL) Relational databases are created and managed using a
standard (by ANSI and ISO) computer language called _______
Open Database Connectivity (ODBC) Microsoft and Oracle, in 1992, created _______ to
standardize application-to-SQL communication protocol or simply, database protocol
Object-link and Embedding for Databases (OLE-DB), Component Object Model (COM)-based
Later in 1996, Microsoft developed its own unique database protocol called ______ as a
connectivity layer between OOP applications, and SQL or its own _____ data sources.
programming statements SQL _________ are used to perform tasks such as "Select",
"Insert", "Update", "Delete", "Create", and "Drop" data from a database.
relational database management systems (RDBMS) Common _____ that use SQL are:
Oracle, Sybase, Microsoft SQL Server, Access, and Ingres.
additional proprietary extensions Although most database systems use SQL, most DBMS
also have their own ______ that are usually only used on their system.
, data binding VB uses a process known as ______ to provide a simple and consistent way
for applications, thru its user interface, to present and interact with data.
Data Access Objects (DAO) For MS Access Databases (*.mdb) which uses the Joint
Engine Technology (JET) database engine.
Remote Data Objects( RDO). For ODBC (Non-MS databases such as Oracle)
ActiveX Data Objects (ADO) For OLE-DB
data controls, Binding Navigator Control Each type of interface uses _____ to connect
and move within databases. In .NET versions of VB (2008 and up), data controls were replaced
by _____.
Data Bound Controls Specific data controls which display data entries of a database are
called ______.
Some of these controls include: picture boxes, labels, text boxes, lists, combo-boxes, and grids.
ADO Since DAO and RDO were limited to relational databases, Microsoft developed
_____ to extend the database programming features of VB among web pages, Excel
spreadsheets, and other documents using the OLE-DB protocol.
_____ is composed of a library of objects facilitate modular approach in connecting with
databases.