Search code examples
database3nf

Is the following table in 3NF?

I have the following table:

criteria -> (ID,COURSE,REIMBURSEMENTAMOUNT)

The REIMBURSEMENTAMOUNT attribute reflects the percent of the course cost that is reimbursed. I am afraid that this table is not in 3NF because the course depends on the ID and the reimbursement amount on the course. How can I solve this problem?

Solution

  • If Id is the id of the course, then why have both? Unless this is the only table where the name of the course is, then your table should just be:

    criteria -> (ID,REIMBURSEMENTAMOUNT)