partial dependency transitive dependency repeating group pri

       partial dependency
       transitive dependency
       repeating group
       primary key

Q2: In the figure below, the OrderLineItems entity is there to implement what type of relationship between Orders and Products?

Q3:

       Foreign key
       Not null
       Single field primary key
       Composite primary key

Q1: A _____ means that a nonprime attribute is functionally dependent on only part of a table’s primary key but not the entire primary key.

Orders OrderLineltems Products Order D OrderD te Ordel D OrderSequence ProductID ProdudtID ProdutNam e

Solution

ANSWER:

Q1: a) partial dependency

Q2: c) Many to Many

Q3. d) Composite primary key