QuestionQuestion

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.


Attached 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.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Execute a query
Create a query to display the contents of the one or more tables of the Books database using Management Studio. Post a screen shot and of your SQL and result set of your query.
Initial Posting Requirements
Post a screen shot and of the query designer window before executing the query.
...
$20.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Management Information Systems (MIS) Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats