- Explain the terms primary key, candidate key, and foreign key. Give an example for each.
- Microsoft Access is a database management system. You may learn about MS Access basics on your own: creating tables and running queries. How useful is a database management system to an accountant? Are there securities issues that are of concern to accountants?
- True or false? The database approach provides two separate views of the data; the physical view and the logical view.
- A key component of a DBMS is the data _____, which contains information about the structure of the database. For each data element stores in the database, such as the customer number, there is a corresponding record in the data dictionary describing it.
- The _____ model represents everything in the database as being stores in the form of tables. Technically, these tables are called _____.
- The _____ is used for data maintenance, which includes such operations as updating, inserting, and deleting portions of the database.
- Which of the following is not a basic requirement of a relational database?
- Every column in a row must be single-valued.
- Primary keys cannot be null.
- Foreign keys must have values that correspond to the value of another foreign key in another table.
- All non-key attributes in a table should describe a characteristic about the object identified by the primary key.
- All of the above are basic requirements of a relational database.
Order an Essay Now & Get These Homework Help Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
