Database concepts
(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)______constraint
(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)______constraint
0 comments:
Post a Comment