Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    4

    help regarding my database design

    Hi, i am poor in database design. so please help me out. I will say the fields which appear in tables. you say the rest of details. In my database there are 4 tables.

    Table 1: Employees
    Description: Contains employee details
    Fields: EmpID, Name, Department, Grade, EmailID

    Table 2 : Training
    Description: Contains training details
    Fields: TrID, Title, Type, Status, Date, Trainername

    Table 3 : Nominations
    Description: Contains EmpID of employees who have registered for various courses.
    Fields: EmpID, TrID

    Table 4: Feedbacks
    Description: Contains feedbacks obtained for course
    Fields: TrID,Responses...

    help me out to design. which should be foreign key and so on. ms access is the database which i use.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Ask yourself this
    ____ Employee can have ____ Training
    E.g.
    Many Employeees can have many Training sessions

    And repeat for each table - post the results back here..
    George
    Home | Blog

Posting Permissions

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