Course Project Phase 1 (Course: Database Systems)

 

Query # 1Write a SQL statement to produce output as follows: Student’s First and Last Name.

Query # 2Write a SQL statement to produce output as follows: the Major of the STUDENT with no duplications. Do not display student names. 

Query # 3Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 32828. 

Query # 4Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 97912 and have the major of CS. 

Query # 5Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 32826 or 33186. Do not use IN.

 Query # 6Write a SQL statement to produce output as follows: the First and Last Name of students who have the major of Business or Math. Use IN. 

Query # 7Write a SQL statement to produce output as follows: the First and Last Name of students who have the Class greater than 1 and less than 5. Use BETWEEN. 

Query # 8Write a SQL statement to produce output as follows: First and Last Name of students who have the Last name that starts with an M. 

Query # 9Write a SQL statement to produce output as follows: First and Last name of students having an o in the second position in their First Name. 

Query # 10Write a SQL expression to produce output as follows: display the Status for, and the number of occurrences that apply to each status. You must 

Assignment

Exercise 1: Using the data classification scheme in this chapter, identify and classify the information in your personal computer or personal digital assistant. Based on the potential for misuse or embarrassment, what information would be confidential, sensitive but unclassified, or for public release?

Exercise 2: Using the Internet, determine what applications are commercially available to enable secure remote access to a PC.

Exercise 3: Using a Microsoft Windows system, open Internet Explorer. Click Internet Options on the Tools menu. Examine the contents of the Security and Privacy tabs. How can these tabs be configured to provide: (a) content filtering and (b) protection from unwanted items like cookies?

PowerPoint_1F_Refuge

PowerPoint_1F_Refuge

  

Project Description:

In the following project, you will edit a presentation regarding a wildlife refuge where Kodiak West Travel conducts tours.

     

Open the file Student_PowerPoint_1F_Refuge.pptx   downloaded with this project. 

 

Change the Slide Size to   Widescreen (16:9).

 

Display the presentation   Outline. In the Outline, on Slide 2, increase the list level of the third and   the fifth bullet points. Click at the end of the last bullet point after the   word roads, and then type or facilities

 

Return the presentation to   Normal view, and then display Slide 4. Display the Reuse Slides pane. Browse   to open from your downloaded files, p01F_Excursions.pptx. Make sure the   Keep source formatting check box is cleared. With Slide 4 in your   presentation displayed, insert the last two slides from the Reuse Slides   pane.
 

  Note—Mac users insert all slides and delete Slide 5—Wildlife and Excursions.

 

Display Slide 1, and then change   the layout to Title Slide.

 

On Slide 1, select the subtitle—Experience Alaska with Kodiak West Travel.   Change the Font to Arial, and the Font Size to 28. Change the Font Color to   black. Center the title and the subtitle.

 

Display Slide 5, and then select   the paragraph in the content placeholder. Apply Bold and Italic, and then   change the Font Size to 16.

 

In the same paragraph, center   the text, and then change the Line Spacing to 1.5. Center the slide title.

 

In Slide Sorter view, delete   Slide 3. Move Slide 5 to position it after Slide 2.

 

Move Slide 4 to the end of the   presentation.

 

In Normal view, display Slide 1.   Apply the Split transition and change the Effect Options to Horizontal Out.   Change the Duration to 1.75, and then apply the transition to all of the   slides in the presentation. 

 

Insert a Header & Footer on   the Notes and Handouts. Include the Date and time updated automatically, the   Page number, a Footer with the text 1F_Refuge and then apply to all notes and   handouts.

 

Display the Document Properties.   As the Tags type refuge, tours
  Note—Mac users use the Keywords box.

 

Save and close the file, and   then submit for grading.

1000 words

 The topic of your choice within Information Assurance during this course.  The final project should be a Word document which includes:

  • The research paper should be about 4-5 pages, including a cover page and this must be a Word document.
  • Include at least three references in APA format. This must be at the end of the Word document

Excel

this assigment have to be done in Excel. I have uploaded two documents. The first one are the instructions and the second one is the format with Excel that I have to complete with the instructions mentioned. 

Software Project Management -2 Dis

 

Read chapter 2. Answer questions 1-3 on page 57, Internet Exercises from the textbook. Submit the RFP that you download.

  1. Based on the results of your search, find an RFP that has been posted on the Web. What company developed the RFP, and what is the company looking to accomplish?
  2. Evaluate the effectiveness of this RFP based on information you have studied in this chapter. Discuss the strengths and weaknesses of the RFP. Are there any items missing from the RFP that should have been included?
  3. Download the RFP, and based on what you learned in this chapter, revise it. Highlight the areas you revised. What makes your revised RFP better than the original?

Discussion Reply!!! About 50 words

 

  • What suggestions do you have for your classmates on their network cabling? 
  • Are there any other suggestions for what they should consider for their equipment setup? 

 

  • Where are you moving to for your new work-from-home position? Which  ISPs are available at this location? Which do you pick and why?

    I  chose Dallas Texas as the city the work from home job is in. This city  has quite a few ISPs. The ISPs range from at&t to T-Mobile to  spectrum, but the ISP I chose is called Earthlink Internet. The reason I  chose this provider is they have decent reviews and seem to be very  reliable along with the high speeds for the internet of up to 5000 mbps  download and upload with there most expensive option and even though it  is very pricy with prices reaching up to $190 one of the cheaper options  at $90 is the same price as the internet i am currently paying for and  provides 1000 mbps download and upload. 

  • What equipment do you need for your work-from-home position? What  does your ISP provide? What does your employer provide? What do you need  to provide?

    Earthlink does not provide any hardware so I would  need both a modem to have access to the internet an a router to send a  WIFI signal out. Some companies usually provide what is need for the job  itself but if this company does not I would likely need to get a  computer equipped for the job and a phone. 

  • What types of network cabling will you be using and with which devices?

    The ISP I chose uses fiber optic cables foe the modem so that is what I would be using.

  • How do you determine the IP addresses on your devices?

    You can usually determine the IP address on devices through the WIFI settings on your devices.

  • How will you set up equipment in your office in your new home? Will  you be using wireless or hard wire for your network connection? What  else should be considered?

    Everything will be set up neatly in  one of the rooms it will be the same room as the modem and router for  optimum internet connection. I will have to get a desk for the setup and  a VPN for all of my devices.

References

Work From Home Technical Requirements, 2022, https://tbcdn.talentbrew.com/company/430/v2_0_US/pdfs/WFH-Tech-Requirement.pdfLinks to an external site.

Earthlink Internet, 2022, https://inmycity.earthlink.com/