You are required to perform the following steps: 1. Install SQL Server 2012/2014

Question

You are required to perform the following steps: 1. Install SQL Server 2012/2014, using unattended method to standardize installs. 2. Configure the TCP to run on port TCP 4459 3. Create a database named CSUGlobalEdu with following settings: a Data file initial size: 100MB b. Log file initial size: 50MB c Set to Autogrow d. No limit on maximum file size. 4. Create following tablesusing scripts: a Class Constraint Name Data Type Int Primary Key Course Number N varchar (30) Not null Course Name Time of the Day Tim e Not null Room Char (10) Not null Int Not null Room Capacity Nvar char (3000) Not null Course Description Int Not Null Credit Hours b. Instructor Name Constraint Data Type Nvar char (100) Not Null Address Instructor ID Int Primary Key

Explanation / Answer

1)Using unattended installation method, we can reduce the user interfearence to install or upgrade the software.

For installing SQL Server 2012 in unattended method we need to use the configuration file. to know where the configuration file is use the following steps:-

   1) Run SQL server 2012 setup
   2) Set all configutaion settings
   3) After reaching Ready to Install Page you can see the link for conuration file.
   4) Copy that link to modify the configuration file.

For Unattended use we mainly modify the below Parameters in the configutaion file:-
QUIET :-Keep it as True to not to display the user interface.
QUITSIMPLE:-Keep it as True to display only the progress of installation with out user interfearence.

In this way Installed SQL Server 2012.

2)For configuring the TCP to turn on port TCP 4459 use the following steps:-

   1)Open SQL Server Configuration Manger
   2)got to SQL Server Network configuration
   3)select Protocols for SQLEXPRESS
   4)Here to specify the TCP port right click on TCP/IP and got to properties
   5)Specify the port Number 4459 in TCP Port.
   6)click ok then to finish click Restart SQL Server.
  
3)Use the below Query to create the database with the given requirements :-

       USE master;
       GO
       CREATE DATABASE CSU GlobalEdu
       ON
       ( NAME = GlobalEdu_dat,
           FILENAME = 'C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAGlobalEdudat.mdf',
           SIZE = 100MB,
           FILEGROWTH = 5MB)
       LOG ON
       ( NAME = Sales_log,
           FILENAME = 'C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAGlobalEdulog.ldf',
           SIZE = 50MB,
           FILEGROWTH = 5MB ) ;
       GO
      
4)The below scripts are used to create the required tables as follows:-

a)

       CREATE TABLE [GlobalEdu].[Class]
       (
           [Course Number] [int] PRIMARY KEY,
           [Course Name] [nvarchar](30) NOT NULL,
           [Time of the Day] [Time] NOT NULL,
           [Room] [char](10) NOT NULL,
           [Room Capacity] [int] NOT NULL,
           [Course Description] [nvarchar](3000) NOT NULL,
           [Credit Hours] [int] NOT NULL,
          
       )

b)

       CREATE TABLE [GlobalEdu].[Instructor]
       (
           [Address] [nvarchar](100) NOT NULL,
           [InstructorID] [int] PRIMARY KEY,
           [Phone Number] [int] NOT NULL,
           [Office] [int] NOT NULL,
           [Office Hours] [nvarchar](30) NOT NULL,
           [Department] [nvarchar](15) NOT NULL,
           [Department ID] [int] NOT NULL,
           [First Name] [nvarchar](30) NOT NULL,
           [Last Name] [nvarchar](30) NOT NULL,
       )

c)

       CREATE TABLE [GlobalEdu].[Student]
       (
           [Address] [nvarchar](100) NOT NULL,
           [StudentID] [int] PRIMARY KEY,
           [Phone Number] [int] NOT NULL,
           [Major] [char](15) NOT NULL,
           [GPA] [decimal](2,2) NOT NULL,
           [First Name] [nvarchar](30) NOT NULL,
           [Last Name] [nvarchar](30) NOT NULL,
       )
6)Below queries are matches with the required critiria as follows:-

   a)Select * from [GlobalEdu].[Class] Order by [Course Number],[Course Name]
   b)Select * from [GlobalEdu].[Instructor] Order by [Last Name],[First Name]
   c)Select * from [GlobalEdu].[Instructor] Order by [Last Name],[First Name],[InstructorID]
   d)Select * from [GlobalEdu].[Student] Order by [Last Name],[First Name]
   e)Select * from [GlobalEdu].[Student] Order by [Last Name],[First Name],[GPA],[Major]

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.