Sample query question:

Design two database tables, part and equipment, where multiple parts can be installed on one piece of equipment, and several pieces of equipment may use the same part. Write an example query to find how many pieces of equipment use a given part.

Question

Sample query question:

Design two database tables, part and equipment, where multiple parts can be installed on one piece of equipment, and several pieces of equipment may use the same part.  Write an example query to find how many pieces of equipment use a given part.

Sigiloso · Accepted Answer

Many-to-many relational table - using an associative table (called EQPART). I did outer joins with a count.

PTC

Pergunta de entrevista da empresa PTC

Resposta da entrevista

Empresas seguidas

Buscas de vagas