I have an application that associates users with specific groups in a Facebook-style manner. For example:
i have the following requirement Sales Officer: Bob Week1 Week2Week3 ................. Week52 Prod1101512.................14
I have to save this information in a database Person -> is married to -> Person Wh开发者_如何学JAVAere should I save that information? What is the proper design pattern should I apply here?
DB world is not mine, so perhaps the question is trivial Imagine designing a DB that store data from different kinds of items (like datatypes)
I\'m trying to display all the boards in a certain category, but I\'m having trouble with the SQL query. I want it to go through all the posts in a certain category, take in the user id from that, fin
We are working on a mapping application that uses Google Maps API to display points on a map. All points are currently fetched from a MySQL database (holding some 5M + records). Currently all entities
This not homework!It is on a study guide as practice and i\'m lost.Any help much appreciated, not looking for just answer but how to get to it.
A scenario: In my database I have a table joining Customers and Movies together, with an extra field specifying the weight of the relation. EG:
I have a typical table, e.g. id(int) name(varchar) address(varchar) date(datetime) I also have a table that references validation functions for each one, e.g.
I\'ve asked a few questions lately regarding database design, probably too many ;-)However I beleive I\'m slowly getting to the heart of the matter with my design and am slowly boiling it down.I\'m st