Can someone show me how to do this? Create a new user database with the name Han
ID: 3661428 • Letter: C
Question
Can someone show me how to do this?
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.
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)
/