Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Table with Too many Relationships

Posted on 2012-09-14
Medium Priority
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
  • 2
LVL 70

Accepted Solution

Scott Pletcher earned 2000 total points
ID: 38399178
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 27

Expert Comment

ID: 38399482
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

ID: 38400010
Zberteoc thanks for your comments.  I am removing some of those unnecessary FKs.
LVL 27

Expert Comment

ID: 38400034
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

569 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