Can someone show me how to do this with screenshots please? Use SQL Server Manag
ID: 3661375 • Letter: C
Question
Can someone show me how to do this with screenshots please?
Use SQL Server Management Studio to connect to a server instance. Create a new user database with the name HandsOnOne using the New Database dialog box from Object Explorer. Use the default database settings with the following exceptions:
Data file initial size: 40 MB
Log file initial size: 15 MB
Autogrowth enabled with 15 MB in file growth
Unlimited maximum file size
Use Object Explorer to generate a CREATE DATABASE script from the HandsOnOne database in a new Query Editor window. Change the name of the database in the SQL script to HandsOnTwo and modify the data file initial size to 35 MB. Execute the SQL script to create the database named HandsOnTwo.
Using either Object Explorer or Query Editor, set the recovery mode for the HandsOnOne database to full. Set the recovery mode for the HandsOnTwo database to simple. Document this step by taking a screenshot of the options page in the database properties window for each database.
Using Object Explorer—or by running a SQL command in the Query Editor window—rename the HandsOnTwo database to HandsOnTwo_Delete.
Execute a SQL command to DROP the HandsOnTwo_Delete database.
Using Object Explorer, create a new table named Customer with the following column names, associated data types, and constraints:
Column name
Data type
Constraint
CustomerID
int
Primary key
CustomerName
nvarchar(40)
Not null
CustomerAddressID
int
Not null
Take a screenshot of the Table Designer window to document this step.
Using Query Editor, construct and execute a SQL command to create a new table named Address with the following column names, associated data types, and constraints:
Column name
Data type
Constraint
AddressID
int
Primary key
Street
nvarchar(50)
Not null
City
nvarchar(40)
Not null
State
char(2)
Not null
ZipCode
nvarchar(10)
Not null
After executing the SQL command, document this step by taking a screenshot of the Query Editor window to show that the query completed successfully.
Using Object Explorer, create a foreign key relationship between the Customer and Address tables. The AddressID of the Address table is the primary key, and the CustomerAddressID of the Customer table is the foreign key. After creating the key, view the dependencies of the Address table in Object Explorer and take a screenshot to document this step.
Column name
Data type
Constraint
CustomerID
int
Primary key
CustomerName
nvarchar(40)
Not null
CustomerAddressID
int
Not null
Explanation / Answer
According to your requirements I need Oracle 11g licensed software and also you can use below SQL statements to create database tables.
CREATE TABLE Customer (
CustomerID INT PRIMARY KEY,
CustomerName NVARCHAR2(40) NOT NULL,
CustomerAddressID INT NOT NULL
)
/
CREATE TABLE Address (
AddressID INT PRIMARY KEY,
Street NVARCHAR2(50) NOT NULL,
City NVARCHAR2(40) NOT NULL,
State CHAR(2) NOT NULL,
ZipCode NVARCHAR2(10) NOT NULL
)
/
ALTER TABLE Customer
MODIFY CustomerAddressID INT REFERENCES Address (AddressID)
/