Database technology involving relationship

Assignment Help Operation Management

Reference no: EM131685120

1. When you enforce referential integrity and choose the _______________ option, then deleting a record on the primary key side of the relationship would automatically delete all records that reference the primary key.

a. cascade delete related record

b. Relationship

c. Entity Relationship Diagram

d. cascade update related fields

2. In Access, the table view that is used to enter, delete or modify data in a table is called_______________

a. Datasheet view.

b. Export view.

c. Design view.

d. ERD view

3. When you enforce referential integrity and choose the _______________ option, updating the primary key would update all values in the foreign key in the related table.

a. cascade update related fields

b. Relationship

c. Entity Relationship Diagram

d. cascade delete related record

4. In Access, the table view that is used to shape the structure of a table such as specify name, data types and description of fields is known as _______________

a. Export view.

b. Design view.

c. Datasheet view.

d. ERD view

5. Database technology involving relationship between several tables representing entities, and primary/foreign keys representing relationships is known as ___________

a. Query Language

b. Access 2016

c. Relational Databases

d. SQL

Reference no: EM131685120

Questions Cloud

What is the scope of business continuity plan : What is the scope of a business continuity plan? How is it different from a disaster recovery plan?

Advantages-disadvantages of individuals as innovators : What are some of the advantages and disadvantages of individuals as innovators, firms as innovators,

Diversity challenges mirror societal diversity challenges : Do you find that organizational diversity challenges mirror societal diversity challenges?

Advantage of traditional file processing system : Limited data sharing is one of the advantage of Traditional File Processing System.

Database technology involving relationship : Database technology involving relationship between several tables representing entities, and primary/foreign keys representing relationships is known as _______

What exposures does the company have to a lawsuit : Mary was employed by a small cellular phone provider as a sales representative. What exposures does the company have to a lawsuit?

Dmv-elemonte needs more photocopier : Do you think that DMV - Elemonte needs more photocopier? If yes, how many photocopiers will you suggest to buy?

Develop and produce products at faster rate : Innovation is important to firms because it allows them to develop and produce products at a faster rate.

Under which perspective or category of balanced scorecard : Under which perspective or category of the Balanced Scorecard would one normally classify each of the following measurements?

User Account

All Pages