Table with Too many Relationships

Posted on 2012-09-14
Last Modified: 2012-09-14
I am developing a sql database for an help desk application.  I am a little concern because my Ticket table have about 16 other relationships and I was wondering if the design is correct or should I break up the table?  See the attach file for the diagram.Database Schema
Question by:vnewman29
    LVL 68

    Accepted Solution

    In general, w/o regard to this specific design, 16 in and of itself is not too large a number of table relationships.

    In fact, if you fully normalize, you end up with way more tables than you'd have thought possible, even for a fairly routine-size design.
    LVL 26

    Expert Comment

    One observation that I have is in regards to 2 FKs in the Ticket. There are 2 tables, ProductOrServiceType and ProductOrServiceCategory, first as a child refers the second as parent. In this case I don't think the ticket table should have FKs to both these 2 table as it is the case in the diagram. It should only have a FK to ProductOrServiceType, which in turn refers to ProductOrServiceCategory.

    Probably there are other similar situations hence the number of FKs in Ticket table is more than it needs to be.

    Author Comment

    Zberteoc thanks for your comments.  I am removing some of those unnecessary FKs.
    LVL 26

    Expert Comment

    Well, if my comments were useful and you actually intend to follow them means that I would have been entitled to some points. :o)

    No problem but next time this happens make sure you split the points.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now