Consider the following: I have two tables (Customers and Cases) defined as follows: **Customers** CustomerId (PK)
I just started learning about database normalization and I have a question about one of my tables. My database right now is structured horribly, and one of the reasons is because I have a table that l
I am trying to design the layout of the table to work best in the following situation. I have a product that is sold based on age. The age determines if that product exists for this person and the mi
I am (too) writing an mass email web based app. It is a concert organiser. I invite musical instrument players for each concert from a SQL DB and I need to track what happens with these people (mainly
I\'m developing an application that will have a parent class which will have many basic fields and methods,and several subclasses with additional fields methods.
I have a news table for 3 levels o开发者_JAVA技巧f users and there is a field called type in news table that holds corresponding level values. When users log into their panel, if there was news for th
The Problem We have a rapidly growing database with several large join tables (currently in the billions of rows), but as these tables have grown the query time has suffered.The concern is that as mo
I\'m trying to create database for contacts I need for every contact to have many catogries Like home Office
I have a (dummy) table structure as follows: ticket id: int(11) PK name: varchar(255) status: ????????? The question is, what data type should I use for status? Here are my options, as I see them:
Closed. This question is off-topic. It is not currently accepting answers. 开发者_如何学C Want to improve this question? Update the question so it's on-topic for Stack Overflow.
加载中,请稍侯......