The take-home is similar to the group final project but you are implementing 5 classes on your own. Here are the instructions.

Implementing Your Classes

Two Resources:

1. Start with this brief introduction to MS SQL Server Beginners Video:

https://www.youtube.com/watch?v=moCgS2kfxnU&list=PLnoixdURhvXCHXc3XnSpSBK4cvCeci4Vq&index=1

2. Then watch this one from Microsoft Virtual Academy Experts: From Zero to Hero: https://www.youtube.com/watch?v=UMSay1XvjgI

Use this knowledge to implement at least 5 of your final exam classes. Make sure you at least use the following SQL statement:

1. Create
2. Read (Select)
3. Update
4. Delete
5. Insert
6. Join

Required:

0. On completion of each of the following 7 activities, make sure you take a screen shot of your output and paste into a Microsoft Power Point file. You will upload this file to the take home final exam folder.

1. Create five classes (tables) using MS SQL Server or an Equivalent Server (SQLPro Studio for Mac Users).

2. Associate the classes using Foreign Keys as shown in the video.

3. Use an INSERT INTO XXX VALUES ( ) to add at least 5 objects into each class using the examples shown in the video. If you are not familiar with the insert SQL method, you can add the objects using the SQL Management Studio client.

4. Implement a Select method to read specific object attributes from the database.

5. Implement a Select/Join method to read specific object attributes from the database.

6. Implement an Update method to change a specific attribute in one of the Classes (Tables)

7. Delete a specific object from one of the database tables.

8. Label your Power Point slide headers appropriately for each activity

• Create a scenario of a business that would benefit from using the enterprise method of evaluation. Provide a rationale with your response.
• A company is trying to raise more funding and is considering two options of convertibility – convertible preferred and straight convertible debt. Evaluate the merits of both options to determine which is more attractive for your business venture from Assignment 1. Provide a rationale with your response.

You have been asked to evaluate and explain perimeter security. Prepare a presentation that includes an explanation of perimeter security utilizing 5 of the 10 topics listed below.

Individual Portion

Choose five of the following topics related to perimeter security and prepare a 5 – 7 slide presentation on that topic. The slide presentation should contain speaker notes of at least 3 paragraphs for each slide to explain the subject further. Also, include a cover slide and a reference slide.

Choose five of the following topics for the individual portion of the project:

• State-based filters
• Border routers
• Screened subnets
• Demilitarized zones (DMS)
• Intrusion prevention system (IPS)
• Intrusion detection system (IDS)
• Proxy firewalls
• Access control list filters
• Fail safe equipment
• Equipment redundancy

The individual presentation should include the following:

• An explanation of how the security method works
• Advantages and disadvantages of the chosen security
• Trade-offs for using the specific security
• Issues that are addressed by the security method chosen

The tutorial at https://www.lynda.com/Windows-Server-tutorials/Perimeter-networks/410326/445206-4.html provides a more detailed look at perimeter network and security concepts.

This criterion is linked to a Learning Required criteria 1. Introduction establishes the purpose of the paper and describes why topic is important to health promotion in the target population in your area. 2. Introduction stimulates the reader’s interest. 3. Conclusion includes the main ideas from the body of the paper. 4. Conclusion includes the major support points from the body of the paper.

This criterion is linked to a Learning Required criteria 1. Describes the topic and target cultural population. 2. Includes statistics to support significance of the topic. 3. Explains how the project relates to the selected Healthy People 2020 topic area. 4. Applies health promotion concepts.

Summary of Articles Required criteria 1. A minimum of three (3) scholarly articles, from the last 5 years, are used as sources. 2. Articles meet criteria of being from scholarly journals and include health promotion and wellness content. 3. At least one article is related to the chosen cultural group. 4. Summaries all key points and findings from the articles. 5. Includes statistics to support significance of the topic. 6. Discusses how information from the articles is used in the Health Promotion Project, including specific example.

Health Promotion Discussion Required criteria 1. Describes approaches to educate the target population about the topic. 2. The approaches are appropriate for the cultural target population. 3. Identifies specific ways to promote lifestyle changes within the target population. 4. Applies health promotion strategies.

This criterion is linked to a Learning OutcomeAPA Style and OrganizationRequired criteria 1. TurnItIn is used prior to submitting paper for grading. 2. Revisions are made based on TurnItIn originality report. 3. References are submitted with assignment. 4. Uses appropriate APA format (6th ed.) and is free of errors. 5. Grammar and mechanics are free of errors. 6. Paper is 3-4 pages, excluding title and reference pages. 7. Information is organized around required components and flows in a logical sequence.