is this a good db design for a language center?

Best Microsoft Access Programmer Portland OR

In total I have 4 tables (Students, Staff, Classes, and Projects).

Students Table:

  • FirstName (Short Text)
  • LastName (Short Text)
  • BirthDate (Date & Time)
  • NationalIDNumber (Number or Large Number – Also PK)
  • Gender (Short Text)
  • Class (Number – FK Indicating Which Class Student Will Be In)

Staff Table:

  • FirstName (Short Text)
  • LastName (Short Text)
  • BirthDate (Date & Time)
  • NationalIDNumber (Number or Large Number – Also PK)
  • Gender (Short Text)
  • Role (Short Text?)
  • Salary (Number or Large Number)

Classes Table:

  • ID (Auto Increment – PK)
  • Name (Short Text – Each Class Has A Name Of A Famous City)
  • Teacher (?)
  • Budget (Number or Large Number)

Projects:

  • ID (Auto Increment – PK)
  • ProjectName (Short Text)
  • Date (Date & Time)
  • Supervisor (The ID of the teacher who supervised this project)
  • ClassID (The ID of the class which made this project)

What shortcomings do you see in the table, and what suggestions do you have?

submitted by /u/iEmerald
[link] [comments]

Microsoft Acess Developer Portland OR