fineman_record

Tables (6)

Album

  • ISBN (Key) — int — Primary key — NOT NULL
  • Title (Key2) — varcjar(20) — Foreign key → Song.Title — NOT NULL
  • RegisteredDate (Field2) — Date

Instrument (Untitled)

  • InstrumentID (Key) — int — Primary key — NOT NULL
  • Type (Field) — varchar(10)
  • pitch (Field2) — varchar(10)

Musician

  • MusiciainID (Key) — int — Primary key — NOT NULL
  • Name (Field) — nvarchar(10)
  • Address (Field2) — varchar(20)
  • TelephoneNo (Field3) — varchar(15)

MusicianInstrument (Untitled4)

  • MusiciainID (Key3) — int — Foreign key → Musician.MusiciainID — NOT NULL
  • InstrumentID (Key) — int — Foreign key → Instrument.InstrumentID — NOT NULL

Producer (Untitled3)

  • ProducerID (Key) — int — Primary key — NOT NULL
  • ISBN (Key2) — int — Foreign key → Album.ISBN — NOT NULL
  • Title (Key22) — varcjar(20) — Foreign key → Album.Title — NOT NULL
  • MusiciainID (Key3) — int — Foreign key → Musician.MusiciainID — NOT NULL

Song (Untitled2)

  • Title (Key) — varcjar(20) — Primary key — NOT NULL
  • Author (Field) — varchar(20)