Considering the context presented, evaluate the following statements. I. In this ERD, the consultations table will receive foreign keys with the pa...

Considering the context presented, evaluate the following statements. I. In this ERD, the consultations table will receive foreign keys with the patient's id and the doctor's id. II. In this ERD, there will be a specific table with information about the exams. III. In this ERD, the doctor's table will receive a foreign key with the id of the exam. Considering the context presented, choose the correct alternative.

I. In this ERD, the consultations table will receive foreign keys with the patient's id and the doctor's id.
II. In this ERD, there will be a specific table with information about the exams.
III. In this ERD, the doctor's table will receive a foreign key with the id of the exam.
a) Only statements I and II are correct.
b) Only statements II and III are correct.
c) Only statements I and III are correct.
d) Only statement III is correct.
e) Only statement I is correct.

Modelagem de Dados

•

Outros

0

1

Questões para Estudantes

26/09/2023

Essa pergunta também está no material:

1 pág.

Analise o seguinte cenário em uma clínica médica

Modelagem de Dados • AnhangueraAnhanguera

João Paulo Vieira da Silva

💡 1 Resposta

Ed

26.09.2023

Considerando o contexto apresentado, a alternativa correta é a letra c) Apenas as afirmações I e III estão corretas. A tabela de consultas receberá chaves estrangeiras com o id do paciente e o id do médico, e a tabela de médicos receberá uma chave estrangeira com o id do exame.

0