schema-design
Schema design: many to many plus additional one to many
I have this scenario and I\'m not sure exactly how it should be modeled in 开发者_开发知识库the database.The objects I\'m trying to model are: teams, players, the team-player membership, and a list of[详细]
2022-12-29 19:00 分类:问答Oracle Schema Design: Seperate Schema with I/O Overhead?
We are designing database schema for a new system based on Oracle 11gR1. We have identified a main schema which would have close to 100 tables, these will be accessed from the front end Java applicati[详细]
2022-12-28 12:57 分类:问答In SQL / MySQL, are there reasons not to put one-to-one relationship in the same table?
One-to-one relationship could usually be stored in the same table.Are there reasons not to store them in the same t开发者_JS百科able?Number and type of columns. There is a limit on the size of the col[详细]
2022-12-28 10:44 分类:问答Inheritance in XML Schema definition (XSD) for Java objects
I need to create an XML schema definition (XSD) that describes Java objects. I was wondering how to do this when the objects in question inherit from a common base class with a type parameter.[详细]
2022-12-26 20:43 分类:问答Monthly Reports in Django - Enforce uniqueness for month?
This is a fairly quick question regarding schema design for a Django project. Basically, we have a series of monthly reports from different departments that are aggregated into a single report with s[详细]
2022-12-20 07:54 分类:问答When is referential integrity not appropriate?
I understand the need to have referential integrity for limiting specific values on entry or possibly preventing them from removal upon a request of deletion. However, I am unclear as to a valid use c[详细]
2022-12-18 17:45 分类:问答Maintaining Consistency Between JavaScript and C# Object Models
I\'m working on an ASP.NET web application that uses a lot of JavaScript on the client side to allow the user to do things like drag-drop reordering of lists, looking up items to add to the list (like[详细]
2022-12-17 07:49 分类:问答Suggestions on how to organize Core Data visual layout?
Core Data is pretty amazing, and I\'ve really enjoyed using the visual layout Xcode provides for it to organize things and get a quick sample of what data I\'ve placed where.At times I\'ve started to[详细]
2022-12-14 14:32 分类:问答
加载中,请稍侯......