Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Database Design Problems

    I'm currently trying to design a database for a website I'm creating but im running into a few problems. Hopefully someone can help!

    I have a "Lecturers" table which contains all their details, email ,name etc and a "Modules" table which contains Module Codes and Title's etc. The core problem i'm having in trying to include different features for different modules.

    Lets say I have one module that will have a news, a labs and a project feature(each of these features have their own separate tables aswell).

    Do I create a table called "Module" with the fields, moduleCode,newsID,labID,projectID ?

    I dont see how I can create a table of features, if each feature itself is a table with different fields to the next?

    Any idea's of how I should approach this are much appreciated !

  2. #2
    Join Date
    Sep 2002

    Re: Database Design Problems

    Can each module only have 1 of each "feature"? Or can a module have 2 news features, 5 lab features etc.?

    Can the exact same feature be shared by many modules?

    What sort of attributes do these features have?

Posting Permissions

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