Friday, 15 January 2010

sql - Database MN relationship -


I'm taking a class on database management systems (full beginner) and I'm working on a database very easy Blog system

I have a question about a M: N relationship between blog posts and categories, where the term (a blog post can be in many categories.)

The share of this plan looks like this:

I know that in some way this plan is a blog Allows to add posts that are not of any category. However, I do not know why this is. Can anyone explain this to me?

Thank you.

This is probably a combination of two things, one lacks the integrity referenced in your database design, i.e. you Foreign key is required. Secondly, your front end app is allowing blogs to be posted without categories.

No comments:

Post a Comment