TCU Auditor Federal de Controle Externo — TI
TCU Auditor Federal de Controle Externo — Auditoria de TI (Brazil)
Data Engineering Ai AuditEnglish
Exam overviewPractice 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…