Describe the steps involved in converting an entity-relationship diagram to a set of normalised tables.

What are the different options for converting a subtype-supertype hierarchy to relational tables?

Explain how the foreign key constraint maintains referential integrity between two tables when the database is inserted, updated, or deleted. What are the different 'referential actions' (foreign key rules) that can be specified?

Write a method (in Java) that will return output as stated below:

toThePowerOf(int): Applies exponentiation to the existing PolyTerm. For example, 2.4x^3 to the power of 3 should return 13.824x^9 while 2.4x^3 to the power of -3 should return 0.0723x^-9

Respective JUnit test for this question:

public void testToThePowerOf() {
       assertEquals(1, t1.toThePowerOf(3).coefficient, 0.0001);
       assertEquals(3, t1.toThePowerOf(3).exponent);

       assertEquals(13.824, t2.toThePowerOf(3).coefficient, 0.0001);
       assertEquals(9, t2.toThePowerOf(3).exponent);

       assertEquals(0.0723, t2.toThePowerOf(-3).coefficient, 0.0001);
       assertEquals(-9, t2.toThePowerOf(-3).exponent);

       assertEquals(-0.2962, t3.toThePowerOf(-3).coefficient, 0.0001);
       assertEquals(0, t3.toThePowerOf(-3).exponent);

       assertEquals(46.656, t4.toThePowerOf(3).coefficient, 0.0001);
       assertEquals(-6, t4.toThePowerOf(3).exponent);

       assertEquals(0.0016, t4.toThePowerOf(-5).coefficient, 0.0001);
       assertEquals(10, t4.toThePowerOf(-5).exponent);

       currentMethodName = new Throwable().getStackTrace()[0].getMethodName();
   }

Main Function:

public class PolyTermTest {
   public static int score = 0;
   public static String result = "";
   public static String currentMethodName = null;
   ArrayList methodsPassed = new ArrayList();
  
   PolyTerm t1, t2, t3, t4;

   @BeforeEach
   public void setUp() throws Exception {
       currentMethodName = null;
       t1 = new PolyTerm(1, 1); //x
       t2 = new PolyTerm(2.4, 3); //2.4x^3
       t3 = new PolyTerm(-1.5, 0); //-1.5
       t4 = new PolyTerm(3.6, -2); //3.6x^-2
   }

Use Tinkercad or any other tool to implement the following project

You have two Arduinos which are connected using serial cable

Arduino#1 is connected to the following components

1-LCD, , 2-DC motor, 3-Temperature Sensor

Arduino#2 is connected to an Alarm (Buzzer) + LED

You may use other components such as resistors, function generator, power supply, relay, etc.

The system should do the following:

1. Read the temperature every 1.5 seconds (DO NOT USE DELAY).
2. Starting at t=6 seconds, calculate the average temperature (Tavg) during the last 6 seconds. Repeat this process every 1.5 seconds (moving average).
3. Write the Tavg on the LCD.
4. If the Tavg is larger than 29 ̊C, drive a DC motor (fan) with 20% duty cycle. And then increase the speed of the fan with 10% for every 2 ̊C increase above 29. If the temperature goes below 27 C, turn the DC motor off.
5. If the Temperature become more than 35 ̊C, then the alarm will work on Arduino#2 and the LED will be ON

IN C

int count_primes(int start, int end)

{

  //TODO: return the count of prime numbers in range [start, end] inclusive.

  return 0;

}

QUESTION 1

1. ___________ is a way to pay for the raw infrastructure, which the cloud operator oversees on your behalf.

   		IaaS
   		PaaS
   		SaaS
   		FaaS

1 points   

QUESTION 2

1. ____________ is a function within IT systems that bridges the gap between development and operations of systems.

   		CI
   		CD
   		DevOps
   		Agile

1 points   

QUESTION 3

1. There are many different versions of cloud _________, and not all clouds are created equal.

   		names
   		idiosyncrasies
   		locations
   		architecture

1 points   

QUESTION 4

1. Amazon’s serverless technology is called_________ ; Google and Microsoft call theirs Google Functions and Azure Functions, respectively.

   		Lambda
   		Delta
   		Alpha
   		Theta

1 points   

QUESTION 5

1. ________ cloud is a reference to on-premises deployment models.

   		public
   		private
   		local
   		hybrid

from Big Java Early Objects 7th edition

Question
Declare an interface Filter as follows:

public interface Filter { boolean accept(Object x); }

Modify the implementation of the Data class in Section 10.4 to use both a Measurer and a Filter object. Only objects that the filter accepts should be processed. Demonstrate your modification by processing a collection of bank accounts, filtering out all accounts with balances less than $1,000.

Solve Exercise •• P10.6, using a lambda expression for the filter.

How would you use a use a lambda expression for the filter class?????
below is working code for the first part of the question, thanks.

*******************************************************************************

Filter.java <- needs to be lambda expression
public interface Filter
{
// this is what sifts through the -1000 and +1000 accounts
boolean accept(Object anObject);
}

below classes for
*******************************************************************************

BalanceFilter.java
public class BalanceFilter implements Filter
{
@Override
public boolean accept(Object object)
{
return ((BankAccount) object).getBalance() >= 1000;
}
}

*******************************************************************************
Measurer .java
public interface Measurer
{   
double measure(Object anObject);
}

*******************************************************************************

public class BankAccount
{
private double balance;
  
public BankAccount()
{
balance = 0;
}
  
public BankAccount(double initialBalance)
{
balance = initialBalance;
}
  
public void deposit(double amount)
{
balance = balance + amount;
}
  
public void withdraw(double amount)
{
balance = balance - amount;
}
  
public double getBalance()
{
return balance;
}
  
public void addIntrest(double rate)
{
balance = balance + balance * rate/100;
}
  
}

*******************************************************************************

DataSet.java
public class DataSet
{

public static double average(Object[] objects, Measurer meas, Filter filt)
{
double sum = 0;
double avg = 0;
int count = 0;
  
for (Object ob : objects)
{
if (filt.accept(ob))
{
sum += meas.measure(ob);
count++;
}
}
  
if (count > 0)
{
avg = (double)sum/count;
}
  
return avg;
}
  
public static void main (String[] args)
{

BankAccount accounts[] = new BankAccount[]
{
new BankAccount(200),
new BankAccount(1500),
new BankAccount(1000),
new BankAccount(2000),
new BankAccount(3000),
new BankAccount(0),
new BankAccount(50),
};
  
BalanceMeasurer measurer = new BalanceMeasurer();
BalanceFilter filter = new BalanceFilter();
  
double avg = average(accounts, measurer, filter);
System.out.println("Average for bank accounts with 1000.00 in collateral is "+avg);
}   
}

*******************************************************************************

BalanceMeasurer.java
public class BalanceMeasurer implements Measurer
{
public double measure(Object object)
{
return ((BankAccount) object).getBalance();
}
  
}

need to write program on python, without using any other libraries like panda, numpy, etc.

here is google link on csv file https://drive.google.com/file/d/1O3cC9JAPVkXSrddTR6RocpSV8NMHrmRx/view?usp=sharing

There is a csv file, which is exel file, very big and what program should do:

- Read a CSV file 'annual.csv' enterprise into a data structure

- Count the number of rows and columns

- Determine if the data contains empty values (should search in all rows)

- Replace the empty values by 'NA' for strings, '0' for decimals and '0.0' for floats (in all rows)

- Transform all Upper case characters to Lower case characters (in every word)

- Transform all Lower case characters to Upper case characters (in every word in file)

- save back the 'repaired' array as csv and show edited version

- Print out the size of the data (number of rows, number of columns)

the file approzimately looks like this, but it is very huge

1. Using ERP software, one can cut down on data duplication by keeping all your information within _______ cohesive system.

   		multiple
   		silo
   		one
   		departmental

1 points   

QUESTION 2

1. Epicor ERP’s strengths include the amount of data it can store and analyze, as well as the automation it can provide when it comes to __________.

   		customers
   		vendors
   		supply chain management
   		production

1 points   

QUESTION 3

1. Modern ERP practices began in the 1990s due to the rise of computer software being integrated with daily business____________.

   		requirements
   		costs
   		operations
   		expenditures

1 points   

QUESTION 4

1. This is any ERP software which is deployed directly on your in-site devices.

   		Open Source ERP
   		On-premise ERP
   		Cloud-based ERP
   		Hybrid ERP

1 points   

QUESTION 5

1. Odoo is a(n) _________ ERP and CRM used by over 4 million users worldwide.

   		simple
   		open-source
   		limited
   		closed

1 points   

QUESTION 6

1. ERP communication tools organize scanned documents, files, emails, texts, and phone call recordings.

   True

   False

1 points   

QUESTION 7

1. Microsoft is been a leader in the ERP software market for many years through its ________ product offerings.

   		Iron Mountain
   		Great Plains
   		Solomon
   		Dynamics

1 points   

QUESTION 8

1. With SAP HANA, one doesn’t need to take the time to load data from your transactional database into your reporting database, or even build traditional tuning structures to enable that reporting.

   True

   False

1 points   

QUESTION 9

1. Benefits of ERP Software include all except:

   		Low implementation costs
   		Streamlined workflows and processes
   		Visibility into workflows
   		Better financial planning and decision making

1 points   

QUESTION 10

1. It is important to use an industry-specific ERP solution because:

   		a general ERP system will weigh you down with unnecessary features
   		a specialized ERP system will weigh you down with unnecessary features
   		an industry-specific ERP system will cost less
   		a general ERP system will cost more

1 points   

MATLAB

4. Create two surface plots in the same figure window. Be sure to label the X and Y axes and provide a title for each plot. The top 3D surface plot should use one of the equations

Option 1:Z=sinX+sinY

Option 2:Z=sinX+cosY

Option 3:Z=cosX+cosY

and the bottom 3D surface plot should use one of the equations

Option 1:Z=sinX - sinY

Option 2:Z=sinX - cosY

Option 3:Z=cosX - cosY

For both plots, use a mesh grid with the same range for both the x-axis and y-axis. Use a range of -2π to 2π; the step (increment) of both dimensions of the grid should be 0.25.

Use a menu or listdlg command to allow the user to select which functions to use. Be sure to output which option the user selected. And, use an if statement that, based on the option chosen, creates plots with the correct functions.

Run your program twice with different user input and provide the output for each run.

Suppose a set of students want to create a virtual study groups. The set consists of 86 students on the eastern timezone, and 47 students in non-eastern time zones. Of the students in the eastern timezone, only 12 are not in Boston.

i. Suppose each group is made of 2 students, one in the eastern time zone and one from noneastern timezone. How many possible study groups are there?

ii. Suppose each group is made of 3 students, one in Boston, one in the eastern time zone but not in Boston, and one from the non-eastern timezone. How many groups can we make?

iii.suggest the Boston students form study groups amongst themselves first. The groups must have at most 5 people for optimal studying. He then secures 3 rooms for these groups. Each room can be safely filled by at most 5 study groups. Show if the students can form the groups safely and the groups fit in these 3 rooms, then there must be at least 3 people in each group.

iv. With rooms set, the in-person study groups can begin. However, the Boston students want to let their remote fellows join via a virtual meetings. How many remote students are guaranteed to join the most welcoming in-person group?

show your steps, please

Smart sensor nodes can process data collected from sensors, make decisions, and recognize relevant events based on the sensed information before sharing it with other nodes. In wireless sensor networks, the smart sensor nodes are usually grouped in clusters for effective cooperation. One sensor node in each cluster must act as a cluster head. The cluster head depletes its energy resources faster than the other nodes. Thus, the cluster-head role must be periodically reassigned (rotated) to different sensor nodes to achieve a long lifetime of wireless sensor network. Discuss in detail what are the major attributes required for choosing the optimal cluster head and explain how the choosing of optimal cluster head helps in
extending the lifetime of the wireless sensor networks, rotating the cluster-head role among sensor nodes with suppression of unnecessary data transmissions. ()

A certain advertising company has commissioned a study to determine if a recent advertising campaign is effective for certain age groups. Researchers have created a data file (results.txt) which contains the results attained by the study. The first column is the subject’s name (you may assume there is no whitespace in any name) and the second column indicates if the subject has seen the advertisement in question (Y or y means yes, N or n means no). The third column specifies the subject's age and the last column (the 'score') specifies how favorably the subject views the product being advertised (from 0 to 100 with a score of 100 being most favorable). A example of the file results.txt is attached. You should download this file to a convenient place on your hard drive. Please note that the file is a sample only. Your program should work on any data file that is formatted in a similar way.

results.txt example file -

Bailey           Y 16 68
Harrison         N 17 71
Grant            Y 20 75
Peterson         N 21 69
Hsu              Y 20 79
Bowles           Y 15 75
Anderson         N 33 64
Nguyen           N 16 68
Sharp            N 14 75
Jones            Y 29 75
McMillan         N 19 80
Gabriel          N 20 62
Huang            Y 62 21
Willoughby       Y 58 29
Davis            N 33 65
McGregor         Y 41 55

Your assignment is to prompt the user to enter the full pathname to the data file on disk. If the file does not exist in the specified location, your program should exit with a suitable error message.

The first thing your program should do is output to the screen a copy of the data read in from the disk file. This is known as “echoing” the input data. Your program should then calculate and display the the following results:

 Average score for subjects under 18 who have not seen the ad.

 Average score for subjects under 18 who have seen the ad.

 Average score for subjects 18 to 35 (inclusive) who have not seen the ad.

 Average score for subjects 18 to 35 (inclusive) who have seen the ad.

 Average score for subjects over 35 who have not seen the ad.

 Average score for subjects over 35 who have seen the ad.

Display your results to two places of decimals, and write your program to automatically list your six calculated averages one to a line, in the order above, along with a suitable label for each result.

Finally, your program should calculate and display to two places of decimals the overall average score for all of the subjects surveyed. (Note: Mathematically, this is NOT the average of the six averages you calculated previously).

Warning: There may be no subjects in any given category (such as over 35s who have not seen the ad). If so you cannot calculate the average (because you would get a divide by zero error) so instead of the average for that category you should display “No data to report”.