Given the Employee, Class, and Training tables.EmployeeEmp_id (PK)EM8765AddressUSANamePhoneEmailAliali@yahoo.comnazire@gmail.comkatrina@gmail.comlemi@hotmail.comalican@yahoo.commustafa@hotmail.comhasan@gmail.com98733211ЕМ3456NazireDubai9876453390857464EM7658KatrinaUSAEM1987LemiUSA99663425EM8009AlicanUK95583372|EM7698MustafaDubaiJordan92234452EM6666Hasan92123366ClassClass_id (PK)Class_nameMultimediaCreditСOM106COM206Databaseсомз06Public Speaking9.Training TableEmp_id (FK)EM8765DateClass_id (FK)Result05-May-201008-May-201108-Feb-201008-Feb-2010соM106PassEM3456COM206PassEM7658сомз06FailEM1987сомзо6Fail28-Jan-201110-March-2012EM8009сомз06PassEM7698сом106FailEM876508-May-2011сOM206PassWrite the appropriate SQL queriesa) Get the address of employee whose name is Alicanb) Get the name and email of employees located in Dubai. Sort the results inalphabetical 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 Tablee) 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.

Below is the solution all parts step by step: a) Employee Address for Name = ‘Alican’ SQL: Output:

Given the Employee, Class, and Training tables. Employee Emp_id (PK) Name Address Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.c hasan@gmail.com EM8765 USA 98733211 EM3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 Alican Mustafa Hasan EM8009 UK 95583372 EM7698 Dubai 92234452 EM6666 Jordan 92123366 Class

Given the Employee, Class, and Training tables. Employee Emp_id (PK) Name Address Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.c hasan@gmail.com EM8765 USA 98733211 EM3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 Alican Mustafa Hasan EM8009 UK 95583372 EM7698 Dubai 92234452 EM6666 Jordan 92123366 Class

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

How the DBMS determines which queries to optimise and how much time this saves the DBA is based on those criteria.
List some of the advantages of SQL
Please don’t reject this professor
Customer ID 123 4 5 6 7 8 9 10 Items of transaction {A,B,E,D}{A,C,D,E}{D,E,A} {E,B,A,C} {B,B,E} {A,E,B} {E,D,E,C} {D,C} {B,D,E} {C,D,E,A} (a) Use the table shown to compute the support for the itemsets {B,D} and {B,C,E}. (b) Use the results in part (a) to compute the confidence for the association rules {b,d} {e} (c) How many itemsets can be generated from these items(d) How many association rules can be generated from the itemset {A,B,C,D,E,F}?
SQL Injection is the term used to describe an attack against a SQL database.
What is redundancy?
DATABASE SYSTEMS AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, even though it already has many branches and a large number of order transactions every day, AllTaste Restaurant does not yet have an application and database to manage transactions and data. Order recording and sales reports are still done manually. AllTaste Restaurant owners know that information technology can support their business, so they plan to build applications to serve food orders both offline and online. In the database design stage, it is known as bottom-up, top-down, and inside-out approaches. Explain the three approaches! In your opinion, what approach is used for database system development at AllTaste Restaurant? Explain why you chose this approach! What techniques do you use to collect information (fact-finding technique)?…