Member Avatar for coxer

Hi,

There are two tables: instruments and descriptions. Not every instrument will have a description, no instrument can have more then one description, and obviously there can' t be a description for no instrument. So I use a 1:1 identifying relationship here and it looks like instrument_id can act both as primary and foreign key for the "descriptions" table. Is this so?

Thanks.

  • 2 Contributors
  • 1 Reply
  • 61 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

Your design isn't correct! sorry for that but the description would be attribute in Instruments table and would be nullable because there're some instruments haven't description!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.