I am using SQL Server 2008. I am setting up a new database to store music album information.I need to know the best way to set up my tables and need some input.Let me give you some defintions so that
I have been given the task to design and develop a web application for a NGO (Non Govt Org) which runs primary schools in many towns and villages. The application will keep a record of all the schools
I have a validation table Person Type with fields type_id and type. In the type filed开发者_如何学JAVA I need to store the following values: PubCrsAtt, Health Professional, Trainee, Qualified Trainer,
This question already has answers here: Closed 11 years ago. Possible Duplicate: Should each and every table have a primary key?
I have table Person. One person can have many siblings from the same table. I have a hard time understanding on how to do this design, because If I do recursive relationship I can only add on开发者_JA
I have a system for booking with lots of member sites that offer information to allow people to use our site to book with them.
We have a table that contains the valid currency codes. We are choosing to use a numeric value as the primary key rather than a 3 char ISO Currency code, for example.
I know for sure that Google does not use mysql, but in my case I happen to work on a project using mysql and has features that are very similar to circles:
This is a data structure/mapping question. I\'m using MSSQL, with .NET and EF (and MVC if that\'s important). I have a table that represents a deck of cards. The states of a card are:
My application keeps receiving a really small event that it needs to store and I was thinking which is the best way to handle it. T开发者_运维问答he table for this event would be something like this: