Subject Business Management Information Systems (MIS)

Question

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

This is only a preview of the solution. Please use the purchase button to see the entire solution

$20.00

or $1 if you
register a new account!

Assisting Tutor

Related Homework Solutions

Trip to Europe with Tour Group
Homework Solution
$20.00
Business
Financial Management
Travelling
Europe
Group Tour
Costs
Process Template
Airlines
Travel Agents
Affordable Packages
Discounts
Payments
Booking
Accommodation
Get help from a qualified tutor
Live Chats