(1) In relational databases, query requests use a language called? (2) Data that
ID: 405221 • Letter: #
Question
(1) In relational databases, query requests use a language called? (2) Data that the database keeps about its own structure is called? (3) The purpose of ________ in a database system is to receive requests from applications and to translate those requests into reads and writes on database files. (4) ________ constraints are rules that the DBMS enforces to ensure that data values in one table have corresponding values in another related table (5) The DBMS controls ______ by ensuring ta one user's work does not inappropriately interfere with another user's work (6) A(n)____ is a set of one or more computer programs that serves as an intermediary between the user and the DBMS (7) In a database system, the _______ creates and processes forms (8) Microsoft Access is a ___________ which combines a DBMS and an application generator (9) The microsoft Access application generator adds the ability to create and store _______,,_______,, ______ (10) microsoft access 2010 database files are stored using the ______ file extension (11)By default, microsoft access 2010 saves data files in the _______ file format (12) microsoft access 2010 generates surrogate key values when the ________ data type is used (13)A(n)_____ is one or more columns of a relation that is used to identify a row (14) A key that contains two or more attributes is called a(n) ____ key (15) The unique keys that are not chosen to be the primary key are called the ________ keys (16)When the primary key of one relation is placed in a second relation to represent a relationship, the attribute in the second relation is called a(n) __________ key (17) A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n)______constraintExplanation / Answer
1) Structured Query Language (SQL)
2) Metadata
3) DBMS
4) Referential integrity
5) concurrency
6) database application
7)database application
8) personal database
9) forms, reports, queries
10).accdb
11)Access 2007
12)AutoNumber
13) key
14)composite key
15)alternate key
16)foreign key
17) Referential integrity constraint
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.