4 Replies - 883 Views - Last Post: 29 May 2016 - 04:02 AM

#1 mnm458  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 85
  • Joined: 06-December 15

Is this Database design flaw free?

Posted 25 May 2016 - 06:41 AM

Here is my Database design for a software i am going to make in VB. before making, i want to make sure its flaw and fault free..

Thanks in advance!!Attached Image
Is This A Good Question/Topic? 0
  • +

Replies To: Is this Database design flaw free?

#2 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 879
  • View blog
  • Posts: 1,893
  • Joined: 30-January 09

Re: Is this Database design flaw free?

Posted 25 May 2016 - 08:24 PM

Without looking at the nature of your relationships (e.g. 1..1, 1..m, n..m), your diagram is extremely difficult to understand, largely due to two problems:
  • You have intersecting lines (not always avoidable, but you should try a different layout)
  • You have seemingly superfluous/random relationship lines (see below in red)

Have a look at your diagram compared to this excerpt from one of my applications:


Attached Image
(Your relationships in red don't seem to make sense as they don't describe a relationship between entities)

Attached Image
(The blue tables and dotted lines are proposed changes - once implemented, the number of intersecting lines will be very low)
Was This Post Helpful? 0
  • +
  • -

#3 mnm458  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 85
  • Joined: 06-December 15

Re: Is this Database design flaw free?

Posted 27 May 2016 - 11:57 PM

the first red line is there so the student table can identify the student's class teacher. the second one is there to link student IDs for the feedback... how can i fix it?
Was This Post Helpful? 0
  • +
  • -

#4 astonecipher  Icon User is offline

  • Too busy for this
  • member icon

Reputation: 2330
  • View blog
  • Posts: 9,381
  • Joined: 03-December 12

Re: Is this Database design flaw free?

Posted 28 May 2016 - 03:27 PM

Feedback on what exactly?

You can find the instructor of the student via the class table. They don't need a direct link.
Was This Post Helpful? 0
  • +
  • -

#5 mnm458  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 85
  • Joined: 06-December 15

Re: Is this Database design flaw free?

Posted 29 May 2016 - 04:02 AM

View Postastonecipher, on 28 May 2016 - 03:27 PM, said:

Feedback on what exactly?

You can find the instructor of the student via the class table. They don't need a direct link.

Ohk. the feedback for each question in the test. instead of marks, there will be letters. each letter represent a string which is then decoded in the application.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1