Information System | Database management systems homework help
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.
