Mаtch the descriptiоns tо the terms listed belоw (not аll options will be used) for the following six questions: Abelаrd Archivolts Flying buttress Jongleurs Laüstic Royal portal Suger Summa theologiae Troubadour
Mаstery Assessment These аre the prоblems tо cоpy. Reаd the requirements above. When complete upload your solution using the link below. You have one hour to complete this mastery. Queries: Create a new database to store all your tables and name your database Module5HL_LastName (ex. Module5HL_Doe). Be sure to select it after you create it. The following tables will be created in this database. Make sure to select your database before creating any tables. Create the Guitar_Companies table with these fields: CompanyID-INT PRIMARY KEY AUTO_INCREMENT, CompanyName-VARCHAR(50) NOT NULL. Create the Guitars table with these fields: guitarID-INT PRIMARY KEY AUTO_INCREMENT, guitarName-VARCHAR(50) NOT NULL, yearBuilt-INT, buildingCompanyID-INT NOT NULL. Don't forget the table level constraint: Foreign Key that references CompanyID from your Guitar_Companies table. Insert data into the Guitar_Companies table. Using only the CompanyName field, write the statement to insert the companies in the order provided. Wrap string in single quotes. The Guitar_Companies table will contain only these three (3) records: id set by system company name 1 Fender 2 Gibson 3 PRS Insert data into the Guitars table. Without using a column list, write the statement to insert the guitar name, the year it was built, and which company it built it. Wrap strings in single quotes, auto incrementing values uses DEFAULT, and the company is referenced by the integer ID. Data as follows: id set by system guitar name year Building company id 1 Stratocaster 1973 1 2 Telecaster 1985 1 3 Les Paul 1970 2 Write a SELECT statement that JOINS the two previously created tables together displaying these columns: guitarName, CompanyName, yearBuilt. Use aliases for the tables and must be displayed in the order provided. Mastery Assessment M5:Honorlock Mastery Rubric Mastery Assessment M5:Honorlock Mastery Rubric Criteria Ratings & Points 1. The SQL Script has the students name as a comment at top. The questions are copied over from the instructions in the proper manner, numbered, and commented. Full Marks: 10.0 ptsNo Marks: 0.0 pts 2. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 3. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 4. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 5. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 6. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts 7. The query finds the correct rows and columns of data from the database on the MySQL Server using the specified requirements of the statement. Full Marks: 15.0 ptsNo Marks: 0.0 pts Other Deductions -25 Deductions: 0.0 ptsNo Deductions: 0.0 pts -25 Deductions (0.0 pts): Deductions for items not included in rubric, but expected - naming the file correctly, copying and pasting the questions correctly, numbering the questions, commenting the questions properly, placing your answer after each question, using the USE command properly, and any other mistakes not covered by the rubric.