hard20 pts · first answer countsdata-modellingkeys
Adding an id to an enrolment table
student_courses had primary key (student_id, course_id). A developer replaces it with a new id serial primary key and adds nothing else. What can now go wrong?
Discussion 0
Join free to post in the discussion.
Related questions
- 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
- Why denormalise a reporting tableData Engineer