identifying entity type in database concepts

egovernment used Ask the Experts™

A weak entity must participate in an identifying relationship type with an owner or identifying entity type

What meaning of identifying entity type ?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
that means an entity type that uniquely identifies the weak entity.
For example,
consider a table of Orders and a table of OrderItems

The OrderItems is a weak type and is unique (identified) only for a specific order.

The OrderItems has then a foreign key to the table Orders

hope to be clear

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial