*** please don't copy and paste and don't use handwriting

Q1:

Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Q2:

What strategic competitive benefits do you see in a company’s use of extranets?

Q3:

Explain how Internet technologies are involved in developing a process in one of the functions of the business? Give an example and evaluate its business value.

Q4:

What are the basic differences between HRM, Intranet and Internet in terms of Domain and Network Communication Scope?

*** please don't copy and paste and don't use handwriting

Q1:

Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Q2:

What strategic competitive benefits do you see in a company’s use of extranets?

Q3:

Explain how Internet technologies are involved in developing a process in one of the functions of the business? Give an example and evaluate its business value.

Q4:

What are the basic differences between HRM, Intranet and Internet in terms of Domain and Network Communication Scope?

*** please don't copy and paste and don't use handwriting

Q1:

Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Q2:

What strategic competitive benefits do you see in a company’s use of extranets?

Q3:

Explain how Internet technologies are involved in developing a process in one of the functions of the business? Give an example and evaluate its business value.

Q4:

What are the basic differences between HRM, Intranet and Internet in terms of Domain and Network Communication Scope?

How do I get my program to ask the user to re enter the correct information if the information entered does not match the database records? When I run my program it does let me know that the information entered does not match the database records but it does not ask me to enter the information again.

Please add code (in bold) in the proper area with short explanation

package MailMeSQL;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Scanner;

import com.mysql.cj.jdbc.JdbcConnection;

public class mailmeMain {

   public static void main(String[] args) {

       Scanner scanner = new Scanner(System.in);

       System.out.println("Please Enter your Email:");

       String email = scanner.nextLine(); //get email from user

       System.out.println("Please Enter your pin:");

       int pin = scanner.nextInt(); //get pin from user

       printUserData(email, pin); // call printUserData method with email and pin

   }

   private static void printUserData(String email, int pin) {

       String url = "jdbc:mysql://localhost:3306/mailme";

       String username = "root";

       String password = "Chicago#71519";

       Connection connection = null;

       PreparedStatement preparedStatement = null;

       ResultSet result = null;

       try {

           connection = DriverManager.getConnection(url, username, password);

           String query = "select * from tenant_profile where email=? and pin=?";

           preparedStatement = connection.prepareStatement(query); // prepare the sql query

           preparedStatement.setString(1, email); // bind email value

           preparedStatement.setInt(2, pin); //bind pin value

           result = preparedStatement.executeQuery(); //execute query

                           while (result.next()) { //fetch result

               System.out.println("Email=" + result.getString("email") + ",pin=" + result.getString("pin")

                       + ",Package=" + result.getString("packages"));

           }

       } catch (SQLException e) {

           e.printStackTrace();

       } finally {

           if (result != null)

               try {

                   connection.close();

                   result.close();

               } catch (SQLException e) {

                   e.printStackTrace();

               }

       }

   }

}

ACCOUNTING INFORMATION SYSTEMS

Please answer your answer thoroughly. Thank you in advance!

Problem

11.8   As an internal auditor for the state auditor’s office, you are assigned to review the implementation of a new computer system in the state welfare agency. The agency is installing an online computer system to maintain the state’s database of welfare recipients. Under the old system, applicants for welfare assistance completed a form giving their name, address, and other personal data, plus details about their income, assets, dependents, and other data needed to establish eligibility. The data are checked by welfare examiners to verify their authenticity, certify the applicant’s eligibility for assistance, and determine the form and amount of aid.

         Under the new system, welfare applicants enter data on the agency’s Web site or give their data to clerks, who enter it using online terminals. Each applicant record has a “pending” status until a welfare examiner can verify the authenticity of the data used to determine eligibility. When the verification is completed, the examiner changes the status code to “approved,” and the system calculates the aid amount.  

         Periodically, recipient circumstances (income, assets, dependents, etc.) change, and the database is updated. Examiners enter these changes as soon as their accuracy is verified, and the system recalculates the recipient’s new welfare benefit. At the end of each month, payments are electronically deposited in the recipient’s bank accounts.

         Welfare assistance amounts to several hundred million dollars annually. You are concerned about the possibilities of fraud and abuse.

         a.      Describe how to employ concurrent audit techniques to reduce the risks of fraud and abuse.

         b.      Describe how to use computer audit software to review the work welfare examiners do to verify applicant eligibility data.  Assume that the state auditor’s office has access to other state and local government agency databases.

Write a python program for the following question.

Complete the symptom similarity function, which measures the similarity between the symptoms of two patients. See below for an explanation of how the similarity is computed.

def symptom_similarity(symptoms_A: Tuple[Set], symptoms_B: Tuple[Set]) -> int:

'''Returns the similarity between symptoms_A and symptoms_B.
symptoms_A and symptoms_B are tuples of a set of symptoms present and a set of symptoms absent.
The similarity measure is computed by the following equations:
present_present + absent_absent - present_absent - absent_present
where:

present_present is the number of symptoms present in both patients

absent_absent is the number of symptoms absent in both patients

present_absent is the number of symptoms present in patientA and absent in patientB

absent_present is the number of symptoms absent in patientA and present in patientB.

>>>symptom_similarity(yang, maria)
1

#yang = ({"coughing", "runny_nose", "sneezing"},{"headache","fever"})
#maria = ({"coughing", "fever", "sore_throat", "sneezing"},{"muscle_pain"}
# As you can see the common part in these two tuple is "coughing' so similarity is 1.
''''

Question 2: similarity to patients (18 points)
Complete the similarity to patients function, which uses the function symptom similarity to select
the patients (from the entire population of patients in our database) with the highest similarity between
the their symptoms and the symptoms of one patient. See below for an explanation of exactly what is
expected:

def similarity_to_patients(my_symptoms : Tuple[Set], all_patients: Dict[str, Tuple[Set]]) ->
Set[int]:
"""
returns a set of the patient IDs with the highest similarity between my_symptoms
(which is a tuple of symptoms present and absent) and the symptoms of
all the patients stored in the dictionary all_patients.
>>> similarity_to_patients(yang, all_patients_symptoms)
{45437, 73454}
#PATIENTS ARE ASSIGNED ID and those ID stores their symptoms. So we need to compare "yang's" symptoms to other patients symptoms in the database.
"""

I will drop a like for even attempting to give a fruitful solution.

Background:

When Ava started her Business Accounting firm 2 years ago, with 10 employees. This company of hers offers both accounting and bookkeeping services to businesses and is busy between December and April (5 months). Today, her company has 80 employees, supported by a team of 3 Information Technology staff. Her company has a local area network, capable of supporting 100 users/employees. In order to maintain data integrity and security, all data records are accessed via a database server running on the company’s local area network. The database server, of course, enables real-time access to data records. (Hence, no data records are stored on the employee’s computer.)

In the last 2 months, her company lost several bids on potential business projects due to the lack of IT resources, specifically the lack of storage capacity. Ava has decided to adopt the necessary the cloud computing service in order to resolve this issue. In other words, she has decided to shifte from assess-based physical IT resources to service-based virtual resources.

Your task:

1. Research and study to understand the key business operations of Accounting and the key business operations of Bookkeeping. 2. Create a screening rubric (in MS Word or MS Excel) to be used to evaluate/select the cloud service provider for resolving the abovementioned issue for Ava’s Business Accounting firm.

Hints:  You need to determine the cloud service that may resolve the issue before you can create the screening rubric.  Due to data sensitivity (integrity and security), Ava’s business can only use the private cloud model.  Using the rubric created by you, can you select a cloud service provider that can meet Ava’s business requirements?

1. Design an EER diagram for Motor, Inc.:

Motor, Inc. is a car dealer that sells both new cars and second-hand cars. You are the technical consultant of Motor Inc. and are currently helping the company to develop a database system. Your job is to draw an ERD to help them design the database.

• A car has a unique car ID, selling price, make, model, year, color, and car type (used to indicate a car is new or used).
• Motor Inc. has approximately 100 employees. An employee has an employee ID, job title, gender, salary, list of certifications, date of birth, and age. If an employee is currently married to another employee of Motor Inc., the date of marriage and who is married to whom must be stored; however, no record of marriage is required if an employee’s spouse is not an employee. An employee can handle none to multiple cars depending on his/her job title. A car can be handled by one to at most three employees.
• There are seven branches at this company, and each of which has a unique name. Each branch is located at different addresses, which contains information such as street, city, state, and zip code. Besides that, each branch has its own email address, and three phone numbers. Each branch has many employees. If there are less than three employees, the branch would be closed. An employee must belong to one and only one branch. Moreover, some employees are the branch heads for these branches. Each branch only needs one branch head, but an employee can manage multiple branches.
• The company also wants to track its customers’ information. A customer must provide SSN when registered with the company. The company would typically ask a customer to report their household income, and occupation. A customer can visit none or multiple branches, and a branch can be visited by none to multiple customers.

For this assignment, pretend you have been hired by a school district to create an application enabling access to educational videos freely available on the Internet.

For examples of places where these videos are available, check out this page:

https://www.refseek.com/directory/educational_videos.html (Links to an external site.).

For this assignment, you are responsible for developing a database schema (both conceptual and physical) to support this application. The schema must support the following application features:

1. It should be possible to efficiently search the application for videos, filtering on the following characteristics:
   • Title (required)
   • Keywords (note that a video may have multiple keywords)
   • Length of Video (required)
   • Appropriate Grade Level (optional)
   • Video Source (i.e. which of the sites referenced on the page above houses the video. required.)
2. It should be possible for teachers to comment on videos. Each comment should have the following fields:
   • Timestamp (required)
   • Name of teacher (optional)
   • Rating (1 to 5 stars, optional)
   • Text of comment (required)

The submission for this assignment should include the following artifacts:

• An entity-relationship diagram for the conceptual schema. You can do this on paper or whiteboard and submit a photograph, or do it using diagramming software and submit a screen shot or PDF. (Please do not submit a file in the diagramming software's native format.)
• A physical schema in the form of SQL CREATE TABLE statements. Please submit the SQL and not the database file (or files) itself.
• SQL INSERT statements creating at least 3 sample video records, each of which should have at least 2 keywords. Note that you will need to insert into multiple tables for each record if the assignment was done correctly.

This assignment can be completed adequately using as few as four tables. Your schema may end up with more tables and that is fine, but if you end up with more than 7-8 tables there is a good chance you are overthinking things.

I am tasked with creating a Java application that used 2 synchronized threads to calculate monthly interest and update the account balance

This is the parameters for reference to the code. Create a class AccountSavings. The class has two instance variables: a double variable to keep annual interest rate and a double variable to keep savings balance. The annual interest rate is 5.3 and savings balance is $100.
• Create a method to calculate monthly interest. • Create a method to run two threads. Use anonymous classes to create these threads. The first thread calls the monthly interest calculation method 12 times, and then displays the savings balance (the balance in 12th month). After that, this thread sleeps 5 seconds. The second thread calls the monthly interest calculation method 12 times, and then displays the savings balance (the balance in 12th month). Before the main thread ends, these two threads must be completed. • Add your main method into the same class and test your threads. After these two threads are executed, the savings balance must remain same

I am getting an error when calling monthlyInterest method inside my runThread method. non-static method monthlyInterest() cannot be referenced from a static context and I cant seem to figure out how to fix the issue.

import static java.lang.Thread.sleep;

class AccountSavings {

    double annualInterest=5.3;
    double savings=100.00;
  
  

    public void monthlyInterest(){
    double monthlyRate;
    monthlyRate = annualInterest/12;
    double balance = 0;
    balance+=savings*monthlyRate;
    }
  
    public synchronized static void runThread(){
  
        Thread t1;
        t1 = new Thread(){
            AccountSavings accountSavings= new AccountSavings();
            @Override
            public void run(){
                for(int i=1;i<13;i++){
                    System.out.println("Balance after " + i + "month: " + monthlyInterest());
                }
                try{sleep(5000);}
                catch(InterruptedException e){e.printStackTrace();}
            }
        };
    Thread t2= new Thread(){
  
    AccountSavings accountSavings=new AccountSavings();
    @Override
    public void run(){
  
        for(int i=1;i<13;i++){
        System.out.println("Balance after " + i + " month: " + monthlyInterest(balance));
        }
        try{sleep(5000);}
        catch(InterruptedException e){e.printStackTrace();}  
    }
    };
    t1.start();
    t2.start();
  
    }

    public static void main(String[] args){
  
        runThread();
  
    }

}