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

Assisting Tutor

Related Homework Solutions

Mitsberg's Five Structural Configurations (700 words)
Homework Solution
$15.00
Mitsberg
Structural
Configuration
Bureaucracy
Machine
Adhocracy
Divisionalised
Form
Strategic
Middle
Line
Support
Staff
Operating
Core
Management
Information
System
Impact of Some Specific IT Policies in the Industry
Homework Solution
$25.00
GPRA-1993
FASA-1994
GPEA-1998
PRA-1995
E GOV-2002
Circular
A-130
Policy
IT
Framework
Management
Information
System
Governance
Act
CIO
MIB
OMB
Federal
Security
Get help from a qualified tutor
Live Chats