hard20 pts · first answer countsdata-modellingnormalisation
3NF but not BCNF
In enrolments(student, subject, teacher), each teacher teaches exactly one subject, and a student takes each subject from one teacher. The key is (student, subject). What is its normal form?
Discussion 0
Join free to post in the discussion.
Related questions
- Goal of normalisationData Engineer
- Primary key for order linesData Engineer
- Modelling doctors and patientsData Engineer
- Several phones in one columnData Engineer
- Several unique columnsData Engineer
- Picking the natural keyData Engineer
- Reading crow's foot notationData Engineer
- The model with indexes and typesData Engineer