Empl Id | Name | Address | SSN | Job Id | Job Title | Skill Cod | Dept | Start Date | Term Date |
25X15 | Joe E. Baker | 33 Nowhere St | 111223333 | F5 | Floor manager | FM3 | Sales | 9-1-2009 | 9-30-2010 |
25X15 | Joe E. Baker | 33 Nowhere St | 111223333 | D7 | Dept. head | K2 | Sales | 10-1-2010 | * |
34Y70 | Cheryl H. Clark | 563 Downtown Ave. | 999009999 | F5 | Floor manager | FM3 | Sales | 10-1-2009 | * |
23Y34 | G. Jerry Smith | 1555 Circle Dr. | 111005555 | S25X | Secretary | T5 | Personnel | 3-1-1999 | 4-30-2010 |
23Y34 | G. Jerry Smith | 1555 Circle Dr. | 111005555 | S26Z | Secretary | T6 | Accounting | 5-1-2010 | * |
• | • | • | • | • | • | • | • | • | • |
• | • | • | • | • | • | • | • | • | • |
• | • | • | • | • | • | • | • | • | • |
Figure 9.4
21. Design a relational
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Additional Engineering Textbook Solutions
Starting Out with C++: Early Objects (9th Edition)
Starting Out with Python (4th Edition)
Differential Equations: Computing and Modeling (5th Edition), Edwards, Penney & Calvis
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
Modern Database Management (12th Edition)
- 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.arrow_forwardProblem 1. Using the INVOICE table structure shown in table below do the following: INVOICE Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2016 15-Jan-2016 15-Jan-2016 15-Jan-2016 16-Jan-2016 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD_PRICE $49.95 $3.45 $39.99 $49.95 $87.75 Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one…arrow_forwardProblem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70 $400.00 29 GR56 Grant Cleaners 737 Allard Kingston TX 78084 512-555-1231 $215.00 $225.00 22…arrow_forward
- A(n) __________ is a column that contains unique values that are generated by the DBMS. a. generated column b. pseudo-primary key c. identity column d. automatic entryarrow_forwardJohn's database tables SALES Customer ID (primary key) Date of purchase Item code(foreign key) 001 2/05/2021 A-1 002 3/05/2021 B-1 003 4/05/2021 C-1 004 5/05/2021 D-1 005 6/05/2021 E-1 ITEM LIST Item code(primary key and foreign key) Item name Quantity A-1 Bread 35 B-1 Milk 45 C-1 Egg 12 D-1 Tea 20 PRICE LIST Item code(primary and foreign key) Item cost Total price A-1 15 525 B-1 15 675 C-1 8 96 D-1 20 400 Design a logical view for the tablesarrow_forwardSQL BITS List client number, balance, consultant number, and consultant last name of every client whose balance is greater than that of client number '405.'arrow_forward
- Insert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total). School School Number Name Address PhoneNumber built size 54 John Adams High School 8226 Selby Lane 5056444088 2012-12-13 118500 45 Hogwarts School of Witchcraft and Wizardry 738 North Williams Ave. 5056448362 2001-11-14 414000 119 Dillon High School 475 South University Ave. 5058672818 2006-10-03 102598 345 Green Dale High 772 Grand St. 5056624410 2009-09-17 250345 93 Bayside High 7914 Aspen Drive 5057756575 2000-08-20 175645arrow_forwardInsert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total). Administrator employeeNumber SchoolNumber firstname lastName phoneNumber officeNumber 4 45 Albus Dumbledore 2072087222 201 60 45 Minerva McGonagall 2406994295 150 119 45 Percy Weasley 4324061884 302 138 345 Ken Jeong 5058091461 503 52 345 Jim Rash 4173119531 654 16 345 John Oliver 4255510706 321 25 93 Dennis Haskins 5056465505 987 146 93 Hayley Mills 5056443920 852 101 93 Joan Ryan 5056444527 963 172 119 Eric Taylor 4197627238 741 89 119 Tami Taylor 5056449431 159 76 119 Matt Saracen 5058813720 753 193 54 George Feeny 2136699130 456 77 54 Jonathan Turner 5056833823 789 24 54 Eli Williams…arrow_forward1- List all the users and their card name using union2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user hasnever used scheduled transaction show null or zero in the transaction column. (Hint use ISNULLfunction)arrow_forward
- ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'; /* JOB TABLE */ CREATE TABLE JOB ( JOB_CODE varchar2(3) PRIMARY KEY, JOB_DESCRIPTION varchar2(25), JOB_CHG_HOUR float(8), JOB_LAST_UPDATE date ); INSERT INTO JOB VALUES('500','Programmer', '35.75','11/20/2015'); INSERT INTO JOB VALUES('501','Systems Analyst', '96.75','11/20/2015'); INSERT INTO JOB VALUES('502','Database Designer', '125', '3/24/2016'); INSERT INTO JOB VALUES('503','Electrical Engineer', '84.5', '11/20/2015'); INSERT INTO JOB VALUES('504','Mechanical Engineer', '67.9', '11/20/2015'); INSERT INTO JOB VALUES('505','Civil Engineer', '55.78','11/20/2015'); INSERT INTO JOB VALUES('506','Clerical Support', '26.87','11/20/2016'); INSERT INTO JOB VALUES('507','DSS Analyst', '45.95','11/20/2015'); INSERT INTO JOB VALUES('508','Applications Designer','48.1', '3/24/2016'); INSERT INTO JOB VALUES('509','Bio Technician', '34.55','11/20/2015'); INSERT INTO JOB…arrow_forwardDBMS 130 Worksheet: JOINS and SET Operations1Topic 1: The 5 JoinsRun each of the following statements in APEX.What are the differences in the results of these SQL statements?Why are the results different?SELECT E.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES EINNER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECT E.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES ELEFT OUTER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECT E.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES ERIGHT OUTER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECT E.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES EFULL OUTER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECT E.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES ECROSS JOIN HOL_JOBS J; DBMS 130 Worksheet: JOINS and SET Operations2Topic 2: Write an SQL cartesian product between Regions and Countries.Copy your APEX here.How many rows are in the result set?How could you have calculated the number of rows in the result set BEFORE running your query?Topic 3: Briefly explain how set operators…arrow_forwardDbms sub. Qarrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning