3 Replies - 1599 Views - Last Post: 12 April 2007 - 06:55 AM Rate Topic: -----

#1 pfrauholle  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 08-November 06

Normalization - Database Design Problem

Posted 11 April 2007 - 03:06 AM

Hi everybody...I shall create a database for my as a student to store my work, finished assessments, page links and resources (eg. books etc) to it.

I came up with a design, but I've the feeling it's not quite right, because the document table which I created makes not longer sense to me, because it stores all the id from the other tables.

I think on a solution for it and it's may be so simple, but can't find the right way.

It would be very helpful, when somebody can bring me in the right direction. The screenshot of the tables it's loaded in the attachments.

Attached Image

Thanks for any help.

Cheers pfrauholle

Is This A Good Question/Topic? 0
  • +

Replies To: Normalization - Database Design Problem

#2 Trogdor  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 15
  • View blog
  • Posts: 627
  • Joined: 06-October 06

Re: Normalization - Database Design Problem

Posted 11 April 2007 - 07:31 AM

Is the document itself somewhere too? (in a blob field?)
Or just a link to it? Where is it?

The pagestructure table i am not sure of its usage.
Was This Post Helpful? 0
  • +
  • -

#3 pfrauholle  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 08-November 06

Re: Normalization - Database Design Problem

Posted 12 April 2007 - 03:35 AM

View PostTrogdor, on 11 Apr, 2007 - 07:31 AM, said:

Is the document itself somewhere too? (in a blob field?)
Or just a link to it? Where is it?

The pagestructure table i am not sure of its usage.


Thanks for getting me some help...I think I sorted it out already. I've splitted these tables into more than one databases and make that simple...it works so far...:-)

Thanks for help anyway...Cheers pfrauholle
Was This Post Helpful? 0
  • +
  • -

#4 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1858
  • View blog
  • Posts: 20,275
  • Joined: 17-March 01

Re: Normalization - Database Design Problem

Posted 12 April 2007 - 06:55 AM

View Postpfrauholle, on 12 Apr, 2007 - 04:35 AM, said:

View PostTrogdor, on 11 Apr, 2007 - 07:31 AM, said:

Is the document itself somewhere too? (in a blob field?)
Or just a link to it? Where is it?

The pagestructure table i am not sure of its usage.


Thanks for getting me some help...I think I sorted it out already. I've splitted these tables into more than one databases and make that simple...it works so far...:-)

Thanks for help anyway...Cheers pfrauholle



You mean split in to more than 1 table right? Normalization doesn't mean splitting in to multiple databases... now that really DOES complicate the issue.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1