Answer:
variable with a leading sign, three fractioned digits after the decimal point
Use the tables below to show the difference between the results of a natural join, an equijoin (with PROF_CODE = 2) and a full outer join. Provide the resulting table of each join
Answer:
Code:
CREATE TABLE student (
stu_code INTEGER PRIMARY KEY,
prof_code INTEGER
);
INSERT INTO student VALUES (100278,null);
INSERT INTO student VALUES (128569,2);
INSERT INTO student VALUES (512272,4);
INSERT INTO student VALUES (531235,2);
INSERT INTO student VALUES (531268,null);
INSERT INTO student VALUES (553427,1);
CREATE TABLE professor (
prof_code INTEGER PRIMARY KEY,
dept_code INTEGER
);
INSERT INTO professor VALUES (1,2);
INSERT INTO professor VALUES (2,6);
INSERT INTO professor VALUES (3,6);
INSERT INTO professor VALUES (4,4);
The SQL NATURAL JOIN is a type of EQUI JOIN and is structured in such a way that, columns with the same name of associated tables will appear once only. In our Example, Prof_code will appear only once and it will be matched in both the table;
SELECT * FROM Student natural join Professor on student.prof_code=Professor.prof_code ;
Stud_code Prof_code Dept_code
128569 2 6
512272 4 4
531235 2 6
553427 1 2
EQUI JOIN performs a JOIN against equality or matching column(s) values of the associated tables and an equal sign (=) is used as a comparison operator in the where clause to refer to equality. In our example, it will only show the result with prof_code=2 from the natural join result.
SELECT * FROM Student join Professor on student.prof_code=Professor.prof_code where student.prof_code=2;
Stud_code Prof_code Prof_code Dept_code
128569 2 2 6
531235 2 2 6
In SQL the FULL OUTER JOIN combines the results of both left and right outer joins and returns all (matched or unmatched) rows from the tables on both sides of the join clause.
SELECT * FROM professor full outer join student on professor.prof_code=student.prof_code ;
Stud_code Prof_code Prof_code Dept_code
100278
128569 2 2 6
512272 4 4 4
531235 2 2 6
531268
3 6
553427 1 1 2
Write a class of complex numbers consisting of:
-Properties:
• Real part of type double;
• Virtual part of type double.
- Method:
• default constructor, 2-parameter constructor;
• Full setter, getter for each variable;
• the print() function prints SoPhuc as a string in the format a + bi, where a is the real part, b is the imaginary part
-Write main() function:
• Create 2 SoPhuc objects
• Use class methods to enter information for 2 objects
• Use print() method to print information of 2 objects that have been created
Answer:
hi sorry for not knowing the answer
but please follow have a great day,night, or afternoon
Write an algorithm for a vending machine that sells just one product. The machine flashes a yellow light when the quantity inside is below 40% of capacity
Answer:
The algorithm is as follows:
1. Start
2. Capacity = 100%
3. Input Status (True/False)
4. While Status == True
4.1. Read Quantity (%)
4.2. Capacity = Capacity - Quantity
4.3. If Capacity < 40%
4.3.1 Display Yellow Flash
4.4. Input Status (True/False)
5. Stop
Explanation:
This starts the algorithm
1. Start
The capacity of the machine is initialized to 100%
2. Capacity = 100%
This gets the status of the sales
3. Input Status (True/False)
The following iteration is repeated until the status is false
4. While Status == True
Read current sales quantity from the user
4.1. Read Quantity (%)
Remove the quantity from the capacity
4.2. Capacity = Capacity - Quantity
Check is capacity is below 40%
4.3. If Capacity < 40%
If yes, display yellow flashes
4.3.1 Display Yellow Flash
This gets the status of the sales
4.4. Input Status (True/False)
End algorithm
5. Stop
After reading the background, please work on the following problem: a. The source process reads information from a file (Therefore, you need to prepare a small text file for testing purpose). b. The source process calls fork() to create the filter process. c. The filter process reads information from the source process (passed via an anonymous pipe), converts the uppercase characters to lowercase ones and vice versa, and then prints out the converted characters to the screen.
Answer:
Explanation:
The following code is written in Java. It has the main method (source process) and a function called fork() which contains the filter process as described in the question. fork() takes in the file information as a parameter and prints out the information to the screen. The test can be seen with the output in the attached image below.
import java.io.File;
import java.io.FileNotFoundException;
import java.util.Scanner;
class Brainly {
public static void main(String[] args) {
String data = "";
try {
File myObj = new File("C:\\Users\\Gabriel2\\AppData\\Roaming\\JetBrains\\IdeaIC2020.2\\scratches\\input.txt"); //USE YOUR FILE LOCATION
Scanner myReader = new Scanner(myObj);
while (myReader.hasNextLine()) {
data += myReader.nextLine();
data += "\n";
}
myReader.close();
} catch (FileNotFoundException e) {
System.out.println("An error occurred.");
e.printStackTrace();
}
System.out.println("Original: \n" + data);
fork(data);
}
public static void fork(String data) {
String output = "";
for (int i = 0; i < data.length(); i++) {
if (Character.isUpperCase(data.charAt(i)) == true) {
output += Character.toLowerCase(data.charAt(i));
} else if (Character.isLowerCase(data.charAt(i)) == true) {
output += Character.toUpperCase(data.charAt(i));
} else {
output += data.charAt(i);
}
}
System.out.println("Modified: \n" + output );
}
}
What are computer programs that make it easy to use and benefit from techniques and to faithfully follow the guidelines of the overall development methodology
Answer:
A Tool
Explanation:
Tools are computer programs that make it simple to use and benefit from techniques while adhering to the overall development methodology's guidelines. The correct option is A).
What are computer programs?A computer-aided software development case tool is a piece of software that aids in the design and development of information systems. It can be used to document a database structure and provide invaluable assistance in maintaining design consistency.
A computer software application is one that is developed to assist a particular organizational function or process, such as payroll systems, market analysis, and inventory control.
The goal of introducing case tools is to reduce the time and cost of software development, while also improving the quality of the systems created.
Therefore, the correct option is A) Tools.
To learn more about computer programs, refer to the below link:
https://brainly.com/question/9963733
#SPJ2
The question is incomplete. Your most probably complete question is given below:
A) Tools
B) Techniques
C) Data flow
D) Methodologies
(1)similarities between backspace key and delete key. (2) different between backspace key and delete key. (3) explain the term ergonomics. (4) explain the following. a click b right click double click d triple click e drag and drop.
Answer:
ddhejaajegxhzi
Explanation:
jfrhsjadigugud
Write a program get_price.py with a function get_price() that takes a dictionary of fruits as an argument and returns the name of the most expensive fruit. Each item of the dictionary includes: A key: the name of the fruit A value: the price of the fruit.
Answer:
The program is as follows:
def get_price(fruits):
AllPrice = fruits.values()
value_iterator = iter(AllPrice)
mostExpensive = next(value_iterator)
for item in fruits:
if fruits[item]>=mostExpensive:
mostExpensive = fruits[item]
fruitName = item
print(fruitName)
fruits = {}
n = int(input("Number of Fruits: "))
for i in range(n):
name = input("Fruit name: ")
price = int(input("Fruit price: "))
fruits[name] = price
get_price(fruits)
Explanation:
This defines the get_price function
def get_price(fruits):
This gets all price in the dictionary fruit
AllPrice = fruits.values()
This passes the values to a value iterator
value_iterator = iter(AllPrice)
This initializes mostExpensive to the first price in the dictionary
mostExpensive = next(value_iterator)
This iterates through the elements of the dictionary
for item in fruits:
If current element is greater than or equals most expensive
if fruits[item]>=mostExpensive:
Set most expensive to the current element
mostExpensive = fruits[item]
Get the corresponding fruit name
fruitName = item
Print fruit name
print(fruitName)
The main begins here
This initializes the fruit dictionary
fruits = {}
This gets input for the number of fruits
n = int(input("Number of Fruits: "))
This is repeated for every inputs
for i in range(n):
Get fruit name
name = input("Fruit name: ")
Get fruit price
price = int(input("Fruit price: "))
Append name and price to dictionary
fruits[name] = price
Call the get_price function
get_price(fruits)
Using simplified language and numbers, using large font type with more spacing between questions, and having students record answers directly on their tests are all examples of _____. Group of answer choices universal design analytic scoring cheating deterrents guidelines to assemble tests
Answer:
universal design
Explanation:
Using simplified language and numbers, using large font type with more spacing between questions, and having students record answers directly on their tests are all examples of universal design.
Universal Design can be regarded as design that allows the a system, set up , program or lab and others to be
accessible by many users, this design allows broad range of abilities, reading levels as well as learning styles and ages and others to have access to particular set up or program.
it gives encouragment to the development of ICTS which can be
usable as well as accessible to the widest range of people.
While troubleshooting an Internet connection problem for your network, you restarted the modem and then the router. The router is now communicating with the Internet, which you can confirm by observing the blinking light on the router's WAN indicator. However, now your laptop is not communicating with the router. Order the commands below to fix the problem and confirm connectivity.
a. ping
b. ipconfig /renew
c. nslookup microsoft.com
d. ipconfig /release
Answer:
d. ipconfig /release
b. ipconfig /renew
a. ping
c. nslookup microsoft.com
Explanation:
A router can be defined as a network device that is designed typically for forwarding data packets between two or more networks based on a well-defined routing protocol.
Basically, it is an electrical device or node that is designed to connect two (2) different networks (in different locations) together and allows them to communicate.
Generally, routers are configured using a standard routing protocol with an IP address as the default gateway.
Dynamic Host Configuration Protocol (DHCP) is a standard protocol that assigns IP address to users automatically from the DHCP server.
Basically, a DHCP server is designed to automatically assign internet protocol (IP) address to network devices connected to its network using a preconfigured DHCP pool and port number 67.
On a related note, when a computer that is configured with DHCP cannot communicate or obtain an IP address from the DHCP server, the Windows operating system (OS) of the computer automatically assigns an IP address of 169.254.33.16, which typically limits the computer to only communicate within its network.
I. ipconfig /release
II.. ipconfig /renew
III. ping
IV. nslookup microsoft.com
So, I need to use an external mic for my phone, but the problem is that I need a "dual mic adapter". My dad gave me an "audio splitter" instead. Can I use the audio splitter instead in order to connect the external mic to my phone???
But you can't use this device alone to connect two microphones to your USB C port and expect it to have usable volume. So the description is somewhat misleading ...
Shawn's supervisor has tasked him with determining how the company can increase the security of its Wi-Fi. Shawn plans to present several options to his supervisor and ask her to check his work. Which of the following is not a strong security method? (Select TWO.)
a. Disabling SSID
b. WPS
c. MAC filtering
d. Setting encryption
Answer:
The not strong security methods are:
a. Disabling SSID
b. WPS
Explanation:
When you disable SSID, you only make your Wi-Fi secure for the less determined attackers. By disabling the SSID (network name), those who are less technically inclined are prevented from connecting to the network but, this will not deter a more determined and technically savvy adversary. The best two options are MAC filtering and setting encryption. WPS (Wi-Fi Protected Setup) enables the process of connecting to a secure wireless network from a computer or other device easier instead of making it harder.
Calculator is an example of
computer
A. analogue
B. hybrid
C. manual
D. digital
E. public
D. digital
Explanation:
I hope it helps you
Write a program that generates an array filled up with random positive integer
number ranging from 15 to 20, and display it on the screen.
After the creation and displaying of the array , the program displays the following:
[P]osition [R]everse, [A]verage, [S]earch, [Q]uit
Please select an option:
Then, if the user selects:
-P (lowercase or uppercase): the program displays the array elements position and
value pairs for all member elements of the array.
-R (lowercase or uppercase): the program displays the reversed version of the
array
-A (lowercase or uppercase): the program calculates and displays the average of the
array elements
-S (lowercase or uppercase ): the program asks the user to insert an integer number
and look for it in the array, returning the message wheher the number is found and
its position ( including multiple occurences), or is not found.
-Q (lowercase or uppercase): the program quits.
NOTE: Until the last option (‘q’ or ‘Q’) is selected, the main program comes back at
the beginning, asking the user to insert a new integer number.
Answer:
#include <iostream>
#include <cstdlib>
using namespace std;
const int MIN_VALUE = 15;
const int MAX_VALUE = 20;
void fillArray(int arr[], int n) {
// fill up the array with random values
for (int i = 0; i < n; i++) {
arr[i] = rand() % (MAX_VALUE - MIN_VALUE + 1) + MIN_VALUE;
}
}
void displayArray(int arr[], int n) {
for (int i = 0; i < n; i++) {
cout << i << ": " << arr[i] << endl;
}
}
void main()
{
int myArray[10];
int nrElements = sizeof(myArray) / sizeof(myArray[0]);
fillArray(myArray, nrElements);
displayArray(myArray, nrElements);
char choice;
do {
cout << "[P]osition [R]everse, [A]verage, [S]earch, [Q]uit ";
cin >> choice;
choice = toupper(choice);
switch (choice) {
case 'P':
displayArray(myArray, nrElements);
break;
}
} while (choice != 'Q');
}
Explanation:
Here's a start. Now can you do the rest? ;-)
Which of the following acronyms refers to a network or host based monitoring system designed to automatically alert administrators of known or suspected unauthorized activity?
A. IDS
B. AES
C. TPM
D. EFS
Answer:
Option A (IDS) is the correct choice.
Explanation:
Whenever questionable or unusual behavior seems to be detected, another alarm is sent out by network security equipment, which would be considered as Intrusion Detection System.SOC analysts as well as occurrence responders can address the nature but instead, develop a plan or take steps that are necessary to resolve it predicated on such notifications.All other three alternatives are not related to the given query. So the above option is correct.
Kamal plans to offer new, more favorable contracts to business customers who are now receiving a discount and use wireless services. Determine whether each customer should receive a new contract as follows:
a. In cell 15, enter a formula using the AND function that tests whether the Wireless value is equal to "Y" and whether the Discount value is equal to "Y".
b. Fill the range 16:118 with the formula in cell 15.
Solution :
'AND" operation is a logical operation and is used in logical connective combining two statements and in truth tables.
Using AND operation verifies whether the outcome P and Q is true only when both the P as well as Q are true. If one of the P or Q is not true, then outcome result will be false.
In the context, Kamal wishes to offer a new and more favorable contracts to the business customers who use a wireless services and receive a discount.
Therefore, using the AND operation of the customers as :
Customer Wireless Discount Outcome
A N N FALSE
B Y N FALSE
C N Y FALSE
D Y Y TRUE
you are the network administrator for a college. wireless access is widely used at the college. you want the most secure wireless connections you can have. which of the following would you use?
A WPA
B WEP2
CWEP
D WPA2
Answer:
D. WPA2
Explanation:
Required
Of the 4 options, which is the most secured?
WPA was created as a solution to the vulnerabilities in WEP/WEP2. Then, WPA was upgraded to WPA2.
WPA2 is the least vulnerable to hacks because for every user that is connected to the network through WPA2, a unique encryption is made available for such connection.
Hence, the most secure connection, of the 4 is WPA2.
Management of software development consist of?
Chọn một:
a. Process
b. People
c. Project
d. All of the above
Answer:
d. All of the above
Explanation:
A software can be defined as a set of executable instructions (codes) or collection of data that is used typically to instruct a computer how to perform a specific task and to solve a particular problem.
A software development life cycle (SDLC) can be defined as a strategic process or methodology that defines the key steps or stages for creating and implementing high quality software applications.
In Computer science, management of software development consist of;
a. Process: it involves the stages through which a software application is analyzed, designed, developed, tested, etc.
b. People: it refers to the individuals involved in the software development process.
c. Project: it's the entirety of the stages a software goes through before it gets to the end user.
2.13 LAB: Branches: Leap Year
A year in the modern Gregorian Calendar consists of 365 days. In reality, the earth takes longer to rotate around the sun. To account for the
difference in time, every 4 years, a leap year takes place. A leap year is when a year has 366 days: An extra day, February 29th. The
requirements for a given year to be a leap year are:
1) The year must be divisible by 4
2) If the year is a century year (1700, 1800, etc.), the year must be evenly divisible by 400
Some example leap years are 1600, 1712 and 2016.
Write a program that takes in a year and determines whether that year is a leap year.
Ex If the input is
1712
the output is
1712 13 leap year.
Ex If the nouts
1913
the outoutis
1913 not leap year.
Written is Coral Language
Answer:
integer userInput
userInput = Get next input
if userInput % 400 == 0
Put userInput to output
Put " is a leap year" to output
else
if userInput % 4 == 0
Put userInput to output
Put " is a leap year" to output
else
Put userInput to output
Put " is not a leap year" to output
Explanation:
I don't know what is so special about Coral but here we go. I couldn't find and IDE that supported Coral so I just used their Coral simulator on their website. The first if statement on line 5 determines if the number is divisible by 400. If so, the leap year is on a century year e.g 1900 1800. If not, the else statement will be executed and the second if statement will execute. If the number is divisible by 4, it is a leap year. If not, the else statement gets executed in which case the number was not a century leap year or a leap year. After that the program terminates.
Hope this helped :) If it didn't let me know and I do my best to find out what went wrong.
Have a good day :)
If you lose yellow from your printer, what would happen to the picture?
Answer:
The picture would be green.
python is an example of a low level programming language true or false?
How do l write a program which countdown from 10 to 3
Answer:
use loop
for(int i =10;i>2; i--)
{
System.out.println(i+"\n")
}
Explain the purpose of the open() and close() operations.
Answer:
The open() operation notifies the system that the named file is about to become active. The close() operation notifies the system that the named file is no longer in active use by the user who issued the close operation.
List any two characteristics of ASCC.
Answer:
spirit of cooperation, collective responsibility
Explanation:
i had that question before
The two characteristics of Automatic sequence controlled calculator ( ASCC) include the following:
It is large sized,it makes use of a rotating shaft, andIt has the ability to perform different tasks at the same time.What is Automatic sequence controlled calculator ( ASCC)?The Automatic sequence controlled calculator (ASCC) is defined as the machine that was first installed in Cambridge in 1944 which was designed to solve advanced mathematical physics problems encountered in research.
The characteristics of Automatic sequence controlled calculator ( ASCC) include the following:
It is a very larger machine with the weight of about 5 tons.It's engine makes use of makes use of a horizontal rotating shaft.It has the ability to perform different tasks at the same time.Learn more about calculators here:
https://brainly.com/question/30197381
#SPJ2
if you want to present slides to fellow students or co workers, which productivity software should you use
Answer:
Power point is a good software to use for slides
Write a game that performs the roll of two dice randomly. The game should first ask for a target sum. Everytime the player enters r, the program should repeatedly print the side of the dice on a separate line. The game should stop prompting if one of these two events occur: -The sum of the two sides is equal to the target sum. -The player enters q.
Answer:
Explanation:
The following program was written in Java. It asks the user to first enter the target sum. Then it creates a while loop that continues asking the user to either roll dice or quit. If they decide to roll, it rolls the dice and prints out both values. If the target sum was hit, it prints that out and exits the program otherwise it loops again. The code has been tested and can be seen in the attached image below.
import java.util.Random;
import java.util.Scanner;
class Brainly {
public static void main(String[] args) {
Random rand = new Random();
Scanner in = new Scanner(System.in);
System.out.print("Enter Target Sum: ");
int targetSum = in.nextInt();
while (true) {
System.out.println("r: Roll Again");
System.out.println("q: Quit");
String choice = in.next();
char choiceModified = choice.toLowerCase().charAt(0);
if (choiceModified == 'r') {
int roll1 = rand.nextInt(6) + 1;
int roll2 = rand.nextInt(6) + 1;
int total = roll1 + roll2;
System.out.println("Dice 1: " + roll1);
System.out.println("Dice 2: " + roll2);
if (total == targetSum) {
System.out.println("Target Sum of " + targetSum + " hit.");
break;
}
} else if (choiceModified =='q') {
break;
} else {
System.out.println("Wrong choice");
}
}
}
}
I think you have been doing a great job but you haven’t been signing many people up for our new service feature I want you to set a goal of signing up 25% of your new customers for our new service feature if I get 96 new customers that means I have to get how many of them to sign up
Answer:
24 customers
Explanation:
Given
[tex]Customers = 96[/tex]
[tex]p = 25\%[/tex] --- proportion to sign up
Required
The number of customers to sign up
This is calculated as:
[tex]n = p * Customers[/tex]
So, we have:
[tex]n = 25\% * 96[/tex]
[tex]n = 24[/tex]
The menu bar display information about your connection process, notifies you when you connect to another website, and identifies the percentage information transferred from the Website server to your browser true or false
Answer:
false
Explanation:
My teacher quized me on this
Write a program palindrome.py that prompts for a sequence of words or numbers on a single line and checks if the entries are palindromes or not. A word or a number is a palindrome if it remains unchanged when reversed. e.g. rotor is a palindrome; but python is not a palindrome. e.g. 737 is a palindrome; but 110 is not a palindrome. The program receives the sequence as input and returns True if an entry is a palindrome or False if an entry is not a palindrome. Print the boolean value on one line. Print the palindromes count on the next line.
Answer:
Explanation:
The program first asks the user for the sequence of words. Then it splits the sequence into an array of words. Then it loops through the array checking each word to see if it is a palindrome. If it is it prints the word, the boolean value, and adds 1 to the palindrome_count variable. Otherwise it prints the word, false, and moves on to the next word in the list. Finally, it prints out the total value of palindrome_count.
word = input("Enter sequence of words: ")
word_list = word.split(' ')
print(word_list)
palindrome_count = 0
for word in word_list:
print('\n\n')
reverse = word[::-1]
if word == reverse:
print(word, end='\n')
print(True, end="\n")
palindrome_count += 1
else:
print(word, end='\n')
print(False, end='\n')
print("\n\nNumber of Palindromes in Sequence: " + str(palindrome_count))
explain the working principle of computer? can anyone tell
Answer:
input process and output hehe
Code Example 9-1 struct Product { string name; double price; int quantity; }; (Refer to Code Example 9-1.) Given a Product object named product, which of the following statements would you use to display the value of the name data member on the console? a. cout << product::name; b. cout << product.name; c. cout << product("name"); d. cout << product[0];
Answer:
a. cout << Product ::name;
Explanation:
Computer software use different languages which helps user to initiate command. When a user initiates command the results are displayed according to input command. If product name is required as output then insert command should be product::name; this will display names of different products present in the system.
