info@kbcambodia.com

Category: Advanced System Analysis and Design

In DB, Which problem is so critical that it can affect the whole UI?

In DB, Which problem is so critical that it can affect the whole UI? A. Missing data B. Missing attributes C. Wrong relationship cardinality D. All correct Answer: Option C

In Chen’s ERD, what “ellipse” symbol represents?

In Chen’s ERD, what “ellipse” symbol represents? A. Attribute B. Entity C. Relationship D. None correct Answer: Option A

In Chen’s ERD, what “double-line rectangle” symbol represents?

In Chen’s ERD, what “double-line rectangle” symbol represents? A. Strong Entity B. Weak Entity C. Relationship D. None correct Answer: Option B

In Chen’s ERD, what “rectangle” symbol represents?

In Chen’s ERD, what “rectangle” symbol represents? A. Attribute B. Entity C. Relationship D. None correct Answer: Option C

In DB, how to connect a relationship Table1 M-M Table2?

In DB, how to connect a relationship Table1 M-M Table2? A. Connect from Table1’s primary key to Table2’s foreign key B. Connect from Table2’s primary key to Table1’s foreign key C. Connect from both Table1′ PK and Table2’s PK to…

In DB, how to connect a relationship of Table1 M-1 Table2?

In DB, how to connect a relationship of Table1 M-1 Table2? A. Connect from Table1’s primary key to Table2’s foreign key B. Connect from Table2’s primary key to Table1’s foreign key C. Connect from both Table1′ PK and Table2’s PK…

In DB, how to connect a relationship of Table1 1-M Table2?

In DB, how to connect a relationship of Table1 1-M Table2? A. Connect from Table1’s primary key to Table2’s foreign key B. Connect from Table2’s primary key to Table1’s foreign key C. Connect from both Table1′ PK and Table2’s PK…

In DB, what is a relationship cardinality?

In DB, what is a relationship cardinality? A. 1-1, 1-M, M-1, and M-M B. Normalization C. Database design D. None correct Answer: Option A

In DB, what is the main purpose of having a foreign key?

In DB, what is the main purpose of having a foreign key? A. To make its data unique B. To connect it to a primary key C. To make its data unchangeable D. None correct Answer: Option B

In DB, what is correct characteristic of a foreign key?

In DB, what is correct characteristic of a foreign key? A. Preserves the referential integrity constraint B. Unique like a primary key C. Unchanged like a primary D. All correct Answer: Option A