Insert the following data into your database tables. STUDENTS STUDENT_ID STUDENT_NAME STUDENT_SURNAME S123456 Neo Petlele S246810 Derek Moore S369121 Pedro Ntaba S654321 Thabo Joe S987654 Dominique Woolridge MODULES MODULE_ID MODULE_NAME MODULE_CREDIT DATA6212 Database Intermediate 30 INPU221 Desktop Publishing 20 PROG6211 Programming 2A 15 PROG6212 Programming 2B 15 WEDE220 Web Development (Intermediate) STUDENT_MODULES STUDENT_ID MODULE_ID S123456 PROG6211 S123456 PROG6212 S246810 DATA6212 S369121 DATA6212 S369121 INPU221 S369121 WEDE220 S987654 PROG6211 S987654 PROG6212 S987654 WEDE220 LECTURERS LECTURER_ID LECTURER_NAME LECTURER_SURNAME L578963 Kwezi Mbete L876592 Julia Robins L916482 Trevor January LECTURER_MODULES MODULE_ID LECTURER_ID DATA6212 L578963 INPU221 L876592 PROG6211 L916482 PROG6212 L916482 WEDE220 L876592 Correct INSERT statements used and all data correctly inserted per table.

Relational database select operations remove columns that fulfill requirements.Is this answer correct?

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

Access Assignment   Problem: 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…

SQL Data Manipulation Database tables are: Hospital hospitalNo name city 1493 Cambridge St Boston capacity Cambridge Mount Sinai 2 East 101st St H117 600 H120 New York 700 ******** ******* ******* Doctor doctorNo salary hospitalNo specialty Cardiologist Neurologist name Robert Donald Xin Wang D201 180000 H117 D205 225000 H120 Patient | age phoneNo 617-482-5801 212-353-1463 patientNo name doctor P366 Arthur Gluck 72 D201 P351 Lisa Hershman 46 D205 ****

Identify the foreign keys.

Identify the primary keys. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100 Broadway 12-Jan-65 101 Hollywoody 18-Nov-53 21-Jun-62 102 Goofy Table name: PLAY PLAY CODE PLAY NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight DIR NUM 102 101 102 100 101 1006 Starstruck in Biloxi 102 1007 Stranger In Parrot Ice 101 8588585

Question 2 and 3

USE MICROSOFT SQL SERVER

Explain the concept of database indexing and its impact on performance.