I'd like someone to help me figure this out.
I have a small database: Country, State, City. Three tables.
I have to check that none of the names repeat themselves. Meaning, no two USA's, no two Brazil's, etc.
My professor also gave us the following requirement:
You can't delete a City entry that has a boolean set to true. God knows how to do this one. :P
Generate a list showing all the Cuntries you have with the respective population. So I'd have to add all the population in the cities that are in the countries states that are in the cuntrie. I guess I could do this by generating a table with only two columns.
I know, I know. This probably looks like a cheap attempt to have my homework done for me, but I assure you this little project is for 7 days from now so no rush. :P I've been a member here for quite some time, so I'm not gonna "hit it 'n' quit it".
If possible can someone give me a tecnical name for this sort of things in SQL. Or even better a link explaining some of them.
Thank you. :D