Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

STEP 1 Your company AdventureWorks, has decided to expand into interstellar travel. They have asked you to create a new database called Planets on the

image text in transcribed

STEP 1 Your company AdventureWorks, has decided to expand into interstellar travel. They have asked you to create a new database called Planets on the Microsoft SQL server using the SSMS graphical interface. What are the steps needed to create this database? List these steps. Then take action to create the database called Planets (you will need to use google to gather data for the planets). What other tables will you need besides the planet table? Create all tables that you will foresee using in your database and populate these with the information. STEP 2 As the Database Administrator you are to extract data from the database. A service manager needs your help extracting data from the Planets database. Therefore, after opening SSMS and accessing the Planets database, specify the basic SELECT statements you would use to retrieve the required information from the tables 2 1. What commands would return all the rows and columns in the Planets table? 2. What commands would you type and execute to return only the planet id, 3 4. In the existing query window, what commands would you use to add a column planet name, and planet date? What commands would you type and execute to return rows where the word moon" appears somewhere in the name? alias to the planet_name column to clarify it as the subcategory name

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 19th International Conference Dexa 2008 Turin Italy September 2008 Proceedings Lncs 5181

Authors: Sourav S. Bhowmick ,Josef Kung ,Roland Wagner

2008th Edition

3540856536, 978-3540856535

More Books

Students also viewed these Databases questions