Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I am writing a web page that displays students grades in an old grade book format which is to say, it displays the Student name, then their score for each assignment (in a row) then repeats one row pe
Do i need to setting the foreign key for this situation ? i\'m weak in database design, especially in mysql.. may i know if i want to setting foreign keys f开发者_如何转开发or them, what should i sett
I am fighting with myself trying to model a DB to fulfill certain requirements. There are two main entities.One is known as Team, think of a business or organization.The other will be an individual.
I am trying to normalize an address. The diagram below shows the relevant tables for this question I believe.I want to know how ZipCodes should be integrated into the model.This would be for internat
I know ruby (on rails) uses lots of \"magic\", but I use PHP, is there not a way of implementing the rails-like:
I want to understand performance merits/demerits in 开发者_Go百科using views instead of temporary tables in stored procedures in SQL Server.
I was hoping someone开发者_StackOverflow中文版 could tell me if this would be bad database design:
Say I have two tables: articles categories There\'s a many to many table that connects them. CREATE TABLE cat2art (
If you have a few join tables which contain all the information you need, but it involves some complex joins etc.etc. would it be bett开发者_如何学运维er to stick an extra field in your table of choic