Order your essay today — written by real experts, guaranteed plagiarism-free, and ready to impress your professor!
1. Attach the Books database to your instance of the SQL server1. Attach the Books database to your instance of the SQL server Attachment
COLLAPSE
Other SQL Server Databases
The textbook discusses how to work with an existing SQL Server database on pages 58 − 59. The directions to attach to an existing database assume that you have successfully installed SQL Management Studio. Before attaching a database, review the AP database already attached to your SQL Server instance on your computer.
Locate the owner name of the AP database.
Right-click AP and select PropertiesFiles to view the owner.
Need Help Writing an Essay?
Tell us about your assignment and we will find the best writer for your paper.
Write My Essay For MeAttached to this web page is a SQL Server database named Books.mdf.
Download the Books database.
Copy the database to the SQL Server database to the database default location of on your computer.
Use Management Studio to attach to the Books database to the instance of the SQL server on your computer.
Modify the “attach as” name if necessary.
Modify the owner if necessary.
Initial Posting Requirements
1. Post a confirmation that shows you successfully attached the Books database.
2. Post a screenshot that shows the Books database in the Object Explorer Window of Microsoft SQL Server management Studio.
3. Post a screenshot that shows the table names of the Books database.
4. Post a screenshot of the database diagram
2. Execute a query2. Execute a query Attachment
COLLAPSE
Execute a query
Review how to execute a query on the AP database on page 81. Create a query to display the contents of the one or more tables of the Books database using Management Studio.
Initial Posting Requirements
Post a screen shot and of your SQL and result set of your query.
See the sample screen shot below.
3. An introduction to the Query Designer3. An introduction to the Query Designer
COLLAPSE
An introduction to the Query Designer
Review An Introduction to the Query Designer on pages 76 − 77. Create the query using the Query Designer as illustrated in figure 2-14 on page 77.
Initial Posting Requirements
Post a screen shot and of the query designer window before executing the query.
Post a screen shot of the result of the query.
