Alex
Reputation: 1
Can a transitive dependency be in table that has a composite primary key?
Can a transitive dependency be in a table that has a composite primary key?
Would that be a partial dependency?
For 3NF do we have to have no partial dependencies so no composite primary key?
Upvotes: -1
Views: 13
Answers (0)
Related Questions
- What is the "N+1 selects problem" in ORM (Object-Relational Mapping)?
- Insert into ... values ( SELECT ... FROM ... )
- Reset identity seed after deleting records in SQL Server
- Difference between partition key, composite key and clustering key in Cassandra?
- Can table columns with a Foreign Key be NULL?
- What are the options for storing hierarchical data in a relational database?
- Should each and every table have a primary key?
- Can I have multiple primary keys in a single table?
- Use email address as primary key?
- Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)