Programming ASP. net2.0 ado.net started in the actual project (1)

VOD Development
VOD big classification, using voddepart table
VOD topic category, which is in the vodcategory table
VOD program form, with vodprogram table

Voddepart stores large topics, such as entertainment, news, finance, and sports.
The vodcategory table stores names of some TV columns.
The vodprogram table stores some specific on-demand tables.

Voddepart and vodcategory are one-to-one relationships.
Vodcategory and vodprogram are many-to-many relationships.

-----------------------------------------
|
| Voddepart | <------> | vodcategory | <----------> | vodprogram |
|... |
| <----------> |
--------------------------------------------

Voddepart table
Id int 4
Technical title varchar 200
Includesc varchar 4000

Vodcategory table
Categoryid int 4
Categorytitle varchar 200/* directory name **/
Categorydesc varchar 4000/* directory Description */
Promotion int 4/* Recommended directory or not */
Imageurl varchar 200/* Image Description of the Directory */
Voddepartid int 4/* associated voddepart ID */(foreign key FK)

Vodprogram table
Id int 4
Programtitle varchar 200
Programdesc varchar 8000
Promotion int 4/* Recommended directory or not */
Imageurl varchar 200
Programurl varchar 200
Vodcategoryid int 4

 

Note that we want vodcategory to be configured with vodprogram but cannot provide such a relationship in SQL 2000. Therefore, we need to introduce an intermediate table between vodcategory and vodprogram, to provide the relationship between the two parties.