Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

WGU Data Management - Foundations Exam - Topic 5 Question 15 Discussion

Which main characteristic is used to differentiate between strong and weak entities in the process of database design?
B) Primary key
A) Association
C) Foreign key
D) Cardinality

WGU Data Management - Foundations Exam - Topic 5 Question 15 Discussion

Actual exam question for WGU's WGU Data Management - Foundations exam
Question #: 15
Topic #: 5
[All WGU Data Management - Foundations Questions]

Which main characteristic is used to differentiate between strong and weak entities in the process of database design?

Show Suggested Answer Hide Answer
Suggested Answer: B

In database design, an entity is classified as strong or weak based on whether it has a primary key that uniquely identifies its records.

Differences Between Strong and Weak Entities:

CREATE TABLE Orders (

OrderID INT PRIMARY KEY,

CustomerID INT

);

CREATE TABLE OrderDetails (

OrderDetailID INT,

OrderID INT,

ProductID INT,

PRIMARY KEY (OrderDetailID, OrderID),

FOREIGN KEY (OrderID) REFERENCES Orders(OrderID)

);

Orders is a strong entity (has OrderID as its own primary key).

OrderDetails is a weak entity (depends on OrderID for uniqueness).

Why Other Options Are Incorrect:

Option A (Association) (Incorrect): Associations describe relationships but do not define strong/weak entities.

Option C (Foreign key) (Incorrect): Weak entities depend on foreign keys, but primary keys define their status.

Option D (Cardinality) (Incorrect): Cardinality defines relationship constraints but does not differentiate entity types.

Thus, the correct answer is Primary key, as it is the defining characteristic between strong and weak entities.


Contribute your Thoughts:

0/2000 characters
Kenneth
1 day ago
I always get confused with these options!
upvoted 0 times
...
Lavonda
6 days ago
Wait, are we sure it's not C) Foreign key?
upvoted 0 times
...
Golda
11 days ago
Totally agree, it's all about the primary key!
upvoted 0 times
...
Delisa
17 days ago
I thought it was A) Association.
upvoted 0 times
...
Christene
22 days ago
It's definitely B) Primary key!
upvoted 0 times
...
Juliana
27 days ago
Cardinality sounds familiar, but I don't think that's the right answer here. I need to focus on the primary key concept for strong and weak entities.
upvoted 0 times
...
Luann
1 month ago
I feel like it might be foreign key, but that doesn't seem right for this question. I need to think more about the definitions.
upvoted 0 times
...
Mabel
1 month ago
I remember practicing a question about entity relationships, and I think it was about how weak entities rely on strong entities for their primary key.
upvoted 0 times
...
Long
1 month ago
I think the primary key is the main characteristic that differentiates strong and weak entities, but I'm not completely sure.
upvoted 0 times
...

Save Cancel