Monthly Archives: December 2022

SC_AC16_CS1-3a_FirstLastName_2 

Carpenter Family Camp

· Open the file SC_AC16_CS1-3a_FirstLastName_1.accdb, available for download from the SAM website.

· Save the file as SC_AC16_CS1-3a_FirstLastName_2.accdb by changing the “1” to a “2”.

o If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

· To complete this Project, you will also need to download and save the following support file from the SAM website:

o Support_SC_AC16_CS1-3a_Activity.xlsx

PROJECT STEPS

1. Carpenter Family Camp operates summer camps for youth as well as families on a lake in Maine situated near the coast. The camp includes activities for families as well as separate activities for adults and children. Optional adventures to nearby attractions are also available.
 

Create a new table in Datasheet View with the following options:

a. Rename the default primary key ID field to AdventureID, and then change its data type to Short Text. (Hint: The AdventureID field should remain the primary key.)

b. Change the field size of the AdventureID field to 4.

c. Add a new field with the name AdventureName and the Short Text data type.

d. Add another field to the table with the name AdultPrice and the Currency data type.

e. Add a fourth field to the table with the name ChildPrice and the Currency data type.

f. Save the table using Adventure as the name.

2. With the Adventure table still open in Datasheet View, change the font in the table to Arial Narrow and the font size to 12 pt.

3. With the Adventure table still open in Datasheet View, add the records shown in Table 1 below. If necessary, resize the AdventureName field so that all field values are completely visible. Save and close the Adventure table.

Table 1: Adventure Table Records

AdventureID

AdventureName

AdultPrice

ChildPrice

BB01

Bike   & Beach

$28.00

$20.00

HR01

Horseback   Ride

$30.00

$25.00

WJ01

Windjammer   Cruise

$45.00

$35.00

WW01

Whale   Watching

$32.00

$26.00

4. Open the Reservation table in Design View and make the following changes:

a. Change the data type for the LodgingFee field to Currency.

b. Specify that the SessionID field is a Required field.

c. Save the changes to the Reservation table, and then close it. (Hint: Because you made changes to data types and field sizes, the “Some data may be lost” warning message appears. The data fits within the valid ranges, so ignore this message and continue saving the table.)

5. Open the Relationships window, and then add the Camper table to it. Create a one-to-many relationship between the ParentID field in the Parent table and the ParentID field in the Camper table. Make the relationship enforce referential integrity and cascade update related fields. Do not make the relationship cascade delete related records. Save the relationships, and then close the window.

6. Open the Counselor table in Design View and make the following changes:

a. Add a new field following the Specialty field. Assign the name CPR Certification to the field. 

b. Set the data type for the field to Yes/No.

c. Set the Caption property, using CPR as the value.

d. Enter CPR certification current? as the description for the field.

e. Save the changes to the Counselor table, and then close it.

7. Open the Reservation table in Datasheet View, and then find or navigate to the record with the ReservationID field value 1700012. Change the LodgingFee field value to $140.00.

8. With the Reservation table still open in Datasheet View, apply a filter by selection to locate all records where the SessionID field value equals 1. Change the AdultPrice field value for ParentID 101 to $245.00. Change the ChildPrice field value for the same record to $215.00. Clear all filters. Save and close the Reservation table.

9. Open the Counselor table in Design View. Use the Lookup Wizard to change the Specialty field to a Lookup field. Type in the following four values (in the order shown) as the list of possible values for the field: Arts & Crafts, Land Sports, Nature Studies, and Water Sports. Limit the field values to only the items in the list, and do not allow multiple values for the field.

10. With the Counselor table still open in Design View, delete the HomePhone field. (Hint: If a message appears concerning deleting an index, continue with the deletion.) Save the Counselor table.

11. Switch to viewing the Counselor table in Datasheet View, and then change the SpecialCertification field value for Susan Kiley (who has a CounselorID field value of KS01) to Wilderness First Aid. Close the table.

12. Import the data from the file Support_SC_AC16_CS1-3a_Activity.xlsx, available for download from the SAM website. Append the records to the Activity table. Do not create a new table, and do not save the import steps.

13. Carpenter Family Camp requires all campers to submit a signed liability waiver from their parents. Create an update query to change the Waiver field value to No for all records currently in the Parent table. Run the query, and then save it using Waiver Update Query as the name. (Hint: 21 records will be updated by this query.) Close the query.

14. Use the Simple Query Wizard to create a query based on the Counselor table with the following options:

a. Include the CounselorID, FirstName, LastName, and CellPhone fields (in that order).

b. Save the query with the name Counselor Contact Query, and then close the query.

15. Create a new query in Design View based on the Counselor and Counselor_Session tables with the following options:

a. Include the SessionID field from the Counselor_Session table.

b. Include the LastName, FirstName, and CellPhone fields (in that order) from the Counselor table.

c. Sort the records in ascending order based on the SessionID field and then by the LastName field.

d. Save the query using Session Contact Query as the name.

e. Run the query, and then close it.

16. Use the Crosstab Query Wizard to create a crosstab based on the Reservation table with the following options:

a. Use only data from the Reservation table in the query.

b. Use SessionID as the row heading.

c. Use Children as the column heading.

d. Use a sum of the ChildPrice field as the calculated value for each row and column intersection in the crosstab query.

e. Save the crosstab query using Session-Child Crosstab as the name.

f. View the query, and then close it.

17. Create a new query in Design View based on the Reservation table and the Session 1 Payments table with the following options:

a. Select the ParentID field from the Reservation table.

b. Select the ReservationID, SessionID, AdultTotal, ChildTotal, and Lodging fields (in that order) from the Session 1 Payments table.

c. Move the ParentID field to the right of the SessionID field.

d. Add a calculated field after the Lodging field with the alias TotalFees that calculates the sum of the AdultTotal, ChildTotal, and Lodging fields.

e. Save the query using Session 1 TotalFees Query as the name.

f. View the query, confirm that it matches Figure 1 below, and then close it.

Figure 1: Session 1 TotalFees Query

18. Open the States Query in Design View, and then add the criteria to select only those records with a State field value of NY or NJ. Save and run the query, and then close it. (Hint: This query should return records that meet one or more of the query conditions.)

19. Open the Younger Males Query in Design View, and then add the criteria to select only those records with a Gender field value of M and an Age field value of less than 10. Hide the Gender field. Save and run the query, and then close it. (Hint: This query should only return records that meet both of the query conditions.)

20. Open the Sessions Total Query in Design View, and then modify it by adding Totals to the query. For the SessionID field, set the Total row to Group By. For the ReservationID field, set the Total row to Count. Save and run the query, and then close it.

21. Create a Split Form based on the Parent table. Save the form as Parent Update Form, and then close the form.

22. Open the Parent Update Form, and then add a new record to the Parent table, using the values shown in Figure 2 below. Close the form.

Figure 2: New Record for the Parent Update Form

23. Create the simple report shown in Figure 3 below for the Adventure table. Save the report with the name Adventure Report, and then close the report.

Figure 3: Adventure Report

24. Use the Report Wizard to create a new report based on the Parent table with the following options:

a. Include the ParentID, FirstName, LastName, HomePhone, and CellPhone fields (in that order) from the Parent table.

b. Use no additional grouping in the report.

c. Sort the report in ascending order by the ParentID field.

d. Use the Tabular layout and Portrait orientation for the report.

e. Assign the name Parent Contact Report to the report.

f. Preview the report to ensure that it matches Figure 4 below, and then save and close the report.

Figure 4: Parent Contact Report

25. Open the Session 1 Report in Layout View, and then make the following changes to the report:

a. Remove the City and State columns from the report.

b. Add a Totals row that calculates the sum of the values in the Adults column and the sum of the values in the Children column. If necessary, expand the size of the total control so that it appears completely.

c. Change the title of the report using Session 1 Camper Report as the name.

d. View the Session 1 Report in Report View, confirm that it matches Figure 5 below, and then save and close the report.

Figure 5: Session 1 Report

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

Continue to normalize the design and create a logical model using the conceptual data model created in the last unit and leveraging the same  Movies Dataset .

In a Word document, write the following:

1. For each of the entities, define all of the attributes. Define the data type and nullability of each attribute. Explain your choices.

2. For each of the entities, define the primary key. Define the data type and nullability. Explain your choices.

3. For each of the entities, define any foreign keys. Define the data type and nullability of each key. Explain your choices.

4. Create a logical model diagram using Microsoft Visio. Refer to the learning activity for an example. Please embed the Visio diagram in your Word document so that you are only submitting a single document for this Assignment.

What did you refer to while working on this Assignment? Annotate those as your references at the end of the paper.

Be sure your work demonstrates the ability to apply critical thinking skills to illustrate sound reasoning. This includes the ability to identify entities, formulate inferences and identify relationships between entities, identify faulty reasoning, assess assumptions, formulate conclusions, and assess what you referred to while you worked on this Assignment.

Assignment Requirements

Generate the logical design diagram using Microsoft Visio.

Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Copy the design diagram(s) into your Word document. Be sure to use appropriate APA format and cite your textbook or other sources that you used in the assignment.

1. I need a research paper on how to download the Metadata repository from Github.

2. Create API using python to capture Metadata repository from GitHub.

3. Must include a flowchart to explain the way of capturing the Metadata Repository from Git.

4. Provide 1-2 pages of research paper including reference python code(if possible). 

Review Comments-1:

1. Detection of covid-19 using an infrared fever screening system (IFSS) based on deep learning

technology is the proposed title of this paper.

2. Keyword should be start with capital letter.

3. How to detect the visual images?

4. Selection of ML should be justified by the author.

5. How to provide screening data for each individual as output?

6. Explain the role of pooling layers?

7. Literary style of the paper should be improved.

8. Paper should be prepared as per template prescribed.

9. Figures are of poor resolution and clarity.

10. Minimum of 15 reference papers should be used in the reference section.

11. Dataset details are inadequate.

Review Comments-2:

There are adjustments for the authors have to be considered:

1. Detection of Covid-19 using an Infrared Fever Screening System (IFSS) based on Deep

Learning Technology is the proposed title of the paper.

Proceedings by Previous Publications

2022, 2021, 2020, 2019, 2018, 2017

2. There is evidence of research, but you need to relate it to your own study and more literature-

based evaluation in the discussion

3. The strengths and weaknesses of the method described in the paper can be clearly defined.

4. Comparative analysis with existing models related to efficiency computation may be provided

in a tabular format

5. The figures are of poor clarity and resolution. Figures taken from the literature should be cited

for their source.

6. Try to cite all the references used in the work and some of the references are not cited in the

work

7. Conclusion and Future Scope should be improved related to the proposed work.

	Points	Comments
1. Research solutions and detail the appropriate Microsoft Windows access controls including policies, standards and procedures that define who users are, what they can do, which resources they can access, and what operations they can perform on a system.10	10
2. Research and detail the cryptography methods to protect organizational information using techniques that ensure its integrity, confidentiality, authenticity and non-repudiation, and the recovery of encrypted information in its original form.10	10
3. Research and devise a plan to thwart malicious code and activity by implementing countermeasures and prevention techniques for dealing with viruses, worms, logic bombs, Trojan horses and other related forms of intentionally created deviant code.10	10
4. Research and formulate a plan to implement monitoring and analysis by determining system implementation and access as well as an incident response plan for security breaches or events.10	10
5. Research and detail security guidelines for contains the two proxy servers and Internet access control for the organization10	10
6. Research and define best practices for the security of NextGard’s organization.

Critical Thinking

There are numerous tools/techniques that allow hackers to gather a considerable amount of information about a target.

Write a short paper on footprinting by answering all the following:

· What is the objective of footprinting?

· What are some various footprinting tools/techniques?

· What type of information can these footprinting tools/techniques provide?

· How can organizations defend against footprinting and reconnaissance activities?

Your paper is required to be 3-4 pages in length, Not including the title and reference pages. It should follow 7th APA style guidelines, as appropriate.

It is strongly encouraged that you submit all assignments to the Turnitin Originality Check prior to submitting it to your instructor for grading. If you are unsure how to submit an assignment to the Originality Check tool, please review the Turnitin Originality Check Student Guide in your Student User Manual for step-by-step instructions.

PART 1

Assignment Instructions

You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:

Microsoft SQL Server Express

Microsoft SSMS

· Identify the elements to be included in the physical data model.

· Using SQL Server Management Studio Designer tools, create the database.

· Using SQL Server Management Studio Designer tools, create the tables (convert entity names to table names).

· Using SQL Server Management Studio Designer tools, associate column names (convert attribute names to column or field names), datatype, and number of characters for each attribute (field).

· Using SQL Server Management Studio Designer tools, establish the primary keys for each of the tables.

· Using SQL Server Management Studio Designer tools, establish any foreign keys for each of the tables (here you are converting your relationships to foreign keys).

· Create a screenshot of your SQL Management Studio showing the database and tables you have created; embed this screenshot into your Word document.

Please use the following guidance document to help you complete this assignment:  Instructions for Using the Microsoft SSMS Designer Tools to Generate the Movies Database

You will need to use the established  database design diagram  and  Movies Dataset  for this assignment. Download and use the diagram and data for your analysis.

Assignment Requirements

Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.

Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots from SQL Server Management Studio showing the work performed for the creation of the database and tables.

PART 2

In Assignment part 1, you created a physical model for a database using SQL Server Management Studio Designer tools. You can also create a database using SQL Data Definition Language (DDL) statements. In this unit, you will create the same database using the SQL CREATE statement to create the database and the tables. In business, you will have choices of different methods for creating a database, so you want to be familiar with the various options.

Assignment Instructions

You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:

Microsoft SQL Server Express

Microsoft SSMS

Use the SQL Management Studio Query Window to implement a new version of the Movies database. You will name this database  Movies_2.

· Create the database using the SQL CREATE statement.

· Create the tables using the SQL CREATE statement.

· Associate column names and datatype using the SQL create statement.

· Establish the primary and foreign keys for each table.

· Create a screenshot of your SQL Queries that you used to create the database and tables.

You will need to use the established database design diagram and Movies Dataset you used in Assignment 1 of this unit for the Movies 2 implementation. Download and use the diagram and data for your analysis.

Assignment Requirements

Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.

Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots of your SQL statements and confirmatory output (e.g., table structure definitions) into the Word document.

Project Description:

You and a friend from college are starting a new business, Pool Pros, a pool maintenance and supplies operation. You plan to have on hand various documents and brochures related to pool ownership, one of which you are working with now. You will use skills presented in this chapter to format text, adjust alignment and indents, bullet and number lists, and incorporate various types of graphic objects that help describe the process of caring for a pool.

Start Word. Download and open   the file named Exp22_Word_Ch02_Cumulative_Pool.docx.   Grader has automatically added your last name to the beginning of the   filename. Ensure that nonprinting characters are displayed.

Select crystal-clear perfection at the end of the first body paragraph   and bold it. Select all text and change the font to Arial. Change the   alignment of selected text to Justify.

Select the first two body   paragraphs on page 1 and adjust the line spacing to 1.5. Ensure that   paragraph spacing before and after is 0 pt for the selected paragraphs. Apply   a First line indent for the two paragraphs of 0.5″. 

Select all subheadings that are   formatted in bold and change the font size to 14. 

Select the four paragraphs that   precede the Get Rid of Debris   heading, beginning with Check the   pool’s water balance and ending with Add   an algaecide. Add a Box, double-line border with ¾ line weight and a color of   Blue-Gray, Text 2 (fourth column, first row). Shade the bordered area with Blue-Gray, Text 2 Lighter 60%   (fourth column, third row under Theme Colors).

Display the ruler. Click or   position the insertion point at the top of the document and press ENTER.   Click or select the newly inserted blank paragraph. Drag or move the First   line indent marker back to the left margin to remove the First line indent   from the blank paragraph.

Set a left tab at 1″ and a   right tab at 5″. Ensure that the right tab includes a dash leader. Press   TAB and type Your Pool. (Do not type the period.) Press TAB and type Your Way. (Do not type the period.) Change the font for Your Pool and Your Way to Lucida Calligraphy. Bold both text items on the first   line and change the font size to 10.

Click or position the insertion   point before the second sentence in the first body paragraph at the top of   page 3. The sentence begins with Add   more in hot weather. Delete the preceding space and period that ends the   first sentence. Insert an Em dash symbol and change the case of Add   to add.

Select the four paragraphs in   the shaded area near the top of page 1. Apply numbering, choosing Number   alignment: Left (1., 2., 3.).

Click or position the insertion   point at the top of the document and insert WordArt, selecting Fill: Blue,   Accent color 1; Shadow (row 1, column 2). Type Pool Maintenance. (Do not type the period.)   Change the font size of Pool   Maintenance to 24 and change the Text Fill to Black, Text 1. Ensure that WordArt   font is Arial. Wrap text at Top and Bottom and visually center the WordArt   horizontally on the first line 

Click or position the insertion   point at the end of the document and press ENTER. Insert SmartArt, selecting   Basic Cycle. Display the Text pane. Type Get rid of debris beside the first bullet. Type Vacuum pool beside the second bullet. Type Adjust   chemicals beside   the next bullet. Type Backwash filter and Add chlorine beside the next two bullets. Close the Text pane.

Adjust the SmartArt height to   3″ and the width to 5″. Choose Polished SmartArt style and change colors to Gradient Range   – Accent 3 (row 5, column 3). Choose text wrapping of Square. Align the   SmartArt object in the center relative to margins.

Click or position the insertion   point at the top of the document. Insert a Sun shape from the Basic Shapes category. Draw the   shape approximately 1″ wide and 1″ high, near the left margin on the top line   of the document. Using the Shape Format tab, adjust the height and width to   exactly 1″.

Change the shape fill of the sun   to Yellow. Insert a Cloud shape from the Basic Shapes category, sizing it to   be approximately ¾” high and ¾” wide. Position the shape so that it   overlaps the top right corner of the Sun shape. Change the shape fill of the   cloud to Light   Gray, Background 2. Send the cloud to the back so that it appears to be   peeking out from behind the sun.

Group the cloud and sun shapes   into one object. Duplicate the shape and drag the copy to the right, aligning   it at the right margin on the same line as the WordArt heading. Align the   first shape at the left margin, approximating a mirrored placement of the   copied shape.

Draw a text box of any size near   the middle of page 2. Copy the first sentence in the document, On a searing summer day, a swimming pool   is a welcome respite from the heat. (Include the period.) Paste the   copied sentence in the text box. Adjust text box height to 1″ and width   to 3″. Choose Tight text wrapping.

Change the font size of text in   the text box to 14 and change the font to Tahoma. Center the text. Click or press   Align in the Arrange group on the Shape Format tab and align the text box in   the middle and also in the center of the page. If the text box awkwardly   divides a heading, drag or move it down slightly to better position it   visually. Remove the outline from the text box and apply a shape fill of   Blue-Gray, Text 2, Lighter 80%.

View the document in Multiple   Pages and check for any poorly placed headings. Insert a page break before Vacuum the Pool at the bottom of page   1. Insert a page break before Add   Chlorine to the System at the bottom of page 2.

Save and close Exp22_Word_Ch02_Cumulative_Pool.docx.   Exit Word. Submit the file as directed.

Project Description:

In this project, you will use Word to prepare a document publicizing a series of space camp programs, designed for families and individuals. You will format the document as appropriate and include graphics to enhance document content.

Start Word. Download and open   the file named Exp22_Word_Ch02_CumulativeAssessment_Space.docx.   Grader has automatically added your last name to the beginning of the   filename. Ensure that nonprinting characters are displayed.

Select Underwater Astronaut Trainer in the first body paragraph and bold   it. Select Thermal Design Challenge   in the first body paragraph and bold it. Select all text from Space Academy on page 1 through Pack your bags on page 2 and change   the font to Cambria with a font size of 14. Change the alignment of selected   text to Justify.

Select the bulleted activities   in the Space Academy section on   page 1 and adjust the line spacing to 1.15. Ensure that paragraph spacing   before and after is 0 pt for the selected paragraphs.

Use Format Painter to copy the   format of the bulleted items in the Space   Academy section to bulleted items in the Space Camp section and also in the Adult Space Academy   section. 

Select the final three   paragraphs that are shown above the boxed area at the end of the document,   beginning with Sign up online and   ending with Pack your bags. Apply   numbering, selecting numbers that are followed by a period. Decrease the   indent so that the items begin at the left margin.

Display the ruler. Click or   select the blank paragraph above the bordered text at the end of the   document. Press ENTER. Set a left tab at 1″ and a right tab at 6″. Ensure that the right   tab includes a dash leader. Ensure that the font is 14 pt Cambria.

Press TAB and type SPACE ADVENTURE. (Do not type the period.) Press TAB and type DAVIDSON SPACE CENTER. (Do not type the period.) Drag   or move the 6” tab back to 5.5” on the ruler. Bold the tabbed line of text.

Select the tabbed line of text   and apply a Box border, choosing the first double-line style and ¾ pt width. 

Select the Space Camp Programs heading   at the top of the document. Insert WordArt, choosing Fill: Gray, Accent Color   3; Sharp Bevel (row 2, column 5). Ensure that the font size of the WordArt   heading is 36.

Click or place the insertion at   the end of the third bulleted item at the top of page 2, Compete in camp-wide Challenge nights! Press ENTER. Remove the   bullet from the new line. Insert SmartArt, selecting Circle Arrow Process from the Process group. Type Space Academy   in the top text   placeholder. Type Space Camp in the middle text placeholder. Type Adult Space   Academy in the   lower text placeholder.

Adjust the SmartArt height to   2″ and width to   2”. Change colors to Colorful Range – Accent Colors 2 to 3. Position the   SmartArt object, choosing Position in Middle Right with Square Text Wrapping.

Click or position the insertion   point at the top of the document, beside the Space Academy heading. Insert a Star: 4 Points shape from the Stars and Banners   category. Draw the shape approximately 1″ wide and 1″ high, near   the left margin on the top line of the document. Using the Shape Format tab,   adjust the height and width to exactly 1“.

Click or press Align in the   Arrange group on the Shape Format tab. Ensure that Align to Page is selected.   Click or select Align and align the shape in the center. Send the star to the   back so that it is located behind the WordArt heading object.

Change the shape fill of the   star to Gray, Accent 3, Lighter 80%. Change the Shape Outline to Black, Text   1. Apply a glow effect of Glow: 5 point, Orange, Accent color 2.

Group the star and WordArt items   into one object. Change text wrapping of the grouped object to Top and   Bottom.

Select the text Space Academy is the place for trainees to   experience first-hand the future of space travel, and train to solve   technically challenging problems the first sentence in the document. Copy   the selection. Deselect the text. Draw a text box of any size near the middle   of page 1 and paste the copied sentence in the text box. End the sentence   with a period. Adjust text box height to 2″ and width to 4″.

Change the font size of text in   the text box to 20 and change the font to Baskerville Old Face. Center the text.   Adjust text wrapping of the text box to Square. Drag or move the text box to   position it at the left margin above the Space   Camp heading near the bottom of page 1. Two bulleted items should wrap on   the right side of the text box. Apply a shape fill of Gray, Accent 3, Lighter   80%.

View the document in Multiple   Pages and check for any poorly placed headings or shapes. Insert a page break   before Activities at the bottom of   page 1. Insert a page break before It’s   as easy as 1-2-3 at the bottom of page 2.

Save and close Exp22_Word_Ch02_ML2_CumulativeAssessment_Space.docx.   Exit Word. Submit the file as directed.