My SQL Labs

Databases & SQL — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original 1 .Create a database with at least 10 tables.The 2ndFill the tables with data, at least 5 records in the "reference" tables, at least 10 records in the data tables.3 .Create at least 3 View with terms inside (for example, create_date is not null, department_id = 4 and so on).and 4.Create 1 trigger of each type (before insert, after insert, before update, after update, before delete, after delete) in the free tables for your choice.Check the work of the trigger.To verify that the triggers worked, place a code in the trigger body that will clearly show that the trigger had been triggered at least once.For example, you can create a "Journal" of action in a database in which you will write which trigger was called.and 5.Write at least 3 SELECT using Join for each type (one SELECT for each type): left join, inner join, right join.6 .Write SELECT by one using group functions: avg, count, min, max, sum.You can activate several group functions in one SELECT, in this case grouping must be complex (2 or more columns in the GROUP BY section).Important: each of the SELECTs will briefly describe what you wanted to choose with this SELECT.7 .Create 1 procedure and 1 function with a free function.The use of the variables created in the DECLARE section is mandatory.8thAdd at least 5 FOREIGN KEY to the free tables if they were not added when the tables were created.The 9.Create at least 2 indices on free columns.Use EXPLAIN to check what it has given (measure before and after the index).Important is: The database must be exported to a .sql file. The task is to write... SELECT..." after successfully performing SELECT, save it into a separate file; - use of aliaxes for the names of columns, tables, view is not mandatory but desired; - the verification material includes a .sql file with an exported database and a SELECT file;

Proposals 5 Rejected 1