Technical Documentation is one of the best sources to help you begin in excel. Thus, option A is correct.
What is excel?Excel is a software tool for creating and distributing spreadsheets, built by Microsoft.
Data analysts and some other customers could make that information simple to examine as content is loaded or altered by grouping items employing tools like Excel.
Technical documentation is a catch-all word for the various types of data produced to explain the performance, use, or construction of a given good, platform, or application.
Therefore, option A is the correct option.
Learn more about excel, here:
https://brainly.com/question/3441128
#SPJ1
How to Present a data flow diagram for a food ordering system.
Using DFD, let's examine how the meal ordering system functions (Data Flow Diagram). Food ordering system DFD.
An ordering system is what?The "mechanical" aspect of managing inventory is purchasing systems. These are the software applications that convert our projections, actual orders, safety stock, and order quantities into purchase requisitions or production orders.
What does the ordering system serve?An online ordering system's primary function is to give customers a method to order from a restaurant online. Why is this significant then? The major justification is that it's advantageous to both the client and the company.
To know more about Ordering system visit:
https://brainly.com/question/2249009
#SPJ13
What is the sql query for my homework
What is the average quoted price, maximum quoted price, and minimum quoted price of all orders? Display the average as ‘Average Quoted Price’, maximum quoted price as ‘Maximum Quoted Price’, and minimum quoted price as ‘Minimum Quoted Price’. Extra decimal places are okay for now. Insert your snip of the query and resultset together here:
The SQL Query for the average quoted price, maximum quoted price, and minimum quoted price of all orders is given below:
The SQL QueryDisplay itemcode and descr of those items.
Filter Closed and Rejected Quotations.
SELECT * FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')
Find maximum price of those quotations.
SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')
Fetch the itemcode of the quoation.
SELECT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE= (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed'))
Display the details of the fetched item.
SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN (SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE = (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')))
However, the following query doesn't show a logical error:
SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN
(
SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE =
(
SELECT MAX(QUOTEDPRICE) FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')
)
AND QSTATUS IN ('Rejected','Closed')
)
Read more about SQL here:
https://brainly.com/question/27851066
#SPJ1
First,
- select a classification methodology to learn in your project. Select either Classification Trees or Support Vector Machines.
- To actually get the data used in the ISLR examples, you will likely need to download an R package called ISLR; it contains the data sets used in the text.
- Begin by introducing your reader to the corporation from which your stock data (Leggett & Platt Incorporated) comes. Tell the reader something you learned about that corporation that you found interesting, something which would demonstrate to a recruiter that you possess curiosity and the ability to employ it.
- Then, using trimmed screenshots where needed from Excel, sketch out for the reader how you converted your Yahoo-sourced stock data into lagged stock risk data set since 2006.
Second,
-draw a random sample of size n=300 without replacement from your stock return data set. Recall that your stock return data contains a HiLo return column and standardized log lag1 and log lag2 return columns. I will call this your n=300 stock return data set. Show and explain how this is done.
- draw another random sample of size 300 without replacement from your stock return data set. Recall that your stock risk data contains a HiLo risk column and standardized log lag1 and log lag2 columns. I will call this your n=300 stock risk data set.
Next, using your n=300 stock return data set, walk through the steps covered by the ISLR text for your chosen method, SVM or CART, explaining in your own words what you are doing. Put your name into the title of any graphs you show.
Finally, run the program on your n=300 stock risk data set and compare the performance to that of your n=300 stock return data set. Include use of the chi-square test. Discuss the differences, the reasons that these would happen, and the lessons learned about the nature of the stock market.
third,
Select one of the tuning parameters or decision criteria that lie beneath the surface of your chosen methodology, CART or CART. Engage with it by researching beyond the ISLR text. Then experiment with it. Experiment with your data and with other data sets. Try decreasing or increasing n. Look at other sources for help, documenting the sources.
Forth,
Create classification space plots for both of your n=300 data sets, using your chosen methodology, SVM or CART. Be sure to explain how you went about this. Create the plot using the same techniques that we did in our plots for other methods.
] Prepare a comparative study of knn, naive Bayes, logistic regression, and your selected method. Make this comparison on your two n=300 data sets, splitting the data randomly in half to get the training and testing sets.
Explain what you are doing as you go along, explain what you understand about what distinguishes the methods, discuss reasons why the results vary, and why there might be systematic differences in performance between return data and risk data. Show classification space plots for knn, naïve Bayes, and logistic regression. At the end, show a single table in which you summarize the overall correct forecast rate for the stock returns for the four methods; then another table summarizing the performance on the stock risk data
Using the knowledge of the computational language in python it is possible to write a code that Create classification space plots for both of your n=300 data sets, using your chosen methodology, SVM or CART.
Writting the code:def randomize(X, Y):
permutation = np.random.permutation(Y.shape[0])
X2 = X[permutation,:]
Y2 = Y[permutation]
return X2, Y2
X2, y2 = randomize(X, y)
def draw_learning_curves(X, y, estimator, num_trainings):
train_sizes, train_scores, test_scores = learning_curve(estimator, X2, y2, cv=None, n_jobs=1, train_sizes=np.linspace(0.1, 1.0, num_trainings))
train_scores_mean = np.mean(train_scores, axis=1)
train_scores_std = np.std(train_scores, axis=1)
test_scores_mean = np.mean(test_scores, axis=1)
test_scores_std = np.std(test_scores, axis=1)
plt.grid()
plt.title("Learning Curves")
plt.xlabel("Training examples")
plt.ylabel("Score")
plt.plot(train_scores_mean, 'o-', color="g",
label="Training score")
plt.plot(test_scores_mean, 'o-', color="y",
label="Cross-validation score")
plt.legend(loc="best")
plt.show()
See more about python at brainly.com/question/18502436
#SPJ1
Name three current problems in your life that might be solved through a heuristic approach. Explain why each of these problems is heuristic in nature.
Heuristics are mental shortcuts for solving problems in a quick way that delivers a result that is sufficient enough to be useful given time constraints.Heuristic methods can help ease the cognitive load by making it easy to process decisions. These include various basic methods that aren't rooted in any theory per se but rather rely on past experiences and common sense.
Three current problems that can be solved through Heuristic Approach:
1. Challenging and routine work
2. When a student decide what subject she will study at university, her intuition will likely be drawn toward the path that she envisions most satisfying, practical and interesting.
3. Trial and error, which can be used in everything from matching nuts and bolts
The three heuristics Mentioned are: availability, representativeness, and anchoring and adjustment.
To know more about Heuristic from the given link
https://brainly.com/question/24053333
#SPJ1
Write the following short piece of code in python:
Programmers refer to a brief section of reusable source code, machine code, or text as a “snippet.” These are typically explicitly defined operational units that are integrated into bigger programming modules.
What are the short piece of code in python?Guido van Rossum created Python, an interpreted, object-oriented, high-level programming language with dynamic semantics. It was first made available in 1991.
The syntax of Python is straightforward and resembles that of English. Python's syntax differs from various other programming languages in that it enables programmers to construct applications with fewer lines of code.
Therefore, Python operates on an interpreter system, allowing for the immediate execution of written code. As a result, prototyping can proceed quickly.
Learn more about python here:
https://brainly.com/question/10718830
#SPJ1
Discuss types of indentation
Tasia is using accrual accounting in Quickbooks and creat3ed a customer invoice. What account is debited when the invoice is created?
Since Tasia is using accrual accounting in Quickbooks and creat3ed a customer invoice. The account that is debited when the invoice is created is option A: Accounts receivable.
When an invoice is created in QuickBooks Accrual, which account gets debited?Quickbooks will debit the AR account when I create an invoice, but does the account credit. Depending on whatever income account is linked to your product or service when you create an invoice, a credit will be applied to that account.
Note that Customers' outstanding debts for goods or services they have received but haven't yet paid for are referred to as accounts receivable. For instance, the amount owing when clients buy things on credit is added to the accounts receivable.
Learn more about Accounts receivable from
https://brainly.com/question/24848903
#SPJ1
See options below
Tasia is using accrual accounting in QuickBooks and created a customer invoice. Which account is debited when the invoice is created? Accounts receivable Sales of product income Owner's equity Checking account Miscellaneous income
uses of computer in communication
Uses of computers in communication:
1) Transfer of data
2)Transfer of information
3) Wireless message communication
4)Video service
5)E-mail
6) Internet and Fax
What is the use of computers in communication?
The mainstay of information technology, computers are essential for communication. Early in the 1990s, the first homes began to utilize the Internet, which eventually led to the widespread use of email, websites, blogs, social networking, and Voice-Over-Internet Protocol.
Above listed ones are the uses of computers in communication.
To know more about the information about computers in communication
https://brainly.com/question/26152499
#SPJ1
You have been using your Microsoft cordless mouse for a year but it suddenly stopped
working. You did not install the mouse software (driver) from Microsoft when you got the
mouse because you did not care about using custom features. You have been using the
generic mouse software for Windows. List all of the troubleshooting steps you would do
before declaring that the mouse is defective.
A wireless mouse can be very portable and effective in our day-to-day work on the computer but can develop problems. one of the problems you might come across is that it suddenly stops working. this can be caused by either a software or hardware issue.
What are the possible issues?Possible software issuesCorrupt drivers Faulty operating systemPossible hardware issues:
Weak batteryFaulty dongleFaulty USB portsFaulty components on the mouse panelBelow are a list of troubleshooting steps
Check switchReplace batteryUninstall drivers and reinstallupdate drivers (if any available update)Reinstall OScheck dongleTry on another computerLearn more about computer on:
https://brainly.com/question/24540334
#SPJ1
Your boss asks you to upgrade a desktop computer to add an extra DVI port for a second monitor. How would you recommend completing this request?
Where your boss asks you to upgrade a desktop computer to add an extra DVI port for a second monitor, the following steps are recommended:
If your PC only has one video port, you should be aware that you cannot use a splitter on a single SGVA, HDMI, or DVI interface. If you try to use a splitter with any of these ports, the same image will appear on both displays. It will not expand your work area over both monitors and work independently.
If your PC has a USB port, the best option is to purchase a DisplayLink connector. A DisplayLink connector allows you to connect and extend your display to another display by connecting it to a USB port.
What is a DVI Port?DVI, which stands for Digital Visual Interface, provides a noticeably crisper and better image than VGA. Because it can transport both digital and analog signals, it is a one-of-a-kind connection. DVI may simply be converted to other standards such as HDMI and VGA.
The Digital Display Working Group created the DVI (Digital Visual Interface) digital video interface (DDWG). It is often found on computers, LCD monitors, projectors, and other digital display devices and can accommodate both digital and analog video signals via a single DVI connection.
Learn more about DVI Ports:
https://brainly.com/question/7008263
#SPJ1
what's formatting in computer
Answer:
completrly erasing
Explanation:
Reformatting a computer means completely erasing (formatting) the hard drive and reinstalling the operating system and all other applications and files. All of your data on the hard disk will be lost, so you will need to back it up to an External HD, DVD, flashdrive or another computer.
Formatting of computer means erasing something like hard drive disks etc.
Explanation:
Format or document format is the overall layout of a document or spreadsheet. For example, the formatting of text on many English documents.
An array is called vanilla if all its elements are made up of the same digit. For example {1, 1,
11, 1111, 1111111} is a vanilla array because all its elements use only the digit 1.
However, the array {11, 101, 1111, 11111} is not a vanilla array because its elements
use the digits 0 and 1.
Write a program that reads a string from a user that represent array and check if its a vanilla
array. Otherwise it will print message as in the sample run shown below and should continue to
allow the user to enter values. The program will terminate only if the user press the "Enter" key
without entering any value. For example the '{1}' is a vanilla array since all elements use the
same digit. Where '{11, 22, 13, 34, 125}' array is not vanilla array becuase elements used 5
different digits.
Using the knowledge in computational language in JAVA it is possible to write the code that An array is called vanilla if all its elements are made up of the same digit.
Writting the code:import java.util.Scanner;
public class Main
{
public static void main(String[] args) {
int n;
Scanner sc=new Scanner(System.in);
System.out.print("Enter the number of elements you want to store: ");
//reading the number of elements from the that we want to enter
n=sc.nextInt();
//creates an array in the memory of length 10
int[] array = new int[10];
System.out.println("Enter the elements of the array: ");
for(int i=0; i<n; i++)
{
//reading array elements from the user
array[i]=sc.nextInt();
}
System.out.println("Array elements is: ");
for(int i=0; i<n; i++)
{
System.out.print(array[i]+" ");
} System.out.println("\n");
int res=0;
int t;
int k;
for(int i=0; i<n; i++)
{
t=array[i];
while(t>0)
{
k=t%10;
t=t/10;
if(k==0)
{
res=1;
break;
}
}if(res==1)
{System.out.println("False it is not vanilla array");
break;
}
}if(res==0)
{
System.out.println("True it is vanilla array");
}
See more about JAVA at brainly.com/question/12975450
#SPJ1
If $due_date contains a DateTime object for a date that comes 1 month
and 7 days before the date stored in the $current_date variable, what will $overdue_message contain
when this code finishes executing:
a. 0 years, 1 months, and 7 days overdue.
b. -0 years, -1 months, and -7 days overdue.
c. 1 month and 7 days overdue.
d. $overdue_message won’t be set because the if clause won’t be executed
a. 0 years, 1 months, and 7 days overdue.
List questions you would be asking to software developers about the form.
List potential risks if there are any with the form.
Write and test the “digit” function: Function Prototype: int digit(int n,int k) This function returns the kth digit of the positive integer n. For example, if n is the integer 85,419, then the call digit(n,0) would return the digit 8, and the call digit(n,2) would return the digit 4. Examples: 1. Input: n = 25419 , k = 1 output: 5 2. Input: n = 2 , k = 0 output: 2 3. Input: n = 2 , k = 1 output: index out of bound (return -1) Note: • The digits are numbered from left to right beginning with the “zeroth” digit. • Take input and display output in main function. • Do not use array or string etc.
Explanation:
You have to just take a number n and after that you just reverse the number after that when the number is reversed you simply apply mod of 10 at that reversed number and then divide it by 10.
Note:
you have to use while loops when finding reversed number and the place of number to be found
Answer:
fastian broh its call plagrism
Explanation:
Write a program that asks the user for the name of a file. The program should display only the first five lines of the file's contenents if the file contains less than five lines, it should display the files's entire contenents
To write a program that asks the user for the name of a file, we will use the readline() method of our file object, and using a for loop, we'll repeat the readline() five times.
The structure of the program and it's programming:
We will use readline() method of our file object( here it has been taken as file_obj).
Using a for loop we'll repeat the readline() five times.
If the file has less than five lines and we try to keep reading after the read position has gotten to the last character in the file, the readline() function will just return the empty string " ".
So nothing will be displayed. We need set end=' ' in our print() function to ensure that we don't get a bunch of extra new lines.
Don't forget to close the file after you're done with it.
# Getting file name from the user filename = input('Enter the filename :')
# Opening the file in read mode file_obj = open(filename, 'r');
# Reading and displaying the file's first five lines for i in range(5): print(file_obj.readline(), end = '')
# Reads a single line at a time and displays it # Closing the file file_obj.close()
To know more about programming, visit: https://brainly.com/question/16936315
#SPJ1
1. Review and write summary report on Artificial Intelligence (AI), your report should include from starting point of Al to the future of AI in brief and short way.
Summary report on Artificial Intelligence (AI):
The term artificial intelligence broadly refers to the application of technology to perform tasks that resemble human cognitive functioning, and is typically defined as "the ability of a machine to imitate intelligent human behaviour." Artificial intelligence typically involves "the theory and development of artificial intelligence systems capable of performing tasks that normally require human intelligence, such as visual perception, speech recognition, decision making, and between languages." John McCarthy, one of the founders of the study of artificial intelligence, "defined the field of using computers to do things that are said to be intelligent when people do them."
Artificial intelligence is used as an umbrella term to cover a wide range of different technologies and applications, some of which are mentioned below.
Machine Learning (ML) Natural Language Processing (NLP) Computer vision (CV) Robotics Process Automation (RPA)AI applications typically involve the use of data, algorithms and human feedback. Ensuring that all these components are properly structured and validated is essential to developing and deploying AI applications.
What is Machine Learning ?Machine learning is a branch of computer science that uses algorithms to process and learn from large amounts of data. Unlike traditional rule-based programming, ML models10 learn from input data to predict or identify meaningful patterns without being specifically programmed to do so. There are different types of ML models depending on their intended task and structure:
Supervised Machine Learning: In supervised ML, a model is trained with labeled input data that correlates with a specified output. Reinforcement learning: In reinforcement learning, the model learns. dynamically to achieve the desired output through trial and error Unsupervised Machine Learning: In unsupervised ML, the input data is unlabelled and the output is undefined Deep Learning: A deep learning model is built on an artificial neural network where algorithms process large amounts of unlabelled or unstructured data through multiple learning layers in a way inspired by how neural networks work in the brainTo learn more about machine learning, visit;
https://brainly.com/question/29386217
#SPJ9
Below you can see stringSize, which is implemented in Java
Write an expression using Boolean operators that prints "Special number" if special_num is -99, 0, or 44.
A sample expression that uses Boolean operators that prints "Special number" if special_num is -99, 0, or 44 is given below:
The Programimport java.util.Scanner;
import java.io.*;
public class Test
{
public static void main(String[]args) throws IOException
{
File file = new File("SNUMS.INP");
Scanner inputFile = new Scanner(file);
int order = 1;
int i = 1;
int[] special = new int[1000000+1];
// Write all 10^6 special numbers into an array named "special"
while (order <= 1000000)
{
if (specialNumber(i) == true)
{
special[order] = i;
order++;
}
i++;
}
// Write the result to file
PrintWriter outputFile = new PrintWriter("SNUMS.OUT");
outputFile.println(special[inputFile.nextInt()]);
while (inputFile.hasNext())
outputFile.println(special[inputFile.nextInt()]);
outputFile.close();
}
public static boolean specialNumber(int i)
{
// This method check whether the number is a special number
boolean specialNumber = false;
byte count=0;
long sum=0;
while (i != 0)
{
sum = sum + (i % 10);
count++;
i = i / 10;
}
if (sum % count == 0) return true;
else return false;
}
}
Read more about boolean operators here:
https://brainly.com/question/5029736
#SPJ1
What is the vibrating or buzzing of a hand controller known as?
The vibrating or buzzing of a hand controller is known as haptic feedback.
What is haptic feedback?
The use of touch to communicate with users is known as haptic feedback. Most people are familiar with the sensation of a vibration in a phone or the rumble in a game controller, but haptic feedback is much more.
Humans have five senses, but electronic devices communicate with us primarily through two: sight and hearing.
Haptic feedback (also known as simply haptics) alters this by simulating the sense of touch. You can not only touch a computer or other device, but the computer can also touch you.
To know more about Haptic feedback, visit: https://brainly.com/question/14868645
#SPJ1
(دانا
Physical appearance
OF Fith generation
computer
The physical appearance of the fifth-generation computers is VLSI architecture, parallel processing such as data flow control, and logic programming.
What are the generations of computers?The phrase “generation” refers to a shift in the technology that a computer is/was using. The term “generation” was initially used to describe different hardware advancements.
These days, a computer system's generation involves both hardware and software. 5 Fifth Generation: The period of the fifth generation: 1980-onwards. ULSI microprocessor based.
Thus, fifth-generation computers have knowledge based on a relational database and applied artificial intelligence and pattern processing.
To learn more about Fifth generation computers, refer to the link:
https://brainly.com/question/9354047
#SPJ1
this is for a SQL server class:
Database level permissions apply to a specific database. Assigning permissions at this level is inefficient when dealing with ____
a. users with no permissions
b. large user groups
c. all of the above
Assigning permissions at this level is inefficient when dealing with large user groups. The correct option is b.
What is database-level permission?Permissions are the many sorts of access that are granted to specific securable. At the server level, permissions are assigned to SQL Server logins and server roles. At the database level, they are assigned to database users and database roles.
Read, write, and execute are the three types of permissions that files and directories can have. Anyone with reading permission can view the contents of a file or directory.
Therefore, the correct option is b. large user groups.
To learn more about database-level permission, refer to the link:
https://brainly.com/question/13108159
#SPJ1
How do I get this thing in the right order, including the indentation?
Answer:
Explanation:
weird
MYSQL
I need a query code I am confused with two questions
Display each classification that has a total of more than 70 parts on hand. List the classification and the total on hand as ‘More than 70’
What is the average quoted price, maximum quoted price, and minimum quoted price of all orders? Display the average as ‘Average Quoted Price’, maximum quoted price as ‘Maximum Quoted Price’, and minimum quoted price as ‘Minimum Quoted Price’. Extra decimal places are okay for now. Insert your snip of the query and resultset together here:
Using the knowledge in computational language in MYSQL it is possible to write a code that Display each classification that has a total of more than 70 parts on hand. List the classification and the total on hand as ‘More than 70’.
Writting the code:CREATE TABLE shop (
price DECIMAL(16,2) DEFAULT '0.00' NOT NULL,
PRIMARY KEY(article, dealer));
INSERT INTO shop VALUES
(1,'A',3.45),(1,'B',3.99),(2,'A',10.99),(3,'B',1.45),
(3,'C',1.69),(3,'D',1.25),(4,'D',19.95);
See more about MYSQL at brainly.com/question/20626226
#SPJ1
1. Keep the flyer to one page.
2. Be sure the flyer is easy to read and has an attractive design
3. Be sure to provide all information on the flyer as indicated on page 168
4. Use a SmartArt graphic
5. Use a bulleted list
6. Use a picture graphic
7. Choose a color scheme
8. Be creative!
To quickly and easily create a visual representation of your knowledge, create a SmartArt graphic. You can select from a variety of layouts to clearly convey your message or ideas.
Make a brand-new SmartArt image.To quickly and easily create a visual representation of your knowledge, create a SmartArt graphic. You can select from a variety of layouts to clearly convey your message or ideas. Excel, Outlook, PowerPoint, and Word all support the creation and use of SmartArt visuals.
See Choose a SmartArt graphic for an overview of SmartArt graphics, including tips for selecting the right visual and layout style to present your data or illustrate a point.
Notes:
Click the arrow control next to the SmartArt graphic to reveal the Text pane if it is not already there.On the Place tab, in the Text group, select Text Box to insert a text box so that you can add text, such as a title, anywhere near or on top of your SmartArt design. Right-click your text box, select Format Shape or Format Text Box, and then choose to make the text box's background and border transparent if you only want the text inside it to show up.To learn more about SmartArt refer to
https://brainly.com/question/4911152
#SPJ1
Name two ways to store data
Answer:
Hard drives and solid-state drives
Explanation:
These statements describe saving presentations.
Name your file in a way enables you to find it later.
Click on an icon to save.
It is a good idea to save often.
Select the Save option in the File menu to save.
Save by selecting the Save option in the Tools menu.
Saving once is enough.
[ DO NOT REPLY FOR POINTS YOU WILL BE REPORTED ]
(multiple choice) (edgenuitу)
Answer: answer 4 and 5
Explanation:
to save something on a device option 4 and 5 is the best fit for this
Many documents use a specific format for a person's name. Write a program that reads a person's name in the following format:
firstName middleName lastName (in one line)
and outputs the person's name in the following format:
lastName, firstInitial.middleInitial.
Ex: If the input is:
Using the knowledge in computational language in JAVA it is possible to write the code that write a program whose input is: firstName middleName lastName, and whose output is: lastName, firstName middleInitial.
Writting the code:import java.util.Scanner;
import java.lang.*;
public class LabProgram{
public static void main(String[] args) {
String name;
String lastName="";
String firstName="";
char firstInitial=' ',middleInitial=' ';
int counter = 0;
Scanner input = new Scanner(System.in);
name = input.nextLine(); //read full name with spaces
int i;
for(i = name.length()-1;i>=0;i--){
if(name.charAt(i)==' '){
lastName = name.substring(i+1,name.length()); // find last name
break;
}
}
for(i = 0;i<name.length()-1;i++){
if(name.charAt(i)==' '){
firstName = name.substring(0, i); // find firstName
break;
}
}
for(i = 0 ;i<name.length();i++){
if(name.charAt(i)==' '){
counter++; //count entered names(first,middle,last or first last only)
}
}
if(counter == 2){
for(i = 0 ;i<name.length();i++){
if(Character.toUpperCase(name.charAt(i)) == ' '){
middleInitial = Character.toUpperCase(name.charAt(i+1));//find the middle name initial character
break;
}
}
}
firstInitial = Character.toUpperCase(name.charAt(0)); //the first name initial character
if(counter == 2){
System.out.print(lastName+", "+firstName+" "+middleInitial+".");
}else{
System.out.print(lastName+", "+firstName);
}
}
}
See more about JAVA at brainly.com/question/12975450
#SPJ1
Account A can retrieve or modify any relation except DEPENDENT and can grant any of these privileges to other users. (b) Account B can retrieve all the attributes of EMPLOYEE and DEPARTMENT except for SALARY, MGRSSN, and MGRSTARTDATE. (c) Account C can retrieve or modify WORKS_ON but can only retrieve the FNAME, MINIT, LNAME, SSN attributes of EMPLOYEE and the PNAME, PNUMBER attributes of PROJECT. (d) Account D can retrieve any attribute of EMPLOYEE or DEPENDENT and can modify DEPENDENT. (e) Account E can retrieve any attribute of EMPLOYEE but only for EMPLOYEE tuples that have DNO = 3. (f) Write SQL statements to grant these privileges. Use views were appropriate
The SQL statements to grant these privileges are as follows:
GRANT SELECT, UPDATEON EMPLOYEE, DEPARTMENT, DEPT_LOCATIONS, PROJECT,
WORKS_ON
TO ACCOUNTA
WITH GRANT OPTION;
CREATE VIEW EMPS ASSELECT FNAME, MINIT, LNAME, SSN, BDATE, ADDRESS, SEX
SUPERSSN, DNO
FROM EMPLOYEE;
GRANT SELECT ON EMPS
TO ACCOUNTB;
CREATE VIEW DEPTS AS
SELECT DNAME, DNUMBER
FROM DEPARTMENT;
GRANT SELECT ON DEPTS
TO ACCOUNTB;
GRANT SELECT, UPDATEON WORKS_ON
TO ACCOUNTC;
CREATE VIEW EMP1 AS
SELECT FNAME, MINIT, LNAME, SSN
FROM EMPLOYEE;
GRANT SELECT ON EMP1
TO ACCOUNTC;
CREATE VIEW PROJ1 AS
SELECT PNAME, PNUMBER
FROM PROJECT;
GRANT SELECT ON PROJ1
TO ACCOUNTC;
GRANT SELECT ON EMPLOYEE, DEPENDENTTO ACCOUNTD;
GRANT UPDATE ON DEPENDENT
TO ACCOUNTD;
CREATE VIEW DNO3_EMPLOYEES ASSELECT * FROM EMPLOYEE
WHERE DNO = 3;
GRANT SELECT ON DNO3_EMPLOYEES
TO ACCOUNTE;
What do you mean by SQL statement?SQL statement may be defined as a domain-specific language that is significantly utilized in programming and designed for controlling data held in a relational database management system. SQL stands for Structured Query Language.
Therefore, the SQL statements to grant these privileges are well described above.
To learn more about SQL statements, refer to the link:
https://brainly.com/question/14312429
#SPJ1
this is my data cancer['level_description'].head(10).plot.pie()
and the error says TypeError: '<' not supported between instances of 'str' and 'int'
Only items with the same numerical data type can be compared using mathematical operators. If you try to compare a string and an integer, you will get an error saying "not supported between instances of'str' and 'int'."
What is typeerror: '>' not supported between'str' and 'int' instances?Comparison operators cannot be used to compare strings and integers. This is due to the fact that strings and integers are different data types.Python is a programming language that is statically typed. If you need to compare a value of one type to another, you must manually change the type of the data.Let's say you want to convert a string to an integer. Before the comparison can take place, you must manually convert the string to an integer.When you try to perform a "greater than" comparison on a string and an integer, you get the "typeerror: '>' not supported between instances of'str' and 'int'" error.This error can occur with any comparison operation, including less than (), equal to (=), and greater than or equal to (>=).The string returned by the input() method. This means that our code attempts to compare a string to an integer (the value in "numerical grade").We solve this issue by converting "numerical grade" to an integer before performing any code comparisons:To learn more about 'str' and 'int' refer to:https://brainly.com/question/26352522
#SPJ1
