4.Identify and describe the components of the table shown in Figure Q3.17, using correct terminology. Use your knowledge of naming conventions to identify the table’s probable foreign key(s). (Don't copy other answers.....those questions are different. ...read question please) FIGUREQ3.17The Ch03_NoComp database EMPLOYEE tableTable name: EMPLOYEEEMP_NUM EMP_LNAME EMP_INITIAL EMP_FNAMEKD11234 Friedman11238 Olanski11241 Fontein11242 CruazonaJ11245 Smithson811248 Washington G11256 McBride11257 Kachinn11258 Smith11260 RatulaDWARobertDelbertJulietteMariaBernardOletaRandallMelanieWilliamKatrinaDatabase name: Ch03_NoCompDEPT_CODE JOB_CODEMKTGMKTGINFSENGINFSENGRENGRMKTGMKTGINFS12125968814145

In a relational database, establishing a one-to-many (1:M) relationship between two tables is a…

The Ch03_NoComp database EMPLOYEE table Table name: EMPLOYEE EMP_NUM EMP_LNAME EMP_INITIAL EMP_FNAME DEPT_CODE 11234 Friedman 11238 Olanski 11241 Fontein 11242 Cruazona J 11245 Smithson B K D 11248 Washington 11256 McBride 11257 Kachinn 11258 Smith 11260 Ratula D W A Robert Delbert Juliette Maria Bernard Oleta Randall Melanie William Katrina MKTG MKTG INFS ENG INFS ENGR ENGR MKTG MKTG INFS Database name: Ch03_NoComp JOB_CODE 12 12 5 9 6 8 8 14 14 5

The Ch03_NoComp database EMPLOYEE table Table name: EMPLOYEE EMP_NUM EMP_LNAME EMP_INITIAL EMP_FNAME DEPT_CODE 11234 Friedman 11238 Olanski 11241 Fontein 11242 Cruazona J 11245 Smithson B K D 11248 Washington 11256 McBride 11257 Kachinn 11258 Smith 11260 Ratula D W A Robert Delbert Juliette Maria Bernard Oleta Randall Melanie William Katrina MKTG MKTG INFS ENG INFS ENGR ENGR MKTG MKTG INFS Database name: Ch03_NoComp JOB_CODE 12 12 5 9 6 8 8 14 14 5

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 69C: Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component....

See similar textbooks

Similar questions

The ABC Database Tables Table A TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK BUY DATE TRUCK SERIAL NUM 501 502 501 23-Sep-07 AA-322-12212-WM1 05-Feb-06 AC-342-22134-Q23 11-Nov-OS AC-445-78656-Z99 06-Jan-07 WVQ-112-23144-T34 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 17-Oct-04 AA-341-96573-284 07-Aug-05 DR-559-22169-D33 12-Feb-08 DE-887-98458-E94 1001 1032 1003 1004 1005 1006 1007 1009 1009 Table C Table B BASE CODE 501 502 Lexington 503 Cape Girardeau 504 Detton 503 501 502 502 T TYPE_CODE 503 BASE CITY Murfreesboro TYPE DESCRIPTION 1 Single box, double-sode 2 Single box, single-axde 3 Tandem trailer, single-exde 1 1 2 1 2 2 3 32 2 32123.5 76934.3 12346.6 2894.3 45673.1 193245.7 32012.3 44213.6 10932.9 BASE STATE BASE_AREA_CODE TN KY MO GA 615 568 456 901 BASE PHONE 123-4567 234-5678 345-6789 458-7890 BASE MANAGER Andree D. Gallager | George H. Delarosa Maria J. Talindo Peter F. McAvea
Insert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.
CSC1100 ProductID ProdName 614 Sprinkler G15 Humming bird feeder 620 Garden hose 625 Shovel JG29 Tab connector G43 Leaf roke G46 Pruning Shears 656 Bird House 35 G57 Planter box 130 Answer the following questions about the Products table in this image 1. What are the field names? Products InStock Database Review 78 40 60 30 65 89 8
GRADE REPORT STUDENT Name Student number Class Student number Section identifier Grade Major CS Smith 17 17 112 Brown 2 CS 17 119 85 92 COURSE 102 Course number Credit hours Department CS1310 Course name 135 Intro to Computer Science Data Structures Discrete Mathematice Database CS CS3320 4 CS MATH2410 MATH PREREQUISITE CS3380 CS Course number Prerequisite number CS3320 CS3380 CS3380 MATH2410 SECTION Section identifier Course number Semester Year Inatructor CS3320 CS1310 MATH2410 Fal King Anderson 85 07 02 CS1310 Fall 07 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fal 08 Anderson 135 CS3380 Fall 08 Stone 4. Show the result of the following queries as it would apply to the database state given above. 1. SELECT DISTINCT Name FROM STUDENT WHERE Major="cs; 2. SELECT GRADE REPORT.Student number, SUM(Credit_hours), COUNT(") FROM GRADE_REPORT, SECTION,COURSE WHERE GRADE REPORT.Section_identifier= SECTION.Section_identifier AND SECTION.Course_number=COURSE.Course_number…
Find the Primary Keys and P3,6 for the database: Make Model Engine ID Ford Mustang Ford Fiesta Chevy Camaro Chevy Caprice Olds Cutlass Olds Cutlass Volvo P1800 Volvo 240 Volvo 760 Year 1972 A1222 1989 C54322 1991 754342AH 1989 442355CC 1992 ANDU33 1992 ANGH28 1969 44325XX 1986 53526PD 1992 578868R Vehicle ID FO13579 FO24245 CH172389 CH156738 OL64332 OL61998 V044526 VO64690 V083529 Color Black Yellow Black Yellow Blue White White Black Blue
FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Table name: INVOICE CUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCE OIE Rumas CO1 Dure W NUNGER | CUS_CO DATE 100 19014 16--1 1001 16Jan-18 TOTAL TA otAL Ahet Lre Kay 544 04-126 000 1070 19012 16n-t 10011 17an-18 10018 153S 0013 Obenki KCO14 Odundo Myren COS O 56 76 00 0.00 221 19 16 4-210 222-1 403 2-12 1004 100s 280 7044 James Gege 1000 10014 17an-18 10017 wane 15 10015 1tlan18 200 00 Fart 210 000 Are Clate 1001 t 1008 431 de 615 207-00 Table name: LINE WNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTAL Table name: PRODUCT 1499 149 1001 1DERO Power pairte, 15 pa, Seorz 13-02 per bde 140 900 p e 00 1000 499 130eo-17 140 1000 1.223/OPD 13Nv-17 15a1a 12 1749 000 21344 1000 3 13022 749 14 90 19.00 70.44 207 108 92 1000 1490 19 om H 10n,0 z Y DO gnew. 12n 15-n-1 23 43 199 20e-17 24ec1 1004 1006 22OHE 1 PVCZDRT 1 SM 1077 2 22OTY 9.06 ar 12 22ORD BIO conder I0 20He O hanmer 21LAA…
Q2: A-Given the following tables: Student Subject Std_ID 001 002 003 004 Fname Smith Smith Beal Thomson Lname Jolin Susan Fred Marie Std_ID 001 001 002 002 003 Semester 004 Falls03 Spro4 Falls03 C_ID Eng01 Ger01 Eng01 Ger01 Ger01 CSection Spro4 Spro4 Spro4 1. For each table in the database, identify the primary key and the foreign key(s). 2. Do the tables exhibit entity integrity? Explain your answer? 3. Do the tables exhibit referential integrity? Explain your answer? Ita01 ZZZZZZ IN 2N IN 2N IN CName English IN German English German German Italian Grade A B A B A B
Database name: Ch03_StoreCo Table name: EMPLOYEE EMP CODE EMP TITLE EMP LNAME EMP FNAME EP NTIAL EMP DOe STORE CODE imson John 21-May-64 Ratula 09-Feb-60 Nancy Lotte 2 Ms 3 Ms. Oreenboro R 02-Oct-61 4 Jervie Robert 01Jun-71 23-Nov-59 4 Mrs Runperstro SM. Smth 25-Dec-65 Renselser Ogalo Johneson Cary A 31--62 7 M 8 Ms Roberto 10-Sep-60 19-Apr-55 06-Ma6 21-Oct-72 Ekzbeth Endemar Jack 2. 10 Ms. Rose 11 M Broderick Ton 08-Sep 74 25-Au4 25May6 24-May-64 03-Sep-60 12-Nov.70 24 Jan-71 12 M Washington Alan Y 13 M Snth Peter IN 14 Ms Smth Sherry 15 M Olenko Howard 16 M Archiso Barry 17 Ms Grimaido Jenine 4. 18 M. Roserberg Andrew D 03-Oct-60 06-Mar-70 19 M Rosten Peter F 20 M Mckee Robert 1 21 Ma Baunann Jenniter A 11-Dec-74 Table name: STORE STORE YTD SALES REGION_CODE P CODE STORE CODE STORE NAME 1 Access anction 1003455 76 14217 39 986783 22 944568 56 2 Database Coner 3 Tuple Charge 4 Atribute Aley 5 Prinary Key Point 1 29300 45 15 Table name: REGION REGION CODE REOION DESCRPT 1 East 2 west…
Write Mysql code The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.
Use Mysql code The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.
Answer the following questions by referring to the tables below. COURSE Course_name Course_number Credit_hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3 CS SECTION Section_ID Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name. Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson". Insert a tuple for a new COURSE with the following information: 4.The course name is Computer networks, and the course number is CS3480. It belongs to the CS…
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100