I am trying to normalize this table but I am not sure if I'm on the right track

  • Excellent job!  Looks much better than mine too!!

    Some minor adjustments:

    The PK for Ticket Response is ( Ticket Number, Ticket Response ID ) (in that order).  Yes, a PK can have more than attribute / column in it.  Ticket Number is also a FK (points to a "parent" table with that attribute as a unique key).  Ticket Response ID is not a FK, just part of the PK.

    Similarly for Ticket Cancellation, PK will be ( Ticket Number, Ticket Cancellation ID ).

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply