This topic is locked

creating a project for academic staff

5/29/2008 3:41:00 AM
PHPRunner General questions
U
uludag author

Hi,

I am just planning to create a database project for staff of a university.

There are several tables:

  1. personal information (name, surname, e-mail, web page, academic title, departmen, picture)
  2. books (book name, publication place, publisher, publication year)
  3. articles (article name, journal name, publication place, publication year, volume, number, pp)
  4. presentations (symposium paper name, symposium name, place, year)
    Of course, a person in my project has several books, many articles and presentations.

    When I join these tables, there appear different forms. A form for a book, a form for another book, etc.

    What I want to do is that:
    Name, Surname, Title, picture,

    Department,
    Books:
    Articles:
    Presentations:
    Can I do that with phprunner? If not, what do you advise?
    Sincerely,
    Uludag.

T
thesofa 5/29/2008

Wouuld I be right in thinking that one book or article could have more than one author too?