Transcribed image text: Hiking Schema HIKES(hiker.mountain) INHABITS(animal.mountain) EATS(hiker,animal) 1.1) Algebra. Print the animals that Scott eats that inhabit at least one mountain that Scott hikes. 1.2) Algebra. Print the animals that inhabit all of the mountains that Scott hikes. 1.3) Algebra. Print the hikers that hike all mountain that are inhabited by an animal that they eat. 1.4) Calculus. Print the animals that Seott eats that inhabit at least one mountain that Scott hikes. 1.5) Calculus. Print the hikers that hike all mountain that are inhabited by an animal that they eat. 2) Designing a Social Media System (SMS) Database Given the semantics described below for a social media database, answer the following questions Social Media Design Requirements: Advertisers: Purchase advertising according to the interests of users Advertisers can link their products to types of posts that are of interest to users. For example an advertisement for food would be linked to users who read or post food content, Advertisements then appear in content streams presented to users, but users do not necessarily view all of the ads. They only view the ones they select by clicking on them. Products: Products are advertised by the advertiser that produces them. Products are categorized by type: food, cars, or movies. Of course there is a desctiption of the product, which for the initial design can be a text file. Censors: Censors review user posts and produce a ratings and comments for cach product that may be incorrect or inflammatory Users: Users may view posts that are related to products through their content. If a user is interested in food, the food | posts and advertisements appear in the user's stream of incoming content. Users post content into one or more of the categories (food, cars, movies). Posts: All posts are reviewed by censors. No further review is needed if 3 censors give a rating of 1 or less to a post. Additional censors must review a post if any of the censors rate it between 2 and 4. If 5 reviewers rate a post between 2 and 4, the post is flagged with a warning, "This post may be incorrect or inflammatory". If 6 reviewers rate a postat above the 4 level, the post is removed. If 8 reviewers rate a post at a level higher than 8. the user who posted it is banned from the SMS. Content:Types include: food, cars, and movies 2.1) Give an E-R diagram for the social media database (be sure to indicate types of relationships, ie. m:n, 1in, etc.). You may add attributes, as needed, but be careful to do not restrict the meanings of the entities and relationships as described. 2.2) Discuss any tradeoffs that you consider and assumptions that you make in arriving at your design. 2.3) Develop a relational schema, based on the E-R diagram from part 2.1. 2.4) Write an SQL query to list the posts that should be flagged with a warning and the user who posted them. 2.5) Write an SQL query to produce a report for all advertisers, showing all users with any posts that have been censored for each advertiser's products.
