Question

This is questions of Accounting Information Systems

1) Fo a database. Each row in this spreadsheet represents a: ur Tet Industries tracks customer information using various Microsoft Excel spreadsheets stored in a. Field b. Record c. File d. Database 2) A d tables is a. What is the correct term for the database field in Table 1? latabase field in Table 1 that serves as a unique identifier in Table 2 and is used to link both of the a. Foreign key b. Primary key c. Relational key d. Linkage key 3) Noah Lennox is chair of the Animal Collective Society, which maintains a database of all panda bears across the globe. One table stores the name, birth date, and other characteristics of all panda bears that have been registered. Each panda bear is uniquely identified by a registration number. A second table contains data numbers. The primary key in the first table is: that link each panda bear to its male and female parents by means of their registration a. Name b. Birth date c. The primary key in the second table d. A foreign key in the second table equirement that foreign keys (if not null) must have a value corresponding to the value 4) The database r of a primary key in another table is called the: a. Relational database rule b. Referential integrity rule c. Data dictionary rule d. Foreign key rule the data dictionary, defines the record structures of the database, and 5) Which database language builds specifies record and field security constraints? a. Data Definition Language (DDL) b. Data Manipulation Language (DML) c. Data Control Language (DCL) d. Structured Query Language (SQL)

Answer 1

1.B = Record

Four Tet industries track customer information using various Microsoft excels spreadsheets stored in a database each row in a spreadsheet represents the record.

2.B = Primary Key

A database filed in table 1 that serves as a unique identifier in table 2 and is used to link both of the tables is a primary key.

3.C = The Primary Key in the second table

4.D = Foreign Key Rule

The database requirement that foreign keys if not null must have a value that corresponds to the value of the primary key in another is called the Foreign Key rule

5.B = Data Manipulation Language ( DML )

Data Manipulation Language builds the data dictionary, defines the record structures of the database and it specifies the record and the field security constraints.