BOBBY RAWAT 088pdf (1)

pdf

School

Algonquin College *

*We aren’t endorsed by this school

Course

8207

Subject

Information Systems

Date

Apr 3, 2024

Type

pdf

Pages

Uploaded by ColonelEnergy13829

1. First you will use sQl server ManageMent studio to create a new database that is o wned by your own personal account by perForMing the Following tasks: 1.1. you need to enable reMote connections using sQl server usernaMe/password auth entication .

1.2. now, create a new login naMed “yourlastnaMelogin” (e.g., kinglogin). (under secur ity > logins in object explorer). 1.3. create a new database called “lab4”, with the owner speciFied as yourlastnaMelogin (your new login). 1.4. create a new scheMa in the lab4 database, naMed “lab4eMployeedata” and set it as owned by the built ‐ in “dbo” database user.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Create the following tables in lab4, as copies of the tables in lab3 by doing these steps: 1.6.1.Do E mployees first: (Use: “SELECT * INTO lab4.lab4EmployeeData.Employees FROM lab3.dbo.Employees”) 1.6.3.Connect to SQL Server from SSMS using your new login and then run select statements to verify that the data has been copied correctly. . 1.6

2. Now that you have the data copied over to the new database, we will create the relationships using the Diagram editor: 2.1. First, give yourself permission to do this: under Security > Logins, open your Windows login profile (NOT the one that would have r emote access). You should see something like this (with less privileges selected) Add all the privileges that you might ever need (e.g., all of them). You need at least s erveradmin privileges. 2.3. Now create a new database diagram by rightmouse clicking on “Database Diagrams” under lab4 in the Object Browser . 2.2 .

3. First, we will create an ODBC data source for your new database. 3.1. Open the ODBC Data Source Administrator tool in Windows: 3.4. Continue with the configuration, and make sure that you test your connection at the e nd.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4. Now we will open Microsoft Access, use the builtin dialogs to launch the ODBC manager (32 bit or 64 bit depending on which version of Access is installed) and connect to the new database using our new ODBC DSN, as if it were a remote database!

4.7. In the pop‐ up, give your new data source a name and enter the SQL server that you would like to connect to 4.8. And provide your login/password on the next screen:

4.7. In the pop ‐ up, give your new data source a name and enter the SQL server that you would like to connect to 4.8. And provide your login/password on the next screen:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4.10. NOTE: In the resulting popup, the connection parameters are listed. It is important that you test your new database connectio n, so click on “Test Data Source”. 4.9.

5. Now that you have the DSN for our new database ready, we can use it to link to the shared tables directly from Access.

5 . Rerun the SSMS query to show all hobbies as now in lab4.lab4EmployeeData.Hobbies (!): Create a new report using the Access report wizard to show the list of hobbies for ea ch employee, grouped by employee. The report should use the data from the newly linked tables that are actually stored in SQL Server. 6 .

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

BOBBY RAWAT 088pdf (1)

Related Documents