SQL server Deployment, computer science homework help

SQL Server Deployment

Congratulations! Recently, you responded to a Request for Proposal (RFP), and you were awarded the contract to deploy, configure, and manage the SQL Server for the CSU Global Student Management System.

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:
    1. Data file initial size: 100MB
    2. Log file initial size: 50MB
    3. Set to Autogrow
    4. No limit on maximum file size.
  4. Create following tables using scripts:
    1. Class

Name

Data Type

Constraint

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

    1. Instructor

Name

Data Type

Constraint

Address

Nvarchar (100)

Not Null

InstructorID

Int

Primary Key

Phone Number

Nvarchar(10)

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

    1. Student

Name

Data Type

Constraint

Address

Nvarchar (100

Not Null

StudentID

Int

Primary Key

Phone Number

Nvarchar(10)

Not null

Major

Char (10)

Not null

GPA

Decimal (3,2)

Not null

First Name

Nvarchar (30)

Not null

Last Name

Nvarchar (30)

Not null

  1. Develop scripts to INSERT data into Class, Instructor, and Student tables. Load the tables with sample data with at least 10 rows.
  2. Construct and execute queries that match the following criteria:
    1. List all classes sorted by course number followed by course name.
    2. List all instructors by last name followed by first name.
    3. List all instructors by last name, first name, InstructorID.
    4. List all instructors by last name followed by first name.
    5. List all students by last name, first name, GPA, Major.
  3. Generate a certificate for the database.
  4. Develop a SQL query to generate a new symmetric key for encrypting data.
  5. Develop a SQL query to alter the Student table and a new column names StudentDataEncrypt with data type varbinary(128).
  6. Create a backup plan with following criteria:
    1. The backups should occur on Sundays starting at 9:00 AM.
    2. CSU Global Campus cannot afford to risk data loss of more than one hour.

Deliverable

You need to document the installation of SQL Server 2012/2014, and the creation of a database, tables, queries, and the backup plan by providing screenshots. All of the screenshots should be clearly labeled. Also, provide a summary of at least 2-3 pages that describes your experiences of SQL Server, not including the title and reference page(s).

"Order a similar paper and get 100% plagiarism free, professional written paper now!"

Order Now