Gossamer Forum
Home : Products : DBMan SQL : Pre Sales :

questions about relational databases

Quote Reply
questions about relational databases
Hi,

I have some questions about how relations are supported (I will use authors and books as expamples in my questions):
- Does the system fully support many to many relations?
- When a user is at the overview page of an author, can I add a link to the list of books written by that author?
- When a user is at the overview page of a book, can I add a link to the author of that book?
- When a user is at the overview page of an author, can I add a link to add a book by that author (so the user does not have to know/remember the author id)?
- Is it possible to add a combobox with all authors in the 'edit book' page? (I would actually use this for adding a combobox of countries from a table of countries)
- is it possible to disallow to change the author of a book?
- is it possible to only allow adding a new book from the 'add book' link on the 'show author' page?
- where can I find a demo of a database where relations are implemented as mentioned above?

One unrelated question. My current (pgsql) database is used in many ways, so I cannot change or add any column to the current tables. What are the requirements for these tables?

Thanks for your help!
Subject Author Views Date
Thread questions about relational databases jaspercram 4684 Sep 13, 2002, 2:47 AM
Thread Re: [jaspercram] questions about relational databases
604 4625 Sep 13, 2002, 12:31 PM
Post Re: [TheStone] questions about relational databases
charly 4595 Sep 14, 2002, 11:35 PM
Post Re: [TheStone] questions about relational databases
jai 4592 Sep 15, 2002, 4:34 PM
Post Re: [TheStone] questions about relational databases
jaspercram 4567 Sep 17, 2002, 4:37 AM
Thread Re: [TheStone] questions about relational databases
hennagaijin 4490 Oct 4, 2002, 2:40 PM
Post Re: [hennagaijin] questions about relational databases
hennagaijin 4381 Oct 14, 2002, 8:52 AM