Monthly Archives: June 2023

Do a self-assessment of your draft paper (P 3)  (using the Self-Assessment criteria in Doc Sharing).

I am attaching the code as well. All i need is just an .exe file. If you can send me an exe file i can pay you.

1. Customer Satisfaction – Client IBM working as Kinaxis Integration consultant.

2. Deliver projects with in time and budget. (IBM Project, Working on Data model tables, having user sessions and explaining them all the tables in Kinaxis Rapid response.)

3. Integrate and Strengthen internal collaboration (This ones we need to talk about the Capgemini team how we Integrate and strengthen internally. I am having courses and sharing with teammates). 

Min Words: 250 

Write in essay format not in outline, bulleted, numbered or other list format.  

Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaninful title.

Include at least one quote from each of 3 different articles. Use the Research Databases available from the Danforth Library, not Google.

Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations).

International Foodies is an importer of exotic foods from all over the world. You landed a summer internship with the company and discovered that their product lists and the suppliers they buy from are stored in Excel workbooks. You offer to help by using your newly gained knowledge of Access to create a relational database for them. You will begin by importing the workbooks from Excel into a new Access database. Your manager mentions that she would also like a table that specifies food categories so that you can relate the products you sell to specific categories in the database. You will create a table from scratch to track categories, create relationships between the tables, and create some baseline queries.

Start Access. Open the downloaded   Access file named Exp19_Access_Ch2_Cap_Foodies. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

You   will examine the data in the downloaded Excel worksheets to determine which   fields will become the primary keys in each table and which fields will   become the foreign keys so that you can join them in the database.
 

  Open the Suppliers.xlsx Excel   workbook, examine the data, and close the workbook. Open the Products.xlsx Excel workbook, examine   the data, and close the workbook.
 

  You will import two Excel workbooks that contain supplier and product   information into the database.
 

  Click the External Data tab, click   New Data Source, point to From File in the Import & Link   group, and then select Excel.   Navigate to and select the Suppliers.xlsx   workbook to be imported as a new table in the current database. Select First Row Contains Column Headings.   Set the SupplierID field Indexed option to Yes (No Duplicates). Select SupplierID   as the primary key when prompted and accept the table name Suppliers. Do not save the import   steps.

Import   the Products.xlsx workbook, set the   ProductID Indexed option to Yes (No   Duplicates), and select ProductID   as the primary key. Accept the table name Products.

Change   the Field Size of the QuantityPerUnit field to 25   in Design view of the Products table. Set the Field Size of ProductID and   CategoryID to Long Integer. Save   the changes and open the table in Datasheet view. Open the Suppliers table in   Datasheet view to examine the data. Close the tables.

You   will create a new table that will enable International Foodies to associate   each product with a food category in the database.
 

  Create a new table in Design view. Add the following fields in Design view   and set the properties as specified:
 

  Add the primary key field as CategoryID   with the Number Data Type and Number assigned to a new category.   (type the period) as the Description. Set the Caption property to Category ID.
 

  Save the table as Categories.

   Add CategoryName with the Short Text Data Type and Name of food   category.   (type the period) as the Description. Change the field size to 15. Set the Caption property to Category Name and the Required property to Yes.

Add   CategoryDescription with the Long Text Data Type. Set the Caption property to Category Description. Switch to Datasheet view and save the   table when prompted. You will enter Category data into the table in the next step.

   You will add 8 records to the Categories table so that you have some sample   data to test in the database.
 

  Add the following records to the Categories table:

Category   ID Category Name   Category Description 

1 BEVERAGES  SOFT DRINKS, COFFEES, TEAS 

2 CONDIMENTS  SAUCES, RELISHES, SEASONINGS

3 CONFECTIONS   DESSERTS,   CANDIES, SWEET BREADS

4 DAIRY   PRODUCTS  CHEESES

5 GRAINS/CEREALS  BREADS, PASTA, CEREAL

6  MEAT/POULTRY  PREPARED   MEATS

7 PRODUCE  DRIED FRUIT, BEAN CURD

8 SEAFOOD  SEAWEED AND FISH

  Close the table.

You will create   the relationships between the tables using the Relationships window.
 

  Add all three tables to the Relationships window. Identify the primary key   fields in the Categories table and the Suppliers table and join them with   their foreign key counterparts in the related Products table. Select the Enforce Referential Integrity and Cascade Update Related Fields check boxes.   Save and close the Relationships window.

You   will use the Simple Query Wizard to create a query of all products that you   import in the seafood category.
 

  Add the ProductName, SupplierID, and CategoryID fields from Products (in that order). Save the query   as Seafood Products.

Add   a criterion in Design view, to include only products with 8 as the CategoryID.

Sort   the query results in ascending order by ProductName. Run, save, and close the   query.

You   want to create a query that displays actual category names rather than the   CategoryIDs. You are interested to know which meat and poultry products are   imported. You will copy the Seafood Products query and modify it to delete a   field, then add an additional table and field.
 

  Copy the Seafood Products query   and paste it using Seafood Or Meat/Poultry   as the query name.

Open   the Seafood Or Meat/Poultry query   in Design view and delete the CategoryID   column.

Add   the Categories table to the top   pane of the query design window. Add the CategoryName   field to the last column of the design grid and set the criterion as “Seafood” Or “Meat/Poultry”.   Run, save, and close the query.

You   will create a query that identifies suppliers and their associated products.   Because there is a relationship between the two tables, you can now pull data   from each of them together as usable information.
 

  Create a query in Design view that includes the Suppliers and Products   tables. The query should list the company name, contact name, phone (in that   order), then the product name and the product cost (in that order).

Sort   the query by company name in ascending order, then by product cost in   descending order. Run, close, and save the query as Company by Product List.

You   determine that the data in the Company by Product List query could be   summarized with a Total row. You will group the records by company name, and   then count the number of products you buy from each of them.
 

  Copy the Company by Product List query   and paste it using Summary of Company by   Product   as the query name.

Open   the Summary of Company by Product   query in Design view and delete the ContactName, Phone, and ProductCost columns.

Click   Totals in the Show/Hide group on   the Query Tools Design tab. Click in the Total   row of the ProductName field, click the arrow, and then select Count.   The records will be grouped by the company’s name and the products for each   company will be summarized.

Modify   the field name of the ProductName column as Product Count:   ProductName to make the field name more   identifiable. Click Run in the   Results group (20 records display in the Datasheet). The results display the   product count for each company that supplies your organization. Save and   close the query.

1. Complete Netlab 5 and submit your lab summary here.

   NETLAB 5. A. Understanding Buffer Overflows

   • Writing a buffer overflow program. 
   • Run code to demonstrate Buffer Overflow. 
   • Analyze and modify Overflow Code. 
   • NETLAB 5. B. Understanding SQL Commands & Injections
   • Basic SQL Commands. 
   • Querying with SQL. 
   • Deleting with SQL. 
   • Using SQLmap.
   • NETLAB 5. C. Backdoor With Netcat
   • Port scanning with Netcat. 
   • Establishing connection with Netcat. 
   • Transferring Files with Netcat 
   • SAMPLE SCREENSHOT.pdf

         Answer the following question(s):      

1. Think about how you would feel if there were no rules regarding  how your credit card information was stored on merchants’ websites.  Consider whether you would purchase items online. Would the Internet be  as big as it is today if we had no laws or information security policies  regarding data that makes up an e-commerce transaction? Provide  rationale for your answer.
2. Imagine that you work for an organization that has no Internet  use policy. Employees use the Internet in whatever way they want using  company-owned personal computers. Could this cause a problem for the  organization? Why or why not?

     Fully address the questions in this discussion; provide valid  rationale for your choices, where applicable; 

 How to hack cryptocurrencies and block chain systems? What are the biggest weakness in those systems? 

Programming-

JAVA

You have been hired to produce a report for a marketing research company.

Yellow Bird Marketing, Inc. has collected information from across the country regarding five different products.

They would like to follow up with 1% of these households.

Yellow Bird needs a third party to choose 1% of the households for one of the products.

Choices must be random.

You have been hired by Yellow Bird to develop a program that will use a random number generator to select 1% of the households for one product.

Each household is mapped to a unique number ranging from 1 to the number of households as listed below.

Choose one product from the following:

1. Product 1 (toothpaste) 37,650 households

2. Product 2 (vacuum cleaner) 38,135 households

3. Product 3 (motor oil) 36,785 households

4. Product 4 (grass seed) 40,125 households

5.Product 5 (television remote) 35,790 households

Requirements: Develop a program to select the households for follow up. Choose your product.

Create your code to randomly select 1% of the households for one of the five products.

You must use the random method.

Your code would generate houseHoldNumbers for 1% of the available household population.

For example, there are 37,650 households for product one.

The households are individually numbered from 1 to 37,650.

You need to generate 376 random houseHoldNumbers between 1-37,650.

A table containing these houseHoldNumbers should be produced and printed to the screen.

The table must not contain duplicates. Print 10 houseHoldNumbers per row.

You need to use at least one repetition statement, at least one array and the random method in this code.

For generating random houseHoldNumbers you should use the random() static method of class Math.

It returns a double so you will need to cast it as an integer.

If you chose product 1 you would set the generator numberOfHouseHolds to 37,650 and generate random houseHoldNumbers for 1% (376) of the households.

Emerging Technologies Write a paper on three of the following topics as it relates to or complements Systems Analysis and Design (SAD): Descriptive, Predictive & Prescriptive Analytics (why SAD should consider Analytics) Analytics Competencies Centers (Collaboration between Business Analysts, IT Specialists and Users) Cloud Computing (PaaS, IaaS, SaaS, DaaS, AaaS) (how SAD is different for cloud solutions) Hadoop and Advanced Data Management (data sources that may impact SAD) Blockchains (how Blockchains impact SAD) . Your research paper must be at least 4 pages in length, double-spaced, 12 font, and include at least 5 references, at least 2 of which must be peer-reviewed. Your paper must be formatted using APA guidelines. Do not include a cover page. Do not include an abstract. The reference page is NOT included in the 4-page length requirement. The paper should include an Introduction (to include a Hypothesis based on the research), Literature Review (Evidence) and Analysis of the Literature. All references must be cited within the text. Since the paper includes multiple topics, each topic must be separated and start with a HEADING. Include a conclusion at the end of the paper to summarize the entire paper and analyze how each topic relates together as related to the use of Systems Analysis and Design. Things I look for when grading: • I will look for high SafeAssign scores where large blocks of text have been obtained from other sources without citation OR where blocks of text have been obtained from other students. Students will be assigned a ZERO when plagiarism is indicated. • I will use the WORD Review-Split option on the Research paper, with the top pane looking at the paper’s content and the bottom pane looking at the Reference page. I will then search the content using the author’s name, for each Reference, to make sure each Reference was Cited. I will then search for every Citation to make sure a Reference exists on the Reference page for each citation. • I will use the WORD Review-Check Document to look for Spelling and Grammar errors. • I will look for instances where main topic areas are not linked together. • I will want to see a Hypothesis that is specific enough and is based on the research (i.e. the Hypothesis is specifically addressed within the text). • I will look for extraneous content that does not link back to the Hypothesis and topic.