Scenario

You work for a high-tech company with approximately 390 employees. Your firm recently won a large DoD contract, which will add 30% to the revenue of your organization. It is a high-priority, high-visibility project. You will be allowed to make your own budget, project timeline, and tollgate decisions.

You must develop the proper DoD security policies required to meet DoD standards for delivery of technology services to the U.S. Air Force Cyber Security Center (AFCSC), a DoD agency. To do this, you must develop DoD-approved policies and standards for your IT infrastructure (see the “Tasks” section below). The policies you create must pass DoD-based requirements. Currently, your organization does not have any DoD contracts and thus has no DoD-compliant security policies or controls in place.

The firm’s computing environment includes the following:

• 12 servers running Microsoft Server 2012 R2, providing the following:
  • Active Directory (AD)
  • Domain Name System (DNS)
  • Dynamic Host Configuration Protocol (DHCP)
  • Enterprise Resource Planning (ERP) application (Oracle)
  • A Research and Development (R&D) Engineering network segment for testing, separate from the production environment
  • Microsoft Exchange Server for e-mail
  • Symantec e-mail filter
  • Websense for Internet use
• Two Linux servers running Apache Server to host your Web site
• 390 PCs/laptops running Microsoft Windows 7 or Windows 8, Microsoft Office 2013, Microsoft Visio, Microsoft Project, and Adobe Reader
• Select a team leader for your project group.
• Create policies that are DoD compliant for the organization’s IT infrastructure.
• Note DOD-specific requirements for the organization’s IT infrastructure and U.S. compliance laws that may affect the firm
• Include DoD-compliant policies, standards, and controls that affect the User, Workstation, LAN, and LAN-to-WAN Domains
• Develop a list of compliance laws required for DoD contracts.
• List controls placed on domains in the IT infrastructure.
• List required standards for all devices, categorized by IT domain.
• Include DoD-compliant policies, standards, and controls that affect the WAN, Remote Access, and System/Application Domains
• Develop a deployment plan for implementation of these polices, standards, and controls.
• List all applicable DoD frameworks in the final delivery document.
• Write a professional report that includes all of the above content-related items.

Tasks

You must:

Requirements:

• Minimum of 1,250 words / Maximum 1,800 words (Double spaced)
• APA style
• At least 7 works cited
• At least 5 of your references have to be scholarly peer-reviewed articles
• Research paper will be checked for plagiarism so be sure to correctly cite your sources!
• 80/20 rule for all submissions

Scenario

You work for a high-tech company with approximately 390 employees. Your firm recently won a large DoD contract, which will add 30% to the revenue of your organization. It is a high-priority, high-visibility project. You will be allowed to make your own budget, project timeline, and tollgate decisions.

You must develop the proper DoD security policies required to meet DoD standards for delivery of technology services to the U.S. Air Force Cyber Security Center (AFCSC), a DoD agency. To do this, you must develop DoD-approved policies and standards for your IT infrastructure (see the “Tasks” section below). The policies you create must pass DoD-based requirements. Currently, your organization does not have any DoD contracts and thus has no DoD-compliant security policies or controls in place.

The firm’s computing environment includes the following:

▪ 12 servers running Microsoft Server 2012 R2, providing the following:

o Active Directory (AD)

o Domain Name System (DNS)

o Dynamic Host Configuration Protocol (DHCP)

o Enterprise Resource Planning (ERP) application (Oracle)

o A Research and Development (R&D) Engineering network segment for testing, separate from the production environment

o Microsoft Exchange Server for e-mail

o Symantec e-mail filter

o Websense for Internet use

▪ Two Linux servers running Apache Server to host your Web site

▪ 390 PCs/laptops running Microsoft Windows 7 or Windows 8, Microsoft Office 2013, Microsoft Visio, Microsoft Project, and Adobe Reader

Tasks

You must:

▪ Select a team leader for your project group.

▪ Create policies that are DoD compliant for the organization’s IT infrastructure.

▪ Note DOD-specific requirements for the organization’s IT infrastructure and U.S. compliance laws that may affect the firm

▪ Include DoD-compliant policies, standards, and controls that affect the User, Workstation, LAN, and LAN-to-WAN Domains

▪ Develop a list of compliance laws required for DoD contracts.

▪ List controls placed on domains in the IT infrastructure.

▪ List required standards for all devices, categorized by IT domain.

▪ Include DoD-compliant policies, standards, and controls that affect the WAN, Remote Access, and System/Application Domains

▪ Develop a deployment plan for implementation of these polices, standards, and controls.

▪ List all applicable DoD frameworks in the final delivery document.

▪ Write a professional report that includes all of the above content-related items.

Requirements:

• Minimum of 1,250 words / Maximum 1,800 words (Double spaced)

• APA style

• At least 7 works cited

• At least 5 of your references have to be scholarly peer-reviewed articles

• Research paper will be checked for plagiarism so be sure to correctly cite your sources!

• 80/20 rule for all submissions

Develop a Complete Disaster Recovery Plan to be submitted to the executive board of your company.

Only MS Word (.doc, .docx) and Adobe Acrobat (PDF) formats are acceptable. Please note that this is a formal writing, all references (peer-reviewed) mostly must be cited appropriately within the text and clearly avoid plagiarism. The paper should have a minimum of 10 pages, 1.5 spacing and Times New Roman font. A minimum of 5 peer review references must be provided. Reference style is APA. You can also have some web references alongside the stated requirement. Please see class syllabus for additional details

MY SQL

– Changing Data

— 1. Create a new table in Chinook called RockTrack that contains all of the tracks in the Rock genre (genreid=1) by executing the following statement:

Create table RockTrack as (Select * from track where genreid=1);

— After creating the table run the following statement to set the primary key and auto_increment the trackid. If you do not do this, you may have trouble with some of the later queries.

ALTER TABLE RockTrack CHANGE trackid trackid INT primary key NOT NULL AUTO_INCREMENT;

— 2. Update trackid 2 to set the price at 1.19.

— 3. Update all tracks with albumId = 90, to change the composer to Axl Rose

— 4. Change trackid 2213 to reflect the following values:
— mediatypeid = 3
— milliseconds = 234000
— bytes = 6500000
— unitprice = 1.29

— 5. Add a record to the RockTrack table with the following information

— Trackid: 3700
— Name: MySQL Melodies
— AlbumId: 249
— MediaTypeId: 1
— GenreId: 1
— Composer: your name
— Milliseconds: 123456
— Bytes: 3333333
— UnitPrice: .99

— 6. Add a record to the RockTrack table with the following information. Accept default values for all other fields

— Name: Database Blues
— MediaTypeId: 3
— Millisecond: 200000
— UnitPrice: 1.09

— 7. Use a single query to add the following 3 tracks to the RockTrack Table
— Name Albumid Mediatypeid Genreid Composer Milliseconds Bytes UnitPrice
— Brookhaven Boogie 117 1 1 Thom Chesney 234567 6543210 0.99
— Homework Hell 249 1 1 Patti Burks 210987 7654321 0.99
— Computer Chaos 17 1 1 null 334455 6789123 0.99

— 8. Delete Trackid 2700 from the RockTrack table

— 9. Delete all the tracks in the RockTrack table with albumId 249

— 10. Delete all the tracks in the RockTrack table that do not have a composer
— What happens when you run this query? Why?

— When you are done with this lab, you can get rid of the RockTrack table by running this query:

DROP table RockTrack;