ASSIGNMENT In this assignment, you are expected to develop and implement the necessary database design for one of the application scenarios given below; In the given assignment, you must first express the table and relations of the design you developed on an E-R diagram. Then, by creating the necessary tables and relations for the database on PostgreSQL, you need to enter 10 data in each table for the application scenario. After adding the data to the database, you should write the 10 most important queries required in the application scenario and include the screenshots of the results in the report you will prepare. The report you will prepare should be written in 12 font size and Times New Roman type and submitted in PDF format. E-R diagram, explanation of the application scenario, explanation of 10 selected query processes, SQL queries and the outputs of the related queries should be included in the report. Assignment can be done in groups of maximum three people.

Application Scenarios: Instagram

Twitter YouTube Netflix Ebay Any newspaper app or website

BONUS: If you develop a console, web, desktop or mobile application for your application scenario by communicating the database you have developed with any programming language, your homework will be evaluated over 130 points.