Does anybody possess a database for articles in a magazine?.I think this kind of database is widely used
and i possibly might use the idea of a more experienced person.
I have to make up a database containing the articles for each issue( or number) of the magazine. So i think i will need at least 2 basic tables :
Issues and Articles. Each issue of the magazine will contain different articles, therefore the table issue must not have an autonumber.But how can i relate it to the table Articles?
The table articles must contain: title,author,issue number,pages,translation,notes,etc.
The table issue must contain : number of the magazine, year of the magazine.
So thse at least are our ideas about the tables.
What is the best way to create the relationships between the databases.And also, is there a ready make example to have a look for better ideas ?