Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2012
    Posts
    3

    Help with Database task

    Hi guys, this is a relational diagram of what I have done for an assignment..
    Totally lost on this. Any tips of how I could improve on this so that I wouldn't encounter serious problems while inputting data in these using Microsoft Access? We are required to include dummy datas and create forms for this later on..
    Attached Thumbnails Attached Thumbnails Data.png  

  2. #2
    Join Date
    Aug 2008
    Posts
    140
    Is the Student.SubjectSchedule correct? Could you elaborate on the SubjectSchedule?
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  3. #3
    Join Date
    Dec 2012
    Posts
    3
    It is so that the student and teacher have data for the time of the class.. Is there a problem there?

  4. #4
    Join Date
    Aug 2008
    Posts
    140
    I understand - that makes sense. By implication , the student has one subject schedule.
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  5. #5
    Join Date
    Dec 2012
    Posts
    3
    yea, I removed the subject schedule, seemed repetitive I guess.. really lost now, changed some stuff, seems to be more messed up, lol
    Attached Thumbnails Attached Thumbnails Untitled.png  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •