TCU Auditor Federal de Controle Externo — TI

TCU Auditor Federal de Controle Externo — Auditoria de TI (Brazil)

Data Engineering Ai AuditEnglish
Exam overview

Practice session

In relational database design for a public expenditure system, a table `TB_CONTRACT_ITEMS` has the composite primary key `(contract_id, item_seq)`. It contains the attribute `supplier_corporate_name`, which depends solely on `supplier_id` (a non-key attribute that depends on `contract_id`). What normal form violation is present, and what normalization step resolves it?

Loading your practice session…