Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Q: INSTRUCTIONS  Using spreadsheet software enter the following table below that shows the number of…
A: Organization and display of tourism information is crucial to understanding trends and making…
Q: Using mysql client   create a database named supermarket   create a table named groceryitems in…
A: CREATE DATABASE supermarket; USE supermarket; CREATE TABLE groceryitems (  itemname VARCHAR(50)…
Q: Consider the following two tables: Tablel: Customers customerID Fname 100 101 Lname Amri Kalabani…
A: 1)Inner Join- Selects matching data from customer and orders.
Q: Q1) you have the following table given below: CUSTOMER Customer ID - Gender phone - Address -…
A: Syntax to create view.  create view viewName as select colName from tableName;
Q: d) Create the Crow's Foot ERD to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC.
A: The question asks you to create a Crow's Foot Entity-Relationship Diagram (ERD) to show the…
Q: Ensure the Employee Satisfaction worksheet is active, then use the FREQUENCY function to calculate…
A: 1. Add in the formula for these as such =FREQUENCY(C2:C10,F5:F9) • Do, change it according the…
Q: Table Name:- Employee Empid EmpName Department ContactNo EmailId EmpHeadId 101 Isha E-101…
A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…
Q: 1. In the Orderltems table, display a count of the number of products with a prod_id of BR01.…
A: To display the count of products with a prod_id of BR01 from the OrderItems table with the given…
Q: Rental Date Film Quantity Film Rental Customer Customer Customer Name Email ID ID Name ds@gmail.com…
A: Task : Given the table. The task is to normalize the table.
Q: Department Employee • Code Name Manager .ID Name Salary 44 Engineering 2538 2538 Lisa Ellison 45000…
A: Referential integrity is a critical aspect of database design, ensuring that relationships between…
Q: 6. List the number of department of employees in each project. 7. How many project started in year…
A: CREATE TABLE Employee( Empid int, EmpName varchar(255), Department varchar(255), ContactNo int,…
Q: What are the codes for this case? Emergency Department Patient Case Number: ED16-White, Salem…
A: In this question we have to define codes related to a patient case in the emergency department.…
Q: Enter ID: Add ID ID 123 abc 123abc abc123 54321 Remove All Item Name Price Number of Rows: 5
A: The HTML CSS JS code is given below with output screenshot
Q: INSTRUCTIONS  Using spreadsheet software enter the following table below that shows thenumber of…
A: The objective of the question is to create a spreadsheet that displays the number of tourists…
Q: Q9. Write an SQL statement to answer the question: 'Are there any bookings not driven by qualified…
A: Hey there, I am writing the required solution for the above stated question.
Q: How many postings has each person created for each site?
A: Given: How many postings has each person created for each site?
Q: Which is a search string used to identify a terrorist group within a specific country? Group of…
A: The above question that is string to identify the terrorist group in a specific country is answered…
Q: 2. What is a syntax tree? Draw the syntax tree for the expression a*(b+c)*d.
A: SYNTAX TREE: An abstract syntax tree (AST) is a tree representation of the abstract syntactic…
Question
100%
Given the Employee, Class, and Training tables. Employee Emp_id (PK) EM8765 Address USA Name Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.com hasan@gmail.com 98733211 ЕМ3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 EM8009 Alican UK 95583372 |EM7698 Mustafa Dubai Jordan 92234452 EM6666 Hasan 92123366 Class Class_id (PK) Class_name Multimedia Credit СOM106 COM206 Database сомз06 Public Speaking 9. Training Table Emp_id (FK) EM8765 Date Class_id (FK) Result 05-May-2010 08-May-2011 08-Feb-2010 08-Feb-2010 соM106 Pass EM3456 COM206 Pass EM7658 сомз06 Fail EM1987 сомзо6 Fail 28-Jan-2011 10-March-2012 EM8009 сомз06 Pass EM7698 сом106 Fail EM8765 08-May-2011 сOM206 Pass Write the appropriate SQL queries a) Get the address of employee whose name is Alican b) Get the name and email of employees located in Dubai. Sort the results in alphabetical order of name. c) Show the count of employees that stored in Employee Table. d) What is the minimum, maximum, average and total values of credit in Class Table e) Show the Emp_id and Result column of Training table which class_id is 'COM106' and "COM206' by using IN function. f) Show the employee(s) whose email account is gmail. 8) (10 Mark) List Name, Email, Class Name and Result of employees.
expand button
Transcribed Image Text:Given the Employee, Class, and Training tables. Employee Emp_id (PK) EM8765 Address USA Name Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.com hasan@gmail.com 98733211 ЕМ3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 EM8009 Alican UK 95583372 |EM7698 Mustafa Dubai Jordan 92234452 EM6666 Hasan 92123366 Class Class_id (PK) Class_name Multimedia Credit СOM106 COM206 Database сомз06 Public Speaking 9. Training Table Emp_id (FK) EM8765 Date Class_id (FK) Result 05-May-2010 08-May-2011 08-Feb-2010 08-Feb-2010 соM106 Pass EM3456 COM206 Pass EM7658 сомз06 Fail EM1987 сомзо6 Fail 28-Jan-2011 10-March-2012 EM8009 сомз06 Pass EM7698 сом106 Fail EM8765 08-May-2011 сOM206 Pass Write the appropriate SQL queries a) Get the address of employee whose name is Alican b) Get the name and email of employees located in Dubai. Sort the results in alphabetical order of name. c) Show the count of employees that stored in Employee Table. d) What is the minimum, maximum, average and total values of credit in Class Table e) Show the Emp_id and Result column of Training table which class_id is 'COM106' and "COM206' by using IN function. f) Show the employee(s) whose email account is gmail. 8) (10 Mark) List Name, Email, Class Name and Result of employees.
Expert Solution
Check Mark
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
See solutionCheck out a sample Q&A here
Step 1
VIEW
Step 2
VIEW
Step 3
VIEW
Step 4
VIEW
Step 5
VIEW
Step 6
VIEW
Step 7
VIEW
bartleby

Step by stepSolved in 7 steps with 9 images

See solution
Check out a sample Q&A here
Blurred answer
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
SEE MORE TEXTBOOKS