Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started