Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2016

    Question Need help with db Design

    I'm new to the forum, have a basic knowledge of databases, but need some help with the best way to structure a results database for the college I work in.

    Up to now our results have been recorded on paper. For our external examiners we have to record the grades twice, on two different types of report. I want to create a database to allow staff to fill in the grades once but with the ability to output both reports. I have attached the two reports so you can see what I'm talking about.

    Report 1 is the Mastersheet. Each student has a "Mastersheet" which contains all of their grades for all assignments in all Classes.

    Report 2 is the Class Results sheet, which records the grades of all students within a particular Class.

    The database is as follows:
    The college has many students.
    Each student is enrolled in 16 Classes.
    Each Class has many assignments. Each Assignment has 5 possible results: D, M, P, U and R.

    When all of the results have been input I need to be able to output the 2 different types of reports attached.

    The front-end part of the database is not a problem for me. I'm not sure, however, how many tables I need and how to relate them.

    Apart from the Class Titles, Assignment Titles and Grades etc., the only other fields I need to include are "Student Name" and "Student ID". Is it possible to create this without having to make a separate database for each student?

    Any help would be greatly appreciated.

    Thanks, Mick See
    Class Results Sample.pdfMastersheet Sample.pdf

  2. #2
    Join Date
    May 2016
    Hi Mick See

    For modeling correctly a db (See example on this dbforums post

    1. build a conceptual data model (CDM). The Logical data model is very simple then to generate. With tools, the LDM is automatically built as well as the SQL script for creating the DB
    2. Use dedicated tools which build CDM not only LDM like :
      1. Power*AMC (excellent but expensive)
      2. JMERISE, excellent freeware here

    And of course apply at least the 3 first Normal forms (NF).

Tags for this Thread

Posting Permissions

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