Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ASSIGNMENT In this assignment, you are expected to develop and implement the necessary database design for one of the application scenarios given below; . In

image text in transcribed

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 Sahibinden.com . Yemeksepeti 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Knowledge Discovery In Databases

Authors: Gregory Piatetsky-Shapiro, William Frawley

1st Edition

0262660709, 978-0262660709

More Books

Students also viewed these Databases questions