User_id Last_name First_name Phone.no Email Book_id U513 Mahara Kapil 647-555-1151 phantomconflicted@gmail.com 003 U514 Bhatta Bikas 434-568-1051 bikas434@Yahoo.com 001 U515 Ford Richard 134-091-5122 Ford22@gmail.com 002 U516 Bhattarai Bikram 647-887-2078 Everest.sbm@yahoo.com 005 U517 Bhoj Biraj 603-788-1072 regmi@gmail.com 004 Normalize the table above upto third normal form (3NF)

User_id Last_name First_name Phone.no Email Book_id U513 Mahara Kapil 647-555-1151 phantomconflicted@gmail.com 003 U514 Bhatta Bikas 434-568-1051 bikas434@Yahoo.com 001 U515 Ford Richard 134-091-5122 Ford22@gmail.com 002 U516 Bhattarai Bikram 647-887-2078 Everest.sbm@yahoo.com 005 U517 Bhoj Biraj 603-788-1072 regmi@gmail.com 004 Normalize the table above upto third normal form (3NF)

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter6: Creating, Sorting, And Querying A Table

Section: Chapter Questions

Problem 2EYW

See similar textbooks

Similar questions

CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…
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…
Table Name:- Employee Empid EmpName Department ContactNo EmailId EmpHeadId 101 Isha E-101 1234567890 isha@gmail.com 105 102 Priya E-104 1234567890 priya@yahoo.com 103 103 Neha E-101 1234567890 neha@gmail.com 101 104 Rahul E-102 1234567890 rahul@yahoo.com 105 105 Abhishek E-101 1234567890 abhishek@gmail.com 102 Table :- EmpDept DeptId DeptName Dept_off DeptHead E-101 HR Monday 105 E-102 Development Tuesday 101 E-103 Hous Keeping Saturday 103 E-104 Sales Sunday 104 E-105 Purchage Tuesday 104 Table :- EmpSalary EmpId Salary IsPermanent 101 2000 Yes 102 10000 Yes 103 5000 No 104 1900 Yes 105 2300 Yes Table :- Project ProjectId Duration p-1 23 p-2 15 p-3 45 p-4 2 p-5 30 Table :- Country cid cname c-1 India c-2 USA c-3 China…
Q1 : Table Name:- Employee Empid EmpName Department ContactNo EmailId EmpHeadId Salary 101 Ayesha E-101 1234567890 isha@gmail.com 105 4000 102 Priya E-104 1234567890 priya@yahoo.com 103 6000 103 Neha E-101 1234567890 neha@gmail.com 101 7000 104 Rahul E-102 1234567890 rahul@yahoo.com 105 4000 105 Abhishek E-101 1234567890 abhishek@gmail.com 102 5000 Select the details of the employee who work either for department E-104 or E-102.
Q1 : Table Name:- Employee Empid EmpName Department ContactNo EmailId EmpHeadId Salary 101 Ayesha E-101 1234567890 isha@gmail.com 105 4000 102 Priya E-104 1234567890 priya@yahoo.com 103 6000 103 Neha E-101 1234567890 neha@gmail.com 101 7000 104 Rahul E-102 1234567890 rahul@yahoo.com 105 4000 105 Abhishek E-101 1234567890 abhishek@gmail.com 102 5000 1. Select the detail of the employee whose name start with A. 2. Select the details of the employee who work either for department E-104 or E-102. 3. What is the department name for DeptID E-102? 4. What is total salary that is paid to all employees? 5. Select the detail of employee name and department who is getting salary above 5000.
Q1 : Table Name:- Employee Empid EmpName Department ContactNo EmailId EmpHeadId Salary 101 Ayesha E-101 1234567890 isha@gmail.com 105 4000 102 Priya E-104 1234567890 priya@yahoo.com 103 6000 103 Neha E-101 1234567890 neha@gmail.com 101 7000 104 Rahul E-102 1234567890 rahul@yahoo.com 105 4000 105 Abhishek E-101 1234567890 abhishek@gmail.com 102 5000 1. Select the detail of the employee whose name start with A. 2. Select the details of the employee who work either for department E-104 or E-102. 3. What is the department name for DeptID E-102? 4. What is total salary that is paid to all employees? 5. Select the detail of employee name and department who is getting salary above 5000. Table :- EmpProject EmpId ProjectId ClientID Project name StartYear EndYear 101 p-1 Cl-1 pharmacy 2010 2010 102 p-2 Cl-2 textile 2010 2012 103 p-1 Cl-3 travels 2013 104 p-4 Cl-1 xerox 2014 2015 105 p-4 Cl-5 cosmetics 2015 6. List the number of department of employees in each project. 7. How many project…
Q1 : Table Name:- Employee Empid EmpName Department ContactNo EmailId EmpHeadId Salary 101 Ayesha E-101 1234567890 isha@gmail.com 105 4000 102 Priya E-104 1234567890 priya@yahoo.com 103 6000 103 Neha E-101 1234567890 neha@gmail.com 101 7000 104 Rahul E-102 1234567890 rahul@yahoo.com 105 4000 105 Abhishek E-101 1234567890 abhishek@gmail.com 102 5000 1. Select the detail of the employee whose name start with A.
Year Gender Name_of_person Date_of birth Membership _type Contact_phone_no joined Contact_email 2018 Nor Kwa 03 2453 5673 2/4/2005 n.kwa@rockict.com Social Adam Mazian 082 25 4689 2016 23/5/2003 Social AdamM@abc.co.my Ahmed Othman 12/03/2006 01223 432678 2018 Junior AOthman@cie.org Zara Png 1/12/1997 123 3267 9999 2010 F Senior Zara@cbc.cn
The Marketing team of InstantStay wants to create mailing lists for the users. However, they need a single string which consists of all emails of the users combined (delimited) with a ",". You need to create a procedure called EmailList which uses a CURSOR that iteratively collects the email addresses in the USERS table and appends them to the string value. In addition, run the procedure and return back them the email list. 9 SQL Viewer Task Create a procedure to collect emails formatted as a mailing list. 0.00 out of 10.00 >
SLSREP_FNAME SLSREP_INITIAL SLSREP_EMAIL CUSTOMER PK CUST NUM CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST_E-MAIL CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE PK,FK1 PK FK2 HE SALESREP INVOICE PK SLSREP NUM PK INV_NUM SLSREP_LNAME-It writes OFK1 CUST_NUM FK2 SLSREP_NUM INV_DATE INV_SUBTOTAL I generates INV_TAX INV_TOTAL contains INV_LINE INV_NUM INV_LINE_NUM PROD_CODE INV_LINE_PRICE INV_LINE_QUANT INV_LINE_TOTAL VENDOR PK VEND_CODE VEND_NAME VEND_CONTACT VEND_EMAIL I supplies PRODUCT PK PROD_CODE is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.
Required information id fname lname company address city ST zip 103 Art Venere 8 W Cerritos Ave #54 Bridgeport NJ 8014 104 Lenna Paprocki Feltz Printing 639 Main St Anchorage AK 99501

SEE MORE QUESTIONS

Recommended textbooks for you

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:

9780357392676

Author:

FREUND, Steven

Publisher:

CENGAGE L

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:

9780357392676

Author:

FREUND, Steven

Publisher:

CENGAGE L

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

*User_id*	Last_name	First_name	Phone.no	Email	Book_id
U513	Mahara	Kapil	647-555-1151	phantomconflicted@gmail.com	003
U514	Bhatta	Bikas	434-568-1051	bikas434@Yahoo.com	001
U515	Ford	Richard	134-091-5122	Ford22@gmail.com	002
U516	Bhattarai	Bikram	647-887-2078	Everest.sbm@yahoo.com	005
U517	Bhoj	Biraj	603-788-1072	regmi@gmail.com	004