When assigning foreign keys in a 1:M associationa. the primary key of each table should be embedded as a foreign key in the related table. b. the primary key on the 0,M side of the relation should be embedded as the foreign key on the 1,1 side.c. the primary key on the 1,1 side of the relation should be embedded as the foreign key on the 0,M side.d. a link table must be created to accept the foreign keys of both tables.e. none of the above is true.

When assigning foreign keys in a 1:M associationa. the primary key of each table should be embedded as a foreign key in the related table. b. the primary key on the 0,M side of the relation should be embedded as the foreign key on the 1,1 side.c. the primary key on the 1,1 side of the relation should be embedded as the foreign key on the 0,M side.d. a link table must be created to accept the foreign keys of both tables.e. none of the above is true.

Accounting Information Systems

10th Edition

ISBN:9781337619202

Author:Hall, James A.

Publisher:Hall, James A.

Chapter9: Database Management Systems

Section: Chapter Questions

Problem 15MCQ

See similar textbooks

Similar questions

When assigning foreign keys in a 1:1 associationa. the primary key of each table should be embedded as a foreign key in the related table.b. the primary key on the 0,1 side of the relation should be embedded as the foreign key on the 1,1 side.c. the primary key on the 1,1 side of the relation should be embedded as the foreign key on the 0,1 side.d. a link table must be created to accept the foreign keys of both tables.e. none of the above is true.
What is the advantage of selecting the “Only Create Connection" option when importing data?
Which of the following statements is correct? a. A bridge is used to connect a LAN and a WAN. b. Packet switching combines the messages of multiple users into a packet for transmission. At the receiving end, the packet is disassembled into individual messages and distributed to the user. c. The decision to partition a database assumes that no identifiable primary user exists in the organization. d. Message switching is used to establish temporary connections between network devices for the duration of a communications session. e. A deadlock is a temporary phenomenon that disrupts transaction processing. It will resolve itself when the primary computer completes processing its transaction and releases the data the other nodes need.
Which statement is true about a hashing structure? a. The same address could be calculated for two records. b. Storage space is used efficiently. c. Records cannot be accessed rapidly. d. A separate index is required.
To enter transactions in QBO
Cipher text is a. an encryption algorithm b. a plain text c. non repudiation agreement d. a gibberish e. encrypted with the hash creator's private key
Database entities a. may contain zero or many occurrences. b. are represented as verbs in an ER diagram. c. may represent both physical assets and intangible phenomena. d. are often defined by common attributes that also define other entities. e. are unique to a specific user view.
is the target of data flow. Select one: O a. Destination O b. Pass O c. Source O d. Stores
Categorize each of the following as either an equipment failure control or an unauthorized access control.a. message authenticationb. parity checkc. call-back deviced. echo checke. line errorf. data encryptiong. request-response technique
A digital signaturea. is the encrypted mathematical value of the message sender’s name.b. is derived from the digest of a document that has been encrypted with the sender’s private key.c. is derived from the digest of a document that has been encrypted with the sender’s public key.d. is the computed digest of the sender’s digital certificate.e. allows digital messages to be sent over an analog telephone line.