relational-database
Should Foreign Keys be used in a structure where multiple options can be selected by a user? If so, how so?
In MySQL, I was advised to store the multiple choice options for \"Drugs\" as a separate table user_drug where each row is one of the options selected by a particular user.I was also advised to create[详细]
2023-04-11 03:26 分类:问答What are recent advances in relational databases? [closed]
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it's on-topic for Stack Overflow.[详细]
2023-04-10 23:33 分类:问答Which normal form does this table violate?
Consider this table: +-------+-------+-------+-------+ name|hobby1 |hobby2 |hobby3 | +-------+-------+-------+-------+[详细]
2023-04-10 20:18 分类:问答SQLServer - How to find dependent tables on my table?
Using SQLServer : I have a table user : id name email开发者_C百科 There are some other tables (about 200 more tables), some of which use user.id as foreign key on cascade delete.[详细]
2023-04-10 18:59 分类:问答MYSQL relational database
http://www.go4expert.com/forums/showthread.php?t=13386 im following the article above and i am getting error at the first quoted code[详细]
2023-04-10 18:46 分类:问答What database program can be used for this?
I\'m in a database cl开发者_Go百科ass. We\'re learning about joins, unions, and projections. Is there a program that would be helpful in getting practice? Like I an expression and it selects the appr[详细]
2023-04-10 13:04 分类:问答history table and 2nf
Users table and Group users table are history tables (they cannot be moved to archived tables cause that would mess up foreign keys related to those tables. If a group user made a post and left the gr[详细]
2023-04-10 09:06 分类:问答What is the correct mysql (relational) database design structure for
I have a table in my database called Resource. This has common information about a resource (a resource could be an article, a static web link, a YouTube video, or any number of other types).[详细]
2023-04-10 06:55 分类:问答Saving a large text chunk in a mysql table
I\'m building a music site. It has a lot of artists and tracks stored. I\'m planning to retrieve artist information from Wikipedia and store it on my server - somehow.[详细]
2023-04-10 04:19 分类:问答How to represent current state or status and maintain data/referential integrity? - Database Design
I have a table that maintains specific business transactions, let\'s call it LOANS. Each record can at any given time have one of several \"states\", for example \"in re-payment / open\", \"defaulted\[详细]
2023-04-09 08:15 分类:问答