Write a SQL statement that display the emp id , dep id, dep nameOutput show ΕMPLOYEESDEPARTMENTSEMPLOYEE ID LAST NAME DEPARTMENT ID100 King101 KochharDEPARTMENT ID DEPARTMENT NAME LOCATION ID10 Administration20 Marketing50 Shipping9017009018001500202 Fay206 Higgins206 Gietz2060 IT140080 Sales90 Executive110 Accounting190 Contracting1102500110170017001700EMPLOYEE ID DEPARTMENT ID DEPARTMENT NAME20010 Administration20 Marketing20 Marketing201202...90 Executive110 Accounting110 Accounting102205206

EMPLOYEES DEPARTMENTS DEPARTNENT ID DEPARTMENT NAME LOCATION ID 10 Administration 20 Marketing 90 Sheping 60 T 80 Sales 90 Erecutive 110 Accounting 190 Contracting EMPLOYEE ID LAST NAME DEPARTMENT ID 100 ing 101 Kochhar 90 1700 90 1800 1500 202 Fay 205 Higgins 206 Getz 20 1400 110 2500 110 1700 1700 1700 EMPLOYEE ID DEPARTMENT ID DEPARTMENT NAME 200 10 Administration 201 20 Marketing 202 20 Marketing ... 90 Executive 110 Accourting 110 Accourting 102 205 206

EMPLOYEES DEPARTMENTS DEPARTNENT ID DEPARTMENT NAME LOCATION ID 10 Administration 20 Marketing 90 Sheping 60 T 80 Sales 90 Erecutive 110 Accounting 190 Contracting EMPLOYEE ID LAST NAME DEPARTMENT ID 100 ing 101 Kochhar 90 1700 90 1800 1500 202 Fay 205 Higgins 206 Getz 20 1400 110 2500 110 1700 1700 1700 EMPLOYEE ID DEPARTMENT ID DEPARTMENT NAME 200 10 Administration 201 20 Marketing 202 20 Marketing ... 90 Executive 110 Accourting 110 Accourting 102 205 206

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

1st Edition

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Chapter12: Working In The Enterprise: Systems, Certifications, And Careers

Section: Chapter Questions

Problem 4MC: A(n) _____ report consolidates data usually with totals, tables, or graphs. (558) a. detailed b....

See similar textbooks

Similar questions

Salesperson Region Account Order Amount Month Albertson, Kathy East 29386 $925.00 January Albertson, Kathy East 74830 $875.00 February Albertson, Kathy East 90099 $500.00 February Albertson, Kathy East 74830 $350.00 March Brennan, Michael West 82853 $400.00 January Brennan, Michael West 72949 $850.00 January Brennan, Michael West 90044 $1,500.00 January Brennan, Michael West 82853 $550.00 February Brennan, Michael West 72949 $400.00 March Davis, William South 55223 $235.00 February Davis, William South 10354 $850.00 January Davis, William South 50192 $600.00 March Davis, William South 27589 $250.00 January Dumlao, Richard West 67275 $400.00 January Dumlao, Richard West 41828 $965.00 February Dumlao, Richard West 87543 $125.00 March Flores, Tia South 97446 $1,500.00 March Flores, Tia South 41400 $305.00 January Flores, Tia South 30974 $1,350.00 January Flores, Tia South 41400 $435.00 February Flores, Tia South 30974 $550.00 February Flores,…
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…
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…
INSTRUCTIONS  Using spreadsheet software enter the following table below that shows thenumber of tourists visiting the following countries over a five-year period. UseTimes New Roman and Font size 12. Name the worksheet Table. COUNTRIEsS 2014 2015 2016 2017 2018‘000 ‘000 ‘000 ‘000 ‘000Grenada 350 465 375 250 485Antigua andBarbuda 153 160 155 149 256Barbados 573 625 725 680 740St. Kitts 347 515 538 178 384St. Lucia 600 436 368 535 858Trinidad andTobago 379 563 475 415 563Jamaica 416 200 500 300 475Bahamas 300 450 550 460 470Aruba 208 367 415 500 684Dominica 135 317 279 350 465  Insert a column to the right of the table with the heading “Total Visitors”. Inthat same column compute the total number of tourists that visited eachcountry over the years. Insert a row heading Maximum to show the maximum number of visitors foreach given year. Sort the data in ascending order based on the Countries.  Insert a row heading Minimum to show the minimum number of visitors foreach given year. …
A local veterinarian hospital keeps record about the different pets they see over time, as well as information about the owners and treatment provided.The following tables represent a sample of the information recorded about owners, pets, and treatments. Owners LastName FirstName Phone Downs Marsha 555-537-8765 James Richard 555-537-7654 Frier Liz 555-537-6543 Pets PetName Type Breed Weight King Dog Std. Poodle 25.5 Teddy Cat Cashmere 10.5 Fido Dog Std. Poodle 28.5 King Horse Border Collie 25.0 Treatments Name Anesthesia Required Vaccine No Dental Yes Surgery Yes A veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital. For each of the visit, it is essential to record the various information…
Each publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERD
university er digram for database. 15 entities. yes at least 10.
Show transcribed data MSU Corporation Database Department Mgr Start Date 2005-06-19 2013-01-01 1998-05-22 t No Name Headquarters Admin and Records 999555555 Production Mgr SSN 999666666 999444444 Employee EMP SSN FName Nme Address City State Zip DOB Salary Park Gender Dep |Super SSN t No ing Space 99Bock Dougl 1955 09-01 30000 542M St. Louis MO 63121 7 999444444 Dr 1969- 03-29 999222222Amin HyderSeaside Marina CA93941 Collinsville IL 66234 Waiman Lindber St. Louis MO 63121 3999555555 7 999444444 7 999666666 25000 422 M Apt. B #10 Oak St. 303 999333333 Joshi Dinesh 38000 332 M 09-15 1975 12-08 43000 32 999444444 Zhu 202 999555555 Joyner 1971 06-20 430003 CA 93941 Suzanne Burns Marina arm Chapter 8 Homework Answer the questions below. In doing this homework, you don’t have to use a DBMS. If you didn’t create MSU Corporation datanase to do Chapter 7 homework, you can use the table information in “MSU Corporation Database” document attached. If you want to create the database now, use…
EXPERIMENTAL PROCEDURE Patients visit the hospital and their visit history is maintained by the hospital staff. Different physicians may be available on different dates. They diagnose and treat the patients of all categories. Some of treatments are free while others are to be paid by the patients. Sample data of the case is shown in the following chart. Patient History Report PatientID Name Address Visit Date Physician Diagnosis Treatment P-100809 A City: X 12-02-2007 20-02-2007 29-02-2007 15-03-2007 Dr. Z Dr. F Dr. R Dr. L Chest Infection Cold Hepatitis-A Eyes Infection Free Free Paid Paid P-200145 N City: Y 10-01-2007 15-02-2007 25-03-2007 Dr. L Dr. K Dr. A Bone Fracture Cough Flu Paid Free Free Task 1 Draw a dependency diagram and transform the above data to first normal form by eliminating repeating groups such that each row in the relation is atomic. Be sure to create an appropriate name for the…
1. Display the name (first name and last name) for those employees who gets more salary than the employee whose ID is 163. 2. Display all the information of those employees who did not have any job in the past. 3. Display the details of departments managed by Susan. 4. Display the details of those departments which max salary is 7000 or above for those employees who already done one or more jobs. 5. Display the detail information of those departments which starting salary is at least 8000.
# Begin constantsCOLUMN_ID = 0COLUMN_NAME = 1COLUMN_HIGHWAY = 2COLUMN_LAT = 3COLUMN_LON = 4COLUMN_YEAR_BUILT = 5COLUMN_LAST_MAJOR_REHAB = 6COLUMN_LAST_MINOR_REHAB = 7COLUMN_NUM_SPANS = 8COLUMN_SPAN_DETAILS = 9COLUMN_DECK_LENGTH = 10COLUMN_LAST_INSPECTED = 11COLUMN_BCI = 12 INDEX_BCI_YEARS = 0INDEX_BCI_SCORES = 1MISSING_BCI = -1.0 EARTH_RADIUS = 6371 # Sample data for docstring examplesdef create_example_bridge_1() -> list:"""Return a bridge in our list-format to use for doctest examples. This bridge is the same as the bridge from row 3 of the dataset.""" return [1, 'Highway 24 Underpass at Highway 403','403', 43.167233, -80.275567, '1965', '2014', '2009', 4,[12.0, 19.0, 21.0, 12.0], 65.0, '04/13/2012',[['2013', '2012', '2011', '2010', '2009', '2008', '2007','2006', '2005', '2004', '2003', '2002', '2001', '2000'],[MISSING_BCI, 72.3, MISSING_BCI, 69.5, MISSING_BCI, 70.0, MISSING_BCI,70.3, MISSING_BCI, 70.5, MISSING_BCI, 70.7, 72.9, MISSING_BCI]]] def create_example_bridge_2() ->…
The following table shows a list of pets and their owners that is used by a veterinarian service. P_Name Type Breed DOB Owner O_Phone O_E-mail Kino Dog Std. Poodle 3/27/97 M. Downs 5551236 md@abc.com Teddy Cat Chartraux 4/2/98 M. Downs 1232343 md@abc.com Filo Dog Std. Poodle 2/24/02 R. James 2343454 rj@abc.com AJ Dog Collie Mix 11/12/95 Liz Frier 3456567 liz@abc.com Cedro Cat Unknown 12/10/96 R.James 7865432 rj@abc.com Woolley Cat Unknown 10/2/00 M. Trent 9870678 mt@abc.com Buster Dog Collie 4/4/01 Ronny 4565433 ron@abc.com a. Describe 4 problems that are likely to occur when using this table. b. Break the table into two tables in a way that fixes the four problems.