Exam 5: Database Processing

The number of entities that can be involved in a relationship in a data model is called the________

A _________ is another name for a table in relational database terms.

In reality a data model is just a model of a person's ________of what the real world looks like.

If there is a small oval in the crow's foot notation, it means that there might not be any entity.

Databases contain:

Setting up the database permissions is a part of database________ .

Forms and reports are usually part of a database__________ .

Constraints on the number of entities are called ___________ cardinalities.

One of the problems with multi- user database processing is the lost- uplink problem.

A database form translates the inputted change into a SQL query in order for the database to process it.

In an E- R data model, the crow's feet symbol is used to indicate a________ side of the relationship.

To prevent the lost- update problem, the DBMS should have some type of________ mechanism.

The Object- Relationship (OR) technique is the most popular one for creating a data model.

Another name for a column is a record.

In a DBMS, when a user is assigned to a read only role, the user will inherit all the __________that are assigned to that role.

What is a DBMS? What are the advantages and disadvantages of using a DBMS?

Oracle and DB2 are examples of multi- featured personal DBMS.

A person, place or object would be represented in a database application as a(n):

A collection of similar records is called a(n)__________ .

________is the notation used to describe a many- to- many relationship.