Category: Databases

Plan Plan your work in Excel by breaking it down into smaller tasks Use a to-do

Posted on | by Laureen

Plan
Plan your work in Excel by breaking it down into smaller tasks
Use a to-do

Plan
Plan your work in Excel by breaking it down into smaller tasks
Use a to-do list or project plan to keep track of progress and deadlines
Set goals and priorities to ensure you are making progress
Stay focused by minimizing distractions and being mindful of your time management
I hope these notes help! Let me know if there’s anything else I can do for you.

Certainly! Data structures are fundamental components of computer science that o

Posted on | by Laureen

Certainly! Data structures are fundamental components of computer science that o

Certainly! Data structures are fundamental components of computer science that organize, store, and manage data efficiently. They are crucial for designing efficient algorithms and solving complex problems. Here are some common data structures:
1. Arrays
Description: Contiguous memory locations used to store elements of the same data type.
Advantages: O(1) time complexity for accessing elements via index.
Disadvantages: Fixed size, insertion and deletion of elements can be costly (O(n) in worst case).
2. Linked Lists
Description: Elements (nodes) where each node contains data and a reference (link) to the next node.
Advantages: Dynamic size, efficient insertion and deletion (O(1) if pointer known).
Disadvantages: O(n) access time (must traverse from head), extra memory for pointers.
3. Stacks
Description: LIFO (Last In First Out) structure where elements are added and removed from the same end (top).
Operations: Push (add), Pop (remove), Peek (access top without removal).
Implementation: Can be implemented using arrays or linked lists.
4. Queues
Description: FIFO (First In First Out) structure where elements are added at the rear and removed from the front.
Operations: Enqueue (add), Dequeue (remove), Peek (access front without removal).
Implementation: Can be implemented using arrays or linked lists.
5. Trees
Description: Hierarchical structure with a root node and child nodes, each containing data and references to child nodes.
Types: Binary Tree, Binary Search Tree (BST), AVL Tree, Red-Black Tree, etc.
Operations: Search, Insertion, Deletion, Traversal (Inorder, Preorder, Postorder).
6. Graphs
Description: Collection of nodes (vertices) and edges (connections between nodes).
Types: Directed Graphs, Undirected Graphs, Weighted Graphs.
Representations: Adjacency Matrix, Adjacency List.
7. Hash Tables
Description: Data structure that maps keys to values using a hash function to compute an index into an array of buckets or slots.
Operations: Insertion, Deletion, Search (average O(1) time complexity).
Collision Handling: Separate Chaining, Open Addressing.
8. Heaps
Description: Complete binary tree where each node satisfies the heap property (min-heap or max-heap).
Operations: Insertion, Deletion (usually root), Heapify (maintain heap property).
Applications: Priority Queues, Sorting (Heap Sort).
9. Tries (Prefix Trees)
Description: Tree-like data structure used to store a dynamic set of strings where each node represents a common prefix.
Operations: Insertion, Deletion, Search (efficient for prefix-based queries).
10. Disjoint Sets (Union-Find)
Description: Data structure that keeps track of a set of elements partitioned into disjoint subsets.
Operations: Union (merge two sets), Find (determine which subset a particular element is in).
Summary:
Selection Criteria: Choosing the right data structure depends on the specific requirements like efficient search, insertion, deletion, and memory usage.
Trade-offs: No single data structure is ideal for all scenarios; each has its strengths and weaknesses.
Understanding these data structures and their characteristics is essential for designing efficient algorithms and solving problems effectively in computer science and software development.

This competency assessment assesses the following Outcome(s): N300M2-2: Apply da

Posted on | by Laureen

This competency assessment assesses the following Outcome(s):
N300M2-2: Apply da

This competency assessment assesses the following Outcome(s):
N300M2-2: Apply data collections, including arrays, lists and key-value pairs, in each language.
GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English.
Purpose
In Part 1, you will write programs using Java, Python, and R to use common data collections in each language. For Java, you will use the ArrayList, for Python you will use lists within lists, or sublists, and in R you will create a vector and matrix. Each will print out the contents of the data collection used.
For Part 2, you will write programs using Java, Python, and R to use common data collections in each language. For Java, you will use enumerations, for Python you will use sets and dictionaries, and in R you will create lists and data frames. Each will print out the contents of the data collection used.
Part 3 requires you to compose a report covering data collections for each language. The target audience for the report should be programmers who need an understanding of data collections and how they work for each language. It also fulfills the university-mandated communication requirement for the course.
Instructions
Part 1: Introduction to Data Collections
You must have Java, Eclipse, Python, PyCharm, R, and RStudio installed to perform this part of the assessment. The free editions should have been installed earlier in the course.
Complete the following:
For each of the following actions, use the appropriate language to complete a solution.
Please copy the numbered action into your Microsoft Word document.
For items 1–4 below, provide the actual code files and a screenshot of the execution of
each. Be sure to respond to item 5.
Start a next action on a new page.
For each language and using the values:
locomotive1=steam
locomotive2=diesel
locomotive3=electric
locomotive4=coal
locomotive5=wood
common=combined engines
Write a Java program, using ArrayList, and input the above data. Then loop through the values and print them all.
Write a Python program that uses sublists with the above data. Then loop though the list and print the values.
Write an R program that uses a Vector, input the values above and print the results.
Using R, create a matrix with six rows using the above data. Label the column header with “Train Type”.
Explain which data collection was the easiest to code and which was the most difficult. Pick one of each and explain why.
Place your screenshots and responses in a Microsoft Word document. Be sure to include the .R files with your code for the R portions.
Part 2: Advanced Data Collections
You must have Java, Eclipse, Python, PyCharm, R, and RStudio installed to perform this part of the assessment.
Complete the following:
For each of the following actions, use the appropriate language to complete a solution.
Please copy the numbered action into your Microsoft Word document.
For items 1–5 below, provide the actual code files and a screenshot of the execution of
each.
Start a next action on a new page.
Using Java, create an enumeration, called Packet, consisting of SOURCE_IP, DESTINATION_IP, PROTOCOL, and INFO. Use the values() method to loop through the enumeration. In that loop print each value and index using the ordinal() method.
As part of the mastery requirements for this Competency Assessment, complete the following boldfaced item:
Using the requirements for Step 1 above, write code in Java, that adds another value to the enumeration. The value and index are printed using ordinal(). The output is meaningful to the data.
Using Java and the same enumeration specifics above, create a program that compares the ordinal place for five values. Use the following:
p1 = Packet.INFO;
p2 = Packet.DESTINATION_IP;
p3 = Packet.PROTOCOL;
p4 = Packet.SOURCE_IP;
p5 = Packet.INFO;
Using the compareTo() method, check if p1 comes before or after p3. Then compare p1 to p5 to see if they are equal.
Using Python, create a set with the following specifics:
mySet = set({100,200,300,400,500})
Using ,mySet, print the set. Then add the following to the set: 150, 250, 350, 400. Print again and compare the output.
You should see the value of the set because 400 still appears once since duplicates are not allowed.
Remove 150, 250, and 350 from the set and print again.
Using Python, create a dictionary for the following: SOURCE_IP: 209.99.66.22
DEST_IP: 192.168.0.12
PROTOCOL: UDP
INFO: LEN=1068
Loop through the dictionary and print the key:value pairs.
As part of the mastery requirements for this Competency Assessment, complete the following boldfaced item:
Using the requirements for Step 4 above, write code, that adds dictionary value of TIME: 0.34153434562
Using R, create a data frame using the following: SOURCE_IP: 209.99.66.22, 209.99.66.100, 192.168.1.3
DEST_IP: 192.168.0.12, 209.99.66.222, 192.168.0.44
PROTOCOL: UDP, ICMP, TCP
INFO: LEN=1068, Destination Unreachable, Len=128
Then subset the SOURCE_IP as a list.
Subset the SOURCE_IP and DEST_IP as a matrix.
Finally, filter the PROTOCOL row to see if UDP is in it.
Print the output of each.
As part of the mastery requirements for this Competency Assessment, complete the following boldfaced item:
Using the requirements for Step 5 above, write code, in R, that subsets SOURCE_IP, DEST_IP, and PROTOCOL as a matrix.
Place your screenshots and responses in a Microsoft Word document. Be sure to include the .java files with your code for the Java portions.
Part 3: Data Collections Report
Based on the knowledge you have achieved thus far in this class, compose an informative report, in Microsoft Word, covering the various data collection types that you have covered for R, Python, and Java. Your paper should follow APA guidelines and be 3–5 pages in length, not including the required title and reference pages. Provide technical details since this report will be for programmers who will need to know the specific technical aspects of each language. In the report, summarize the concepts you have covered thus far in class. Include the different data collections by explaining their purpose and provide examples where necessary. Your report must include title and reference pages. You must have at least three references. Make sure to follow the most current APA guidelines.
Report Parameters/Expectations:
Include a title page and reference page.
Written work is provided in Standard English.
At least 3 pages in length, not counting the title slide and reference page.
Includes a highly developed viewpoint, purpose and exceptional written content.
Writing demonstrates superior organization, is well ordered, logical, and unified.
Free of written grammar, punctuation, and spelling errors.
No evidence of plagiarism.
At least 3 outside references on the topic of data concepts in addition to the text.
Make sure that the reference page is in the latest APA edition style.
Your submission for this part should meet any stated specifications listed above.
Place your screenshots and responses in a Microsoft® Word® document. Be sure to include the .py files with your code for the Python portio

To receive credit, you must complete the competency assessment. PLEASE read the

Posted on | by Laureen

To receive credit, you must complete the competency assessment. PLEASE read the

To receive credit, you must complete the competency assessment. PLEASE read the assessment rubric carefully to ensure that you have completed all competency criteria. If you wish to receive an A, you must carefully review the rubric and complete the required number of mastery criteria. PLEASE NOTE: If you receive a passing (B) grade on a competency assessment, you will not be allowed to resubmit your assessment to improve your grade.
This competency assessment (CA) assesses your level of performance on the specific Outcome(s) that are the focus of this module. The CA requires you to demonstrate your knowledge, understanding, and proficiency of the Outcome(s). Be sure to use the other activities in this module prior to attempting the CA. You can attempt the CA multiple times within the term; however, the CA must be completed successfully by the end of the term to earn credit. Refer to your Syllabus for additional information regarding the number of attempts permitted.
Be sure to review the Competency Assessment Rubric to understand the criteria on which you will be evaluated.
Instructors will provide feedback on the CA after each submission. If you expect to receive feedback, revise, and resubmit this CA near the end of the term, follow the guidelines and deadlines for submission in your Syllabus.
Please refer to your Syllabus for additional competency assessment requirements.
You may contact your instructor if you have any questions.This competency assessment assesses the following Outcome(s):
IN300M1-1: Implement expressions, decisions, and iteration in each language.
Purpose
Part 1 will provide the setup and use of development environments in Java, Python, and R. In those environments, you will write a program for each language showing the use of data types, operators, and expressions. This foundation will be built upon in future activities and serves as the core for each language.
Part 2 covers writing programs in Java, Python, and R that make decisions and iterates as required by the specifications. You will use the IF/ELSE IF/ELSE syntax as well as FOR and WHILE syntax.
Instructions
Part 1: Data Types and Operators
You must have Java, Eclipse, Python, PyCharm, R, and RStudio installed to perform this activity. You should use the free editions for each.
If you do not have the above software installed, please perform the required installations. The following documents will assist you with installation of the software:
Java
Eclipse
Python
PyCharm
R
RStudio
Complete the following:
For each of the following actions, use each language to complete a programming solution.
Please copy the numbered action into your Microsoft® Word® document.
For items 1–3 below, provide the actual code files and a screenshot of the execution of
each. Make sure to also respond to items 4 and 5.
Start a next action on a new page.
Getting user input examples in each language:
Java:
import java.util.Scanner;
public class IN300_Unit1_A1 {
public static void main(String[] args) {
Scanner sc = new Scanner(System.in);
System.out.println(“Enter your name”);
String employee = sc.nextLine();
Python:
employee = input(“Enter your name: “)
R:
employee <- readline(prompt="Enter your name: ") Write a program in Java that prompts the user for three numbers. Store each input value in its own number data type, such as firstNumber, secondNumber, and thirdNumber. Perform arithmetic operations that sums the numbers, and determines the average. Be sure to show code and result. Write a program in Python that prompts the user for three numbers. Store each input value in its own number data type, such as firstNumber, secondNumber, and thirdNumber. Perform arithmetic operations that sums the numbers and determines the average. Be sure to show code and result. Write a program in R that prompts the user for three numbers. Store each input value in its own number data type such as firstNumber, secondNumber, and thirdNumber. Perform arithmetic operations that sums the numbers and determines the average. Be sure to show code and result. After completing the above, discuss which language you liked the best or had the least amount of difficulty with. Also discuss which language you had the most difficult time with and why. Provide examples if you can. Research and explain the meaning of the “==” and equals() operators in Java. Include, how each works and when to use them. Your submission for this part should meet any stated specifications listed above. Place your screenshots and responses in a Microsoft Word document. Be sure to include the .java files with your code for the Java portions. Part 2: Decisions and Iterations You must have Java, Eclipse, Python, PyCharm, R, and RStudio installed and running. Complete the following: For each of the following actions, use each language to complete a programming solution. Please copy the numbered action into your Microsoft Word document. For items 1–9 below, provide the actual code files and a screenshot of the execution of each. Start a next action on a new page. For items 1–3, use these grade ranges: An A grade is between 90 and 100. A B grade is between 80 and 89. A C grade is between 70 and 79. A D grade is between 60 and 69. All other scores are an F grade. Write a program in Java that prompts the user for a score between 0 and 100. Test the entered value using IF/ELSE IF/ELSE statements using the scoring range given below. Print the grade based on input. Be sure to show code and result. Write a program in Python that prompts the user for a score between 0 and 100. Test the entered value using IF/ELSE IF/ELSE statements using the scoring range given below. Print the grade based on input. Be sure to show code and result. Write a program in R that prompts the user for a score between 0 and 100. Test the entered value using IF/ELSE IF/ELSE statements using the scoring range given below. Print the grade based on input. Be sure to show code and result. As part of the mastery requirements for this Competency Assessment, complete the following boldfaced item: Using the requirements for Steps 1–3 above, write code, in all three languages, to print a greeting message and values entered by the user prior to printing the resulting grade. For items 4–6, use the data below: Practice iteration (the loop). In a WHILE loop, print out this menu of Book Categories: Science Fiction Computers and Technology Cooking Business Comics Exit Then, ask the user to select one of the items in the menu (The user should enter an integer between 1 and 6. Any other input should print an error message and return to the user input). Based on the user’s choice, the output should be the book category related to the numerical choice, and maybe a complimentary message (e.g., “You selected Cooking. Cooking is a yummy choice”). After the category and message are displayed, the program should return the user to another opportunity to select from the menu. The loop should end only when the user selects number 6. Write a program in Java that uses the above requirements. Write a program in Python that uses the above requirements. Write a program in R that uses the above requirements. As part of the mastery requirements for this Competency Assessment, complete the following boldfaced item: Using the requirements for Steps 4–6 above, write code, in all three languages, adding another book category and complimentary message. Write a Java program that uses two nested FOR loops. The values used in the outer loop will be a user input value. The inner loop will use the input value divided by 2. Print a simple statement showing the values using the range of 1 to the user input number in the outer loop. The inner loop will print 1 to the divided result. Write a Python program that uses two nested FOR loops. The values used in the outer loop will be a user input value. The inner loop will use the input value divided by 2. Print a simple statement showing the values using the range of 1 to the user input number in the outer loop. The inner loop will print 1 to the divided result. Write an R program that uses two nested FOR loops. The values used in the outer loop will be a user input value. The inner loop will use the input value divided by 2. Print a simple statement showing the values using the range of 1 to the user input number in the outer loop. The inner loop will print 1 to the divided result. Your submission for this part should meet any stated specifications listed above. Place your screenshots and responses in a Microsoft® Word® document. Be sure to include the .py files with your code for the Python portions.

Hello I am looking for someone familiar with at least any coursers on here text

Posted on | by Laureen | Leave a Comment on Hello I am looking for someone familiar with at least any coursers on here text

Hello I am looking for someone familiar with at least any coursers on here text

Hello I am looking for someone familiar with at least any coursers on here text On whatsApp 4083121770 immediately before the spots are filled or email me at jamboes2020@gmail.com and tell me what course you can up 300monthly open the file to view the courses and picture to scan my WhatsApp attached

Shelly Cashman Access 365/2021 | Module 9: SAM Project 1a Personal Insurance,

Posted on | by Laureen | Leave a Comment on Shelly Cashman Access 365/2021 | Module 9: SAM Project 1a Personal Insurance,

Shelly Cashman Access 365/2021 | Module 9: SAM Project 1a

Personal Insurance,

Shelly Cashman Access 365/2021 | Module 9: SAM Project 1a

Personal Insurance, Inc.
Administering a Database System

GETTING STARTED
Save the file SC_AC365_2021_9a_FirstLastName_1.accdb as SC_AC365_2021_9a_FirstLastName_2.accdb Edit the file name by changing “1” to “2”.
If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.
To complete this Project, you will also need the following files:Support_AC365_2021_9a_ClaimTypes.accdb
With the file SC_AC365_2021_9a_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table. If the table does not display your name, delete the file and download a new copy.
PROJECT STEPS
Personal Insurance, Inc. is a national company that insures homeowners and renters. As a regional manager, you need to understand database administration tasks. Open the database in Backstage View, and then click the View and edit database properties link. When the Properties dialog box displays, create a custom property for the database as described below:

With the database still open in Backstage View, click the Options tab. Select the Main Menu Navigation Form as the Display Form for the database as shown in Figure 2. (Hint: The Display Form is sometimes referred to as the startup form.)
Save the changes to the options. (Hint: When the Access dialog box appears and displays the message, “You must close and reopen the current database for the specified option to take effect”, click the OK button.)
Open the ClaimsRep table in Design View, and then create a custom input mask for the ClaimRepNumber field as described below:

The ClaimRepNumber field must consist of two letters and two numbers.
All letters should display in upper case. (Hint: Enter >LL99 as the input mask.)
Save the changes to the table but do not close it.
With the ClaimsRep table still open in Design View, modify the ClaimsRepName multiple-field index by completing the following tasks:

Open the Indexes dialog box.
Change the sort order for the LastName field to Descending.

Save the changes to the ClaimsRep table and then close it.
Open the Customers table in Design View, and then create a single-field index on the LastName field. The index should allow duplicate values. Save the changes to the table design but do not close the table.
With the Customers table still open in Design View, create a multiple-field index as described below:

Use Location as the name of the index. (Hint: Be careful not to include spaces after the index name.)
Use the State field, sorted in Descending order, as the first field in the index.
Use the City field, sorted in Ascending order, as the second field in the index.

Save the changes to the Customers table and then close it.
Open the Claims table in Design View, and then open the Property Sheet for the table and make the following updates:

Create a validation rule for the table requiring that the Paid field value is always less than or equal to the ClaimAmount field value. (Hint: Enter [Paid]<=[ClaimAmount] as the validation rule. Enter Paid cannot exceed ClaimAmount as the validation text. Close the Property Sheet, and then save the changes to the table. (Hint: Because there was a change to data integrity rules, the "existing data may not be valid" warning message will appear. Click No and continue saving the table.) With the Claims table still open in Design View, create a multiple-field index as described below: Use ClaimsInformation as the name of the index. (Hint: Be careful not to include spaces after the index name.) Use the CustomerID field, sorted in Ascending order, as the first field in the index. Use the ClaimID field, sorted in Ascending order, as the second field in the index. Save the changes to the Claims table, and then close it. Create a Datasheet form for the Umbrella table, and then save the form using UmbrellaForm as the form name. Close the form. Create a blank form based on the 1 Right application part. (Hint: The blank form will appear in the Navigation Pane as a forms object named SingleOneColumnRightLabels and is saved automatically.) Import a table from an encrypted database by completing the following tasks: Open the encrypted database Support_AC365_2021_9a_ClaimTypes.accdb in Exclusive mode, using the password claims when the Password Required dialog box appears. Enable the content. Decrypt the Support_AC365_2021_9a_ClaimTypes.accdb database. (Hint: You will need to use the password claims again in the Unset Database Password dialog box.) Close the database. Open (or return to) the SC_AC365_2021_9a_FirstLastName_2.accdb database. Import the ClaimTypes table from the database Support_AC365_2021_9a_ClaimTypes.accdb into a new table using ClaimTypes as the table name. (Hint: Ensure that the Tables tab is selected in the Import Objects dialog box.) Do not save the Import steps. Use the Table Analyzer to analyze the Customers table for redundancy. Implement the following options when using the Table Analyzer Wizard: Select the Customers table as the table to analyze, and let the wizard decide what fields go in each table. Rename Table 1 as AltCustomers using the Rename table button as shown in Figure 3. Rename Table 2 as AltRegion using the Rename table button as shown in Figure 3. When the wizard displays the next screen with the question, "do the bold fields uniquely identify each record in the proposed table", make sure the CustomerID field is the primary key of the AltCustomers table as shown in Figure 3. Then, click the Next button. Ensure that the "No, don't create the query" radio button is selected, then click Finish to close the Table Analyzer Wizard. When the Table Analyzer Wizard dialog box appears with the message, "The command or action TileHorizontally isn't available now", click OK. Close the AltCustomers and AltRegion tables. Confirm the Navigation Pane matches Figure 4. Switch to viewing database items by the custom category named "Claims Information" in the Navigation Pane. Add the following two forms to the Claims Information Forms group: Claims Master Form ClaimsRep and Claims Form Confirm the Claims Information Forms group matches Figure 5. Add a new group to the Claims Information category as described below: Use Claims Reports as the name for the new group. If necessary, move the Claims Reports group so that it appears between the Claims Information Forms and the Unassigned Objects groups. In the Navigation Pane, add the Basic Claims Report to the new group. Confirm the Claims Reports group and item in the Navigation Pane match Figure 5. Figure 1: Custom Properties Tab in the Properties Dialog Box Figure 2: Access Options Dialog Box Figure 3: Table Analyzer Wizard Figure 4: Navigation Pane with Tables Created in Step 12 Figure 5: Navigation Pane Viewed by Claims Information Category 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 website to submit your completed project.