•  
  This first assignment will ask you to put into practice what you have  learned about searching the Internet and using Microsoft Word. Since  time management is one of the greatest challenges any college student  will face, you will research ways to improve your time management and  write up your findings using Microsoft Word.
   
  Assignment Requirement:
   
  To successfully complete this assignment, submit one (1) Microsoft  Word document that includes the following information and formatting.
   
  Main Steps:
   

1. Download the Assignment 1 Sample or PDF version.
2. Follow the walkthrough instructions here to complete this assignment or download and print the instructions so you can check each item off as you complete it.
3. Save your document with the following name – CIS105_Assignment1_FirstName_Last Name_Date.docx.
4. Submit your assignment through the submission button.
5. Walkthrough Instructions:
    
   Here is a list of everything you need to do to successfully complete Assignment #1. Just check off each item as you go. If you have any questions along the way, contact your professor and they can help you out.
    

• Create a new Word document. For tips on how to do  this, make sure to review the Getting Started section of your Word  Essential Training video (whichever version is appropriate for you to  view).
• Write an overview. At the top of your Word document  write an overview of why time management is important to you. (Idea:  You may find it helpful to do your research and research documentation  prior to writing the overview.)
• Online search. Many people have tips and tricks for  managing their time and it’s important to find new ideas that can help  you. Go online and find three (3) articles or videos that talk about  managing your time. (Idea: Use different search terms: “how to manage my  time,” “time management best practices,” “managing your time as a  student,” or “time management tips.” Think of different search  algorithms. You can use Google, another search engine, or the Strayer  Library.)
• Create a table. Now, create a table that has four (4) columns and four (4) rows.
• Fill in the columns of the table. In the left  column of the table, type “Website Title”, in the second column, type  “Source”, in the third column, type “What I Learned”, and in the fourth  far-right column, type “My Reviews”.
• Now, provide details about each website.  
  • Row 1: What was the name of article/video #1? What  is the source (what is the website name)? What did you learn from  reviewing this site? Did you think it was helpful and why or why not?  (answer in your own words.)
  • Row 2: What was the name of article/video #2? What  is the source (what is the website name)? What did you learn from  reviewing this site? Did you think it was helpful and why or why not?  (answer in your own words.)
  • Row 3: What was the name of article/video #3? What  is the source (what is the website name)? What did you learn from  reviewing this site? Did you think it was helpful and why or why not?  (answer in your own words.)
• Format your document.  
  • Add a Header that includes:  
    • The course title.
    • Your first and last name.
  • Add a title to the top of the page called “Time Management” or another title of your choice. Bold your title.
  • Add an image or screenshot between the overview and the table. You  could add a screenshot of an actual website you used or an image of a  clock or checklist to represent time management tips.
  • Below the image add a bulleted list of two (2) things you would like to start doing to better manage your time.
  • Add a footer, which includes the date you completed and submitted the assignment.
• Grading for this assignment will be based on answer quality, logic /  organization of the paper, and language and writing skills, using this rubric.
   
  Recommended TestOut Skills Labs to review prior to completing this assignment:
   
   
• 2.2.4 Skills Lab: Create Documents
• 2.11.4 Skills Lab: Manage References
• 2.7.5 Skills Lab: Edit Documents
• 2.8.4 Skills Lab: Insert Illustrations
• Recommended Lynda.com video to review prior to completing this assignment:
  Different options are listed based on the version of Microsoft Word  you are using (2016 vs. 2013, PC vs. Mac). Note: The Strayer student  laptops come with Microsoft Word 2016 PC version. Note: Review at a  minimum the Introduction and Getting Started chapters of the video.
   
• Word 2016 Essential Training
• Word 2013 Essential Training
• Word for Mac 2016 Essential Training
• Word for Mac 2011 Essential Training
• Note: This assignment will be run automatically  through SafeAssign plagiarism detection software and an originality  report will be sent to your instructor. Please make sure that you are  writing in your own words and not copying any information from outside  sources. Please review Strayer University’s Academic Integrity Policy before beginning this assignment.
      

6. How would you qualify the Street field in the Customer table?

 Qualifying a field name means that you input information in the table name in which the field belongs to and the field name. 

10.

How do you use an AND criterion to combine criteria in an Access query? How do you use an OR criterion to combine criteria?

12.

In which row of the Access design grid do you include functions? What functions can you use in Access queries?

14.

When sorting data on more than one field in an Access query, which field is the major sort key? Which field is the minor sort key? What effect do these keys have on the order in which the rows are displayed?

16.

When do you use an update query?

18.

When do you use a make-table query?

20.

Describe the purpose of the SELECT command in relational algebra.

22.

Describe the purpose of the JOIN command in relational algebra.

24.

Are there any restrictions on the tables when using the UNION command? If so, what are these restrictions?

26.

Describe the purpose of the SUBTRACT command in relational algebra.

28.

Describe the results of the division process in relational algebra.

Using Campbellsville University library and/or other sources, read at least four (4) academically reviewed articles on the ethical issues that may arise in information management. Please note that Wikipedia articles will not be accepted for this discussion.

1.    Write a comparative analysis of the articles noting the similarities and differences.

2.    Compare the information in those articles to the materials in Chapter 14 of your textbook. Does the premise of those articles support the overall theme of the materials in Chapter 14 of your textbook? Why or why not?

3.    Discuss what you learned from those articles. In your discussion, give example(s) of your organization handles ethic concerns as they relate to information management.

Update (10/24): 

• The file hashtable.py has been updated and now includes some code to get started with unittest (go to MS Teams to download it).
• You will want to download hashtable.py and add onto it, rather than importing it from a new file you create (since you won’t be able to extend the class across separate files).
• Yes, there is some redundancy between unit tests and the file test_hashtable.py. I am using test_hashtable.py in order to both test and interact with your class (more easily). If your unit tests are thorough/comprehensive, then it will likely look similar to the final version of test_hashtable.py that I will use. 

The tasks in this assignment are to extend the HashTable class that is currently defined in the file “hashtable.py” (located in MS Teams -> General -> Files -> Code). 

By extending it we will increase the functionality of the HashTable class (by adding more methods) and will make it more flexible (e.g. can resize itself as needed) and robust (e.g. no issues/errors when it is full and an item is added). 

The ways to extend the class, and thus the requirements for this assignment are as follows. 

1. Override Python len() function to work with HashTable in a specific way – Using def __len__ will override the Python len() function. The way this is implemented should be to return the number of items stored in the hash table (note: this is *not* the same as HashTable’s “size” field). 

2. Override Python in operator – This will be done using def __contains__ and should be implemented so this operator will then return a boolean when used in statements of the form  54 in myhashtable. For this example, the function should return True if 54 is an existing key in the HashTable instance myhashtable, and False if it is not. 

3. Override Python del operator – This is done by  using def __delitem__ and should allow for a key/value pair to be removed from an instance of HashTable (e.g. del h[54]). Think about how you want to handle cases when deleting a key that was involved with collisions. Be sure to include in the documentation for this method any assumptions/restrictions on how this can be used. 

4. Modify exiting put method to resize an instance as needed – The current HashTable implementation is limited in that it is not able to gracefully handle the case when an item is added to already full HashTable instance. This method should be modified to deal with this more gracefully, and should resize the instance for the user. Be sure to include documentation here describing exactly when you choose to resize and how you select an appropriate new size (remember that prime numbers are preferred for sizes, in order to avoid clustering, or an even more severe but subtle issue). 

All of those methods should be clearly documented to describe how and why the implementation is defined as it is. You will also want to use unittest on this assignment. One good use case for unittest will be to add a few items (and maybe even delete) one, and then to use unittest to verify that the slots and data fields are equal to what you expect. All of the extensions that you’ve added should be tested as well.  

Lastly, for grading, you will want to ensure that you’re program can be run through a test script. The test script will look like the code shown at bottom of this assignment description. When it is run we should expect output similar to what is shown in this screenshot.

test_hashtable.py (the final test script will vary slightly from this):

from <<your file name (without .py)>> import HashTable

# instantiate a HashTable object
h = HashTable(7)

# store keys and values in the object
h[6] = ‘cat’
h[11] = ‘dog’
h[21] = ‘bird’
h[27] = ‘horse’

print(“-“*10, “keys and values”, “-“*10)
print(h.slots)
print(h.data)

# check that data was stored correctly
print(“-“*10, “data check”, “-“*10)
if h.data == [‘bird’, ‘horse’, None, None, ‘dog’, None, ‘cat’]:
    print(”    + HashTable ‘put’ all items in correctly”)
else:
    print(”    – items NOT ‘put’ in correctly”)

# check that ‘in’ operator works correctly
print(“-“*10, “in operator”, “-“*10)
if 27 in h:
    print(”    + ‘in’ operator correctly implemented”)
else:
    print(”    – ‘in’ operator NOT working”)

# delete operator
del h[11]

# check that len() function is implemented and works
print(“-“*10, “len() function”, “-“*10)
if len(h) == 3:
    print(”    + ‘len’ function works properly”)
else:
    print(”    – ‘len’ function NOT working”)

# “in” operator (returns a boolean)
print(“-“*10, “len() after deletion”, “-“*10)
if 11 not in h:
    print(”    + ‘in’ operator works correctly after 11 was removed”)
else:
    print(”    – ‘in’ operator OR ‘del’ NOT working”)

# check that data was also removed
print(“-“*10, “data after deletion”, “-“*10)
if h.data == [‘bird’, ‘horse’, None, None, None, None, ‘cat’]:
    print(”    + data is correct after deletion”)
else:
    print(”    – data not correctly removed after deletion”)