Good morning and hello to everyone.
So, i have to build a database of 1000 magazines.
1 table with name title_magazines
2 table with name the title_of_magazine (like M1,M2,M3, until M1000)
3 table with name Location (issued by)
4 table the dates.
I gave the names in my tables. The question is how can i connect these titles of my magazines with the dates ?
For example the magazine "Time" published in 1985 until 2000 and i have only the dates of 1987 1988 and 2000.
Also a magazine differ in the dates from other magazines. How can i build this database and how finally can i build a querry that will show me for example how many magazines exists in the decade 1980-1990 or how many magazines published in New York?
*the dates are from 1900 until 2000.
So, i have to build a database of 1000 magazines.
1 table with name title_magazines
2 table with name the title_of_magazine (like M1,M2,M3, until M1000)
3 table with name Location (issued by)
4 table the dates.
I gave the names in my tables. The question is how can i connect these titles of my magazines with the dates ?
For example the magazine "Time" published in 1985 until 2000 and i have only the dates of 1987 1988 and 2000.
Also a magazine differ in the dates from other magazines. How can i build this database and how finally can i build a querry that will show me for example how many magazines exists in the decade 1980-1990 or how many magazines published in New York?
*the dates are from 1900 until 2000.