Exam DP-900 topic 1 question 296 discussion

Actual exam question from Microsoft's DP-900

Question #: 183
Topic #: 1

DRAG DROP -

Match the database normalization terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Show Suggested Answer

Suggested Answer:

by gravitycat24 at April 28, 2024, 9:38 p.m.

Comments

Submit Cancel

gravitycat24

Highly Voted 9 months, 3 weeks ago

The answer is correct. Explanation from ChatGPT Attribute - Get separated into individual columns In a database, an attribute typically refers to a column in a table, which is where individual data elements of an entity are stored. Entities - Get separated into individual tables Entities in a database are typically represented as tables. Each table represents a specific type of object or concept within the system. Foreign Keys - Link two related entities A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. It is used to establish and enforce a link between the data in two tables. Primary keys are the unique identifier for each record in a table. Schema refers to the organization or structure of a database, including its tables, views, relationships, and other elements.

upvoted 6 times

...

subhayu.biswas12

Most Recent 9 months, 1 week ago

This is correct Answer. Entity = Table in a DB, Attribute = Column in a Table and Link to two related items in two tables = Foreign key.

upvoted 3 times

...