Me and a database architect were having argument over if a table with a compound primary keywith subtypes made sense relationally and if it was 开发者_如何转开发a good practice.
Hey guys, This is a follow-up to a question that I asked earlier. It is my first time using a relational 开发者_JS百科database and I need help with a quick search string to bring up desired results.
I\'ve read many of the answers here about 1-1 relationships, modeling object-type relationships, etc.I am trying to do something that I\'m just not sure what is the right way.
Here\'s a DB schema: users(id, name); items(id, user, name), user is a foreign开发者_如何学编程 key
I want to write a query that presents for every event (tbl_events) all objects (tbl_objects) related to it (relation type — M:N).
I want to write a program, which creates RDBMS-tables through JDBC automatically. To add columns to a table, I need to know the name of the column and the column\'s RDBMS datatype. I already have the
All, MS sql Server supports CLR languages, Oracle Supports Java开发者_如何学C, What are other databases that support such (auxiliary) programming languages..
I am a professional designer that has done some databases. I would like some feedback on this on any big mistakes I am making in the table configurations and how the PK and FK relate.
As stated in the question, I\'m not looking for help on database design in the terms of creating tables, normalization, etc.
For the purpose of the question, let\'s imagine that I have a blogging application which consists of blogs and blog sub-entries related to the blog. My data i开发者_如何学运维s stored in a database in
加载中,请稍侯......