Write the command that will list all data logged in the journal between the following dates and times: beginning: March 1, 2018, 8pm ending: March 31, 2020 11am

Create a Relational Algebra command to:Displays books published in the last 5 years from 2020.

Write and execute the command to retrieve the customer ID, first name, and last name of each customer in the MAJOR_CUSTOMER VIEW with a balance that exceeds the credit limit.

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 175645

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). 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…

Create a VIEW named MAJOR_CUSTOMER. It consists of the customer ID, first name, last name, balance, credit limit, and rep ID for every customer whose credit limit is $500 or less.

Forms offer a front-end to database users to enter data into a table, or multiple tables, and may contain buttons to switch between records, add new records, or search for records.  True  False   Which of the following answers most closely represents a constraint on a table?   A. A list of values that are preferred but not required for a row   B. A rule for a particular row that limits the values that can exist within it   C. A rule for a particular column that limits the values that can exist within it   D. A list of values that are preferred but not required for a column

USER_ID USER_FIRST_NAME USER_LAST_NAME USER_EMAIL 3001 Jack Hill j.hill@xmail.com 3002 Ryan Collins r.collins@xmail.com 3003 Nursin Yilmaz n.atak@gmail.com 3004 Sarah Price s.price@xmail.com 3005 Bobby Griffin b.griffin@xmail.com 3006 Randy Clark r.clark@xmail.com 3007 Jose Thomas j.thomas@xmail.com 3008 Nursin Yilmaz n.yilmaz@xmail.com

Task 3: The Marketing team wants to collect emails of the users on InstantStay. However, the team needs a SQL statement to execute inside their programming environment. You need to create a statement that they can easily run the EXECUTE command to return a single column table containing the USER_EMAIL addresses. Task: Create a prepared statement for use with the EXECUTE command.

2.Compute the item endorsement index for BRS Item 3. __________ ID # Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 BRS Total Score 25 5 5 5 5 5 5 55 24 5 5 2 4 5 5 50 21 5 4 5 3 5 5 48 22 5 5 4 3 3 4 46 23 5 3 3 5 5 2 46 18 4 5 5 4 4 4 44 20 5 5 4 3 3 4 44 16 5 4 5 5 4 3 42 19 4 5 4 1 4 4 41 9 5 5 4 5 5 5 38 10 5 5 4 4 4 4 36 13 2 4 3 5 4 5 36 7 3 5 5 5 5 5 35 11 5 3 3 5 3 4 34 15 4 3 3 1 3 5 34 4 5 5 4 5 5 5 33 17 1 2 2 4 5 2 33 2 5 5 5 5 5 5 32 5 4 5 4 4 5 5 32 12 4 4 1 4 4 2 31 8 3 4 3 3 3 3 27 6 4 3 3 2 4 4 26 14 2 1 2 2 2 3 26 3 5 4 4 4 2 3 25 1 1 3 2 3 3 3 16