Question 45 Below are two images showing two different data tables that you wish to link together in Tableau. What is the field that forms the basis of the relationship (linkage) between the two data tables in Tableau? Type your answer in the blank/box below, being careful not to make a spelling error when typing in the field name. Type in the field name EXACTLY as it is shown below. Fields Type Abc Abc FOFFF Fields Type Abc Field Name - Golf Club Used Type Yards Hole Result Ball Date Course Field Name Course (Courses.csv) City State Country Physical Table Sheet2 Sheet2 Sheet2 Sheet2 Sheet2 Sheet2 Sheet2 Sheet2 Remote Field... GolfClubUsed Type Yards Hole Result Ball Date Course Physical Table Courses.csv Courses.csv Courses.csv Courses.csv Remote Field Name Course (Courses.csv) City State P Country

Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations     Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL   MAINTENANCE_TYPE_ID char(5) NO PRI NULL   MAINTENANCE_DUE date NO PRI NULL

Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys.   Answer in MYSQL please

Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.● Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)● After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11● Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305.…