1 SQL-ABFRAGE WIRD UNTER VERWENDUNG DER OBEN TABELLEN GESCHRIEBEN.(Tabellen müssen eine einzelne Abfrage mit Join sein)UND IM ERGEBNIS DER ABFRAGE SOLLTEN FOLGENDE DATEN AUSGEGEBEN WERDEN.-----ANGEGEBENE TABELLEN-‒‒‒‒TELEFON, MAIL, NATIONALITÄTSNAME, PRODUKTNAME, PRODUKTCODE, STARTDATUM, ABLAUFTABELLENNAME: VERBLEIBENDFELDER: PRODUCT (Optional: False), USER (Optional: False), PK, STARTDATE (Optional: False), EXPIREDATE (Optional: False)TABELLENNAME: BENUTZERFELDER: PK, NATIONALITÄT (Optional: True), NAME (Optional: False), MAIL (Optional: False),TELEFON (Optional: Falsch)TABELLENNAME: STAATSANGEHÖRIGKEITFELDER: PK, NAME (Optional: False)TABELLENNAME: PRODUKTFELDER: PK, NAME (Optional: False), CODE (Optional: False)ENGLISH OF THE TEXT1 SQL QUERY WILL BE WRITTEN USING THE TABLES ABOVE.(Tables must be a single query with join)AND AT THE RESULT OF THE QUERY, THE FOLLOWING DATA SHOULD BE OUTPUT.PHONE, MAIL, NATIONALITYNAME, PRODUCTNAME, PRODUCTCODE, STARTDATE, EXPIREDATE-TABLES GIVEN---➖➖TABLE NAME: REMAININGFIELDS : PRODUCT (Optional: False), USER (Optional: False), PK, STARTDATE (Optional : False), EXPIREDATE (Optional: False)TABLE NAME: USERFIELDS: PK, NATIONALITY (Optional True), NAME (Optional: False), MAIL (Optional: False),PHONE (Optional: False)TABLE NAME: NATIONALITYFIELDS: PK, NAME (Optional: False)TABLE NAME: PRODUCTFIELDS: PK,NAME (Optional: False), CODE (Optional : False)

The SQL query is given below using join. As the data is not given in the question so the output…

1 SQL QUERY WILL BE WRITTEN USING THE TABLES ABOVE. (Tables must be a single query with join) AND AT THE RESULT OF THE QUERY, THE FOLLOWING DATA SHOULD BE OUTPUT. PHONE, MAIL, NATIONALITYNAME, PRODUCTNAME, PRODUCTCODE, STARTDATE, EXPIREDATE -TABLES GIVEN-- TABLE NAME: REMAINING FIELDS PRODUCT (Optional: False), USER (Optional: False), PK, STARTDATE (Optional :False), EXPIREDATE (Optional: False) TABLE NAME: USER FIELDS: PK, NATIONALITY (Optional: True), NAME (Optional: False), MAIL (Optional: False), PHONE (Optional: False) TABLE NAME: NATIONALITY FIELDS: PK, NAME (Optional: False) TABLE NAME: PRODUCT FIELDS: PK, NAME (Optional: False), CODE (Optional: False)

1 SQL QUERY WILL BE WRITTEN USING THE TABLES ABOVE. (Tables must be a single query with join) AND AT THE RESULT OF THE QUERY, THE FOLLOWING DATA SHOULD BE OUTPUT. PHONE, MAIL, NATIONALITYNAME, PRODUCTNAME, PRODUCTCODE, STARTDATE, EXPIREDATE -TABLES GIVEN-- TABLE NAME: REMAINING FIELDS PRODUCT (Optional: False), USER (Optional: False), PK, STARTDATE (Optional :False), EXPIREDATE (Optional: False) TABLE NAME: USER FIELDS: PK, NATIONALITY (Optional: True), NAME (Optional: False), MAIL (Optional: False), PHONE (Optional: False) TABLE NAME: NATIONALITY FIELDS: PK, NAME (Optional: False) TABLE NAME: PRODUCT FIELDS: PK, NAME (Optional: False), CODE (Optional: False)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.
First normal form says: a. No nonkey columns depend on another nonkey column b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above
Student(Id, name, age, class, grade) Write SQL server query to retrieve all the student in class 6
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
In java create an application to manage your data base information the database is already created in mysql tables, the tables are fill, So the user can use your database application user friendly Retrieve all data: Given a table name, retrieve all data from the table and present it to the user. Average: Given a table name and a column name, return the average of the column. Here the assumption is that the column type will be numeric (e.g., cost column). Insert: Given a table name, your program should show the column names of that table and ask the users to input new data to the table. In case of errors, your program should directly show the MySQL errors to the users. Assumption 1: Users will enter data according to the database constraints. Assumption 2: Users will input one record at a time. Delete: Given a table name, your program should show the column names of that table and ask the users to input data that they want to delete. Assumption 1: Users will enter data according to the…