Please use picture for reference to answer the question. The parenthesis in red..SQL related

Question: Create roles for the various types of users in the pizza database.

Please make copy paste available.

egy is to create an acces ne how to do the loginprole TOE QOll in proceauiesdent?" Sure. Let's open up the query wind Professor Collins opens the m d mode so ther to views. This layer controls all access ed mode se that it procsses nlos and SOL Server ou expose a built-in system ors account called "sa." ent studio and starts a ne anagem This will ied uresthcan right click on the properties of the server and then click on "Sectmixed you do enable to go. If not, you will need to change the mock ande iode montan the server, "The first thing we are going to do is create the student login. 2008, the can rig Windows Authenticatio in th SQL Server grre it a strong for the changes to take place. You can do that by right clicking on "So first we make sure we are in master. Logins are stored i the servet agin you give it a choosing 'Restart' from the menu." You can do this with the graphical interface, but I prefer to use jus naer ficient." USE master GO Sharon asks, "What is the 'GO?' I don't recognize it." "The GO' is unique to SQL Server. It means, basically, finish this letely before moving on to the next. Now we will create the student login" CREATE LOGIN StudentLogIn WITH PASSWORD- 'password1 DEFAULT DATABASE-TutorManagement GO "Now we will switch to the tutor database and create a student role. A roles cally a set of permissions on database objects. Right now the role has no pemisis USE TutorManagement Go CREATE ROLE StudentRole Go