(Capcom's primary storyline)
Emmy's was a cafe in Raccoon City. It was located somewhere in the north of the city near a cinema and a diner.
Claire Redfield stopped at this cafe when she entered Raccoon City on September 29, 1998. Inside she was almost killed by a zombie, but ran out the side exit and was saved by police officer Leon S. Kennedy where they both escaped into a police car headed to the Raccoon Police Station.
Based on the appearance of the streets from inside and outside Emmy's, it does not appear to be the diner that also appears in the Resident Evil 2 intro and instead is a different building on the opposite side of the street.
Resident Evil 2 opening sequences