SQL language

or a Movies database with a person entity with attributes pid (key), fname, Iname, suppose we want to add some publicity-related info for which media have done interviews or hich are scheduled to do interviews. We would want to include the unique media name (ex: "Entertainment Tonight"), the media type (ex: "TV", "print", or "web") and date of the terview. How might this be modeled? Create an entity for Media with attributes for media name and type and have a many-to-one relationship between Media and Person Create an entity for Media with attributes for media name and type and have a one-to-many relationship between Media and Person Add attributes for media name, type and interview date to Person Create an entity for Media with attributes for media name and type and have a many-to-many relationship between Media and Person