The task that would be best completed by using the Find Unmatched Queries Wizard for two tables named “Products Offered” and “Customers” is option b: finding customers who have bought more than one of the same product.
What does mismatched query wizard mean?You can build a query using this wizard that reports any orphaned or widowed records between two Microsoft Access tables. When there is no corresponding record in the one-side (parent or primary) table, a record in the many-side (child or related) table relationship is said to be orphaned.
Therefore, In the Queries group on the Create tab, select Query Wizard. Double-click Find Unmatched Query Wizard in the New Query dialog box. Select the table with the mismatched records on the wizard's first page, and then click Next.
Learn more about Customers from
https://brainly.com/question/380037
#SPJ1
Write a query to display the book number, title, and number of times each book has been checked out. Limit the results to books that have been checked out more than 5 times. Sort the results in descending order by the number of times checked out, and then by title. (Figure P8.57)
Chapter 8 problem 57. Problem taken from Database Systems: Design, Implementation, and Management, 12th edition, by Carlos Coronel and Steven Morris
The query to display the book number, title, and number of times each book has been checked out is Choose "Book Title," "Book Cost," and "Book Year From Book Order";.
A search for information or a question is what a query is. The phrases inquiry, question, quest, request, and query all derive from the Latin verb quaere, which meaning "to ask." When discussing Internet searches, courteous professional conversation, and delicate requests, the word "query" typically fits the bill.
A query might ask your database for data results, a specific action to be taken with the data, or both. A query can add, change, or remove data from a database, perform calculations, combine data from various tables, and answer simple questions.
To know more about database click here:
https://brainly.com/question/29412324
#SPJ4
what two technologies below are fully-implemented, 64-bit processors for use in servers and workstations? (select all that apply)
Answer:
Itanium & Xeon
Explanation:
consider the network shown in the exhibit. when you run the show interfaces command on switch1, you observe a significant number of runts on the gi0/1 interface. what does this statistic indicate?
There are collisions happening. The arp software will display all hosts on your network segment's resolved MAC to IP addresses.
The standard that enables high-bandwidth data transfer over the current cable TV infrastructure is called DOCSIS, which stands for Data Over Cable Service Interface Specification. It is essentially the technology that gives you cable internet. To find the route between two connections, use the traceroute command. A connection to another device frequently needs to pass via several routers. The names or IP addresses of each router that exists between two devices will be returned by the traceroute command.
Learn more about addresses here-
https://brainly.com/question/29065228
#SPJ4
In Java Script CodeHS, 4.2.5 " Text Message", what is the Message.java answer?
When developing web pages, applications, servers, or even games, web developers frequently use JavaScript, a lightweight programming language, to create more dynamic interactions.
Code
public class TMessage
{
private String message;
private String sender;
private String receiver;
public TMessage(String from, String to, String TheMessage)
{
sender = from;
receiver = to;
message = TheMessage;
}
public String toString()
{
return sender + " texted " + receiver + ": " + message;
}
}
To know more about Java script, check out:
https://brainly.com/question/16698901
#SPJ1
which method would be appropriate for compressing data, when the nature of that data is unknown (by a modem at the physical layer, for example)?
A method which would be appropriate for compressing data, when the nature of that data is unknown (by a modem at the physical layer, for example) is: D. run length encoding.
What is a lossy compression?In Computer technology, a lossy compression is sometimes referred to as irreversible compression and it can be defined as a type of data encoding (data compression algorithm) in which the data in a file is removed by using inexact approximations, in order to reduce the amount of size of a file after decompression.
What is RLE?In Computer technology, RLE is an abbreviation for run length encoding and it can be defined as a type of lossless compression technique in which all of the sequences that are used for displaying redundant data are stored as a single data value.
In this context, we can reasonably infer and logically deduce that run length encoding (RLE) would be most appropriate in this scenario.
Read more on lossy compression here: https://brainly.com/question/17542014
#SPJ1
Complete Question:
Which method would be appropriate for compressing data, when the nature of that data is unknown (by a modem at the physical layer, for example)? O JPEG O MP3 O MPEG-4 O run length encoding
Law enforcement officials sent a company a notification that states electronically stored information and paper documents cannot be destroyed. Which of the following explains this process? A. Data breach notification B. Accountability C. Legal hold D. Chain of custodyPrevious question
The one that explains this process is legal to hold. The correct option is C.
What is a legal hold?Receiving a demand letter, filing a formal complaint, receiving a records subpoena, or experiencing an event that frequently leads to litigation are examples of situations that call for the preservation of evidence.
It may also be referred to as a "hold order," a "preservation order," or a "legal hold." It is a temporary suspension of an organization's electronic or paper document destruction procedures with regard to any documents that may be pertinent to a new or upcoming legal case, issued by the company's legal department.
Therefore, the correct option is C. Legal hold.
To learn more about the legal hold, refer to the link:
https://brainly.com/question/11040725
#SPJ1
you have a small network with three subnets, as shown in the exhibit. ip addresses for each router interface are also indicated in the exhibit. how many ip addresses that you can assign to hosts remain on each subnet?
Subnet A =125, subnetB=0,Subnet C= 13 are the three ip addresses that needs to be assigned to the host respectively
What is a subnet?
A subnet, also known as a subnetwork, is a segmented section of a larger network. Subnets are a logical division of an IP network into multiple, smaller network segments. The Internet Protocol (IP) is a protocol used to send data from one computer to another over the internet.
For example:
A subnet is a network subnetwork that is classified as A, B, or C. For example, 172.16.0.0/16 is a class B network. This network is quite large; it begins with 172.16.A class C network would have a subnet mask of 255.255.255.0, indicating that the network uses 24 bits. This is denoted by a /24 after the IP address in CIDR notation.
Hence to conclude for the given condition Subnet A =125, subnetB=0,Subnet C= 13 are the three ip addresses that needs to be assigned to the host respectively
To know more on subnets follow this link:
https://brainly.com/question/28865562
#SPJ4
which of the following are included in r packages? select all that apply. O tests for checking your code O naming conventions for r variable names O sample datasets
O reusable r functions
The option that are included in R- packages are options:
A Tests for checking your code
C Sample datasets
D Reusable R functions
What purposes serve R packages?Extensions to the R statistical programming language are known as packages. Users of R can install R packages, which are standardized collections of code, data, and documentation, typically through a centralized software repository like CRAN (the Comprehensive R Archive Network).
Therefore, in regards to the case above, one can say that Reusable R functions, sample datasets, and tests to validate your code are all included in R packages. The instructions for using the included functions are also included in R packages.
Learn more about R- packages from
https://brainly.com/question/29414342
#SPJ1
Which two statements describe ways that engineers using the engineering design process can benefit from the use of computer models?
a. computer models can aid engineers in presenting and sharing ideas about ways to solve design problems.
b. computer models can eliminate the need to make prototypes by representing every aspect of the real world.
c. computer models can take the place of the engineering design process by predicting the best possible design.
d. computer models can help engineers simulate designs that are too dangerous or expensive to test in real life.
The two statements that describe ways that engineers using the engineering design process can benefit from the use of computer models are options A and C:
a. Computer models can aid engineers in presenting and sharing ideas about ways to solve design problems.
c. Computer models can take the place of the engineering design process by predicting the best possible design.
What advantages do engineers have when employing the design process?A person can come up with innovative solutions to common problems by using the engineering design process. It asks you to consider which strategy is most likely to be effective. The procedure supports making decisions and addressing problems in a novel way.
Therefore, in the case above, The first step in the engineering design process is problem definition and background investigation. A solution is selected after defining the requirements. The solution is tested after a prototype is constructed. Results can be shared if the solution constructed satisfies the conditions. Thus the two options selected are correct.
Learn more about computer models from
https://brainly.com/question/22946942
#SPJ1
Answer:
Actually its A and D
Explanation:
Complete the Team class implementation. For the instance method get_win_percentage(), the formula is:
wins / (wins + losses). Note: Use floating-point division.
For instance method print_standing(), output the win percentage of the team with two digits after the decimal point and whether the team has a winning or losing average. A team has a winning average if the win percentage is 0.5 or greater.
Ex: If the input is:
Ravens
13
3 where Ravens is the team's name, 13 is the number of team wins, and 3 is the number of team losses, the output is:
Win percentage: 0.81
Congratulations, Team Ravens has a winning average!
Ex: If the input is:
Angels
80
82
the output is:
Win percentage: 0.49
Team Angels has a losing average.
The complete implementation for the instance method is given as:
class Team:
def __init__(self):
self.team_name = 'none'
self.team_wins = 0
self.team_losses = 0
# TODO: Define
def get_win_percentage(self):
return self.team_wins / (self.team_wins + self.team_losses)
if __name__ == "__main__":
team = Team()
team_name = input()
team_wins = int(input())
team_losses = int(input())
team.team_name=team_name
team.team_wins=team_wins
team.team_losses=team_losses
if team.get_win_percentage() >= 0.5:
print('Congratulations, Team', team.team_name,'has a winning average!')
else:
print('Team', team.team_name, 'has a losing average.')
Note that
def get_win_percentage(self):
The above defines the function
While
return self.team_wins / (self.team_wins + self.team_losses)
This calculates the win percentage and returns it to the main.
What is a function?A function is essentially a "chunk" of code that you may reuse instead of writing it out several times. Programmers can use functions to break down or breakdown an issue into smaller segments, each of which performs a specific purpose.
Instance methods are methods that require the creation of an object of the class before they may be invoked. To call an instance method, we must first construct an Object of the class that defines the method.
Learn more about the instance method:
https://brainly.com/question/14710147
#SPJ1
Selected molecular descriptors from the Dragon chemoinformatics application were used to predict bioconcentration factors for 779 chemicals in order to evaluate QSAR (Quantitative Structure Activity Relationship). This dataset was obtained from the UCI machine learning repository.
The dataset consists of 779 observations of 10 attributes. Below is a brief description of each feature and the response variable (logBCF) in our dataset:
nHM - number of heavy atoms (integer)
piPC09 - molecular multiple path count (numeric)
PCD - difference between multiple path count and path count (numeric)
X2Av - average valence connectivity (numeric)
MLOGP - Moriguchi octanol-water partition coefficient (numeric)
ON1V - overall modified Zagreb index by valence vertex degrees (numeric)
N.072 - Frequency of RCO-N< / >N-X=X fragments (integer)
B02[C-N] - Presence/Absence of C-N atom pairs (binary)
F04[C-O] - Frequency of C-O atom pairs (integer)
logBCF - Bioconcentration Factor in log units (numeric)
Note that all predictors with the exception of B02[C-N] are quantitative. For the purpose of this assignment, DO NOT CONVERT B02[C-N] to factor. Leave the data in its original format - numeric in R.
Please load the dataset "Bio_pred" and then split the dataset into a train and test set in a 80:20 ratio. Use the training set to build the models in Questions 1-6. Use the test set to help evaluate model performance in Question 7. Please make sure that you are using R version 3.6.X or above (i.e. version 4.X is also acceptable).
The coding solution for the given problem is provided below, in which we must select molecular descriptors from the Dragon chemoinformatics application to predict bioconcentration factors for 779 chemicals in order to evaluate QSAR (Quantitative Structure Activity Relationship).
Coding Part:
# Clear variables in memory
rm(list=ls())
# Import the libraries
library(CombMSC)
library(boot)
library(leaps)
library(MASS)
library(glmnet)
# Ensure that the sampling type is correct
RNGkind(sample.kind="Rejection")
# Set a seed for reproducibility
set.seed(100)
# Read data
fullData = read.csv("~/Documents/ISYE6414/Bio_pred.csv",header=TRUE)
# Split data for traIning and testing
testRows = sample(nrow(fullData),0.2*nrow(fullData))
testData = fullData[testRows, ]
trainData = fullData[-testRows, ]
To know more about variables in memory, visit: https://brainly.com/question/29358320
#SPJ4
it staff looks to provide a high level of fault tolerance while implementing a new server. with which systems configuration approach does the staff achieve this goal
The redundant component for the recovery of the system is called elasticity, which has the capacity of the system to use any alteration in the demand for media in real time, It also applies processing and storage power.
Fault toleranceIs to ensure business continuity and high availability by avoiding outages that arise from a single point of failure. The goal of fault-tolerant computing systems is to ensure business persistence and high availability by preventing downtime arising from a single point of failure.
For more about fault tolerance here https://brainly.com/question/26486347
#SPJ4
Algorithm Workbench 1. Write the first line of the definition for a Poodle class. The class should extend the Dog class. 2. Look at the following code, which is the first line of a class definition: public class Tiger extends Felis In what order will the class constructors execute? 3. Write the statement that calls a superclass constructor and passes the arguments x, y, and z.
The first line of the definition for a Poodle class is public class Poodle extends Dog{ //Describe the class's characteristics and behavior}.
In the main method when the constructor of the Tiger class is called, it will pass the call to its superclass Felis. As a result, the Felis constructor is called first, followed by the Tiger constructor.
What is Poddle class?Poddle class may be defined as a type of intelligent dog with a heavy curly solid-colored coat that is usually clipped. In more simple words, it is an old breed sometimes trained as sporting dogs or as performing dogs.
The statement that calls a superclass constructor and passes the arguments x, y, and z are as follows:
//demo class
public class B extends A{
public B(int x1, int y1, int z1){ //considering that there are types such as int
super(x1, y1, z1);//passing the values to the constructor of the superclass
} }
We can employ this superclass method by using the super keyword:
super.setValue(10);
To learn more about Constructor, refer to the link:
https://brainly.com/question/13267121
#SPJ1
Emily is deciding between two cameras. One has a 25-megapixel rating, and the other has a 10-megapixel rating. What is the main difference between the two cameras?
Responses
The 25-megapixel camera has higher image resolution than the 10-megapixel camera.The 25-megapixel camera has higher image resolution than the 10-megapixel camera. , ,
The 10-megapixel camera has a greater depth of field than the 25-megapixel camera.
The 10-megapixel camera has a greater depth of field than the 25-megapixel camera.,
The 10-megapixel camera has a higher shutter speed than the 25-megapixel camera.
The 10-megapixel camera has a higher shutter speed than the 25-megapixel camera.,
The 25-megapixel camera has a larger maximum aperture than the 10-megapixel camera.
Answer:
D
Explanation:
The 25-megapixel camera has higher image resolution than the 10-megapixel camera.
in preparation to use your notebook on the airplane as you travel to a conference, you disconnected the external usb mouse. the cursor drifts consistently to the left side of the screen while using the built-in trackpad and mouse buttons on the notebook. which of the following actions would most likely stop the mouse from drifting? answer buy a new external mouse. update the trackpad drivers. enable airplane mode. disable the trackpad in the control panel.
Access the BIOS/UEFI configuration and disable the USB pointer option.
What is BIOS?
The term "BIOS" stands for "basic input-output system." It is low-level software that is housed in a chip on the motherboard of your computer. When your computer turns on, the BIOS loads and is in charge of waking up the hardware components, checking that they are operating properly before launching the bootloader, which boots Windows or any other operating system you may have installed.
What is the difference between UEFI and BIOS?
Drive sizes up to 9 zettabytes are supported by UEFI, compared to just 2.2 terabytes by BIOS. A quicker boot time is offered by UEFI. While BIOS has drive support stored in its ROM, UEFI has discrete driver support. As a result, updating BIOS firmware can be challenging.
What is mean by a configuration?
A configuration is typically the arrangement of the parts that make up a whole, or the process of doing so.
To know more about UEFI and BIOS, check out:
https://brainly.com/question/28485802
#SPJ1
Disable the USB pointer setting in the BIOS/UEFI configuration.
What is configuration?
The definition of configuration in the context of computers and technology is the organisation of the IT system's hardware and software. You have more control so over devices in your network thanks to management of a components, settings, and other factors that guarantee smooth operation of all IT systems. Two of the main issues surrounding the requirement for a configured properly technology infrastructure are function and performance. Along with the security and safety of your company's data, reliability is a factor. Devices that are initially configured correctly can spare you trouble in future technology audits.
To learn more about configuration
https://brainly.com/question/29415808
#SPJ1
a newly created company has fifteen windows 10 computers that need to be installed before the company can open for business. what is a best practice that the technician should implement when configuring the windows firewall?
The technician should confirm that the Windows Firewall is turned off after installing third-party security software for the enterprise.
What function does Windows Firewall serve?A layered security strategy includes Windows Firewall with Advanced Security, which is crucial. Windows Defender Firewall prevents illegal network traffic from entering or leaving a local device by offering host-based, two-way network traffic filtering for that device.You receive a firewall utility that is pre-installed in Microsoft Windows 8 and 10. It might, however, be disabled by default. Since it is a crucial security function for safeguarding your system, you should always make sure that it is activated.There is hardly ever a cause to deploy a standalone personal firewall in the modern world.To learn more about Windows Firewall refer to:
https://brainly.com/question/10431064
#SPJ1
write a while loop to read integers from input until -1 is read. for each integer read before -1, add the integer minus four to vector input integers.
Using a for loop, count both positive and negative numbers from a specified list. Use a for loop to iterate each member in the list, then check to see if the positive number test is true by seeing if num >= 0.
Increase the positive count if the condition is true; else, increase the negative count.
# Python program to count positive and negative numbers in a List
# list of numbers
list1 = [10, -21, 4, -45, 66, -93, 1]
pos_count, neg_count = 0, 0
# iterating each number in list
for num in list1:
# checking condition
if num >= 0:
pos_count += 1
else:
neg_count += 1
print("Positive numbers in the list: ", pos_count)
print("Negative numbers in the list: ", neg_count)
Learn more about program here-
https://brainly.com/question/14618533
#SPJ4
what transition documentation component is meant to assist local service providers in surmounting developing challenges?
Note that the transition documentation component is meant to assist local service providers in surmounting developing challenges is "expected future problems"
What is Transition Documentation?A transition plan details your present tasks and responsibilities to teach your successor how to execute your work properly and to assist you to move out of your position seamlessly.
A transition plan outlines your usual activities and responsibilities, as well as current projects, forthcoming deadlines, and essential contacts.
The goal of transition evaluations is to advise young people and their families about what to expect in the future so that they can prepare for adulthood. Transition evaluations should take place at the appropriate moment for the young person or caregiver to reach their goal.
Learn more about Transition Documentation:
https://brainly.com/question/1862731
#SPJ1
What steps would you take if you wanted to adjust the outline style of a rectangle shape that has already been inserted into your worksheet?.
The steps to take if you wanted to adjust the outline style :
1) Click the shape.
2) Click (Drawing Tools) Format.
3) In the Shape Styles group,
4) select a different outline.
What is meant by outline style ?The style of an element's outline can be changed using the outline-style property. A line that is drawn outside of an element's borders to make it stand out on the page is known as an outline. It can be used for decoration but is typically utilised for accessibility concerns.
The element is surrounded by a single line. Double: Places a space between two parallel, solid lines that are drawn along the edge of the element. The outline-width value is equal to the thickness of the two lines and the distance between them. For the double outline to be visible, the outline-width must be at least 3 pixels wide.
To learn more about outline style refer to :
https://brainly.com/question/11496451
#SPJ4
59 which element of the cultural web represents the dress code, logos, and furnishings of an entity?
Answer:
Symbols
Explanation:
what basic database design strategies exist? describe top down and bottom up, centralized and decentralized design). explain how such strategies executed? and what are the consideration to know which strategy to choose?
Top-down and bottom-up are the two main methods used in database design.
Define the term database design.
Data organizing using a database model is known as database design. The designer decides what information must be kept on file and how the data elements interact. Now that they have this knowledge, they can start to match the data to the database model.
The data is managed in accordance with a database management system. Tables, indexes, views, constraints, triggers, stored procedures, and other database-specific components required to store, retrieve, and remove persistent objects must all be included in the thorough database architecture defined by the database designer.
Answer continued:
The first step in top-down design is to define each entity type's attributes and to identify the many entity types that exist. In other words, top-down design first defines the necessary data sets, and only then does it describe the data items for each of those data sets.
Bottom-up design first identifies the necessary properties, then groups them to create entities.
When the system's data component contains a sizable number of entities and intricate relationships on which highly sophisticated actions are carried out, centralized architecture may be applied.
The database design task is broken down into a number of modules inside the decentralized design framework. Following the establishment of the design requirements, the lead designer distributes design subsets or modules to design groups within the team.
To learn more about database design, use the link given
https://brainly.com/question/7145295
#SPJ4
What is the output of this program? Assume the user enters 3, 6, and 11.
numA = 0
for count in range(3):
answer = input ("Enter a number: ")
fltAnswer = float(answer)
numA = numA + fltAnswer
print (numA)
Output:
Answer:
Output: 23.0
Explanation:
1) numA += 3; (3)
2) numA += 9 (12) #3 + 9 = 12
3) numA += 11 (23) #12 + 11 = 23
float(23) = 23.0
Answer: 20
Explanation:
it is a basic python code
fitAnswer intoduses loop into the given variable
==> intial A=[0]
after addind 3
A=[0,3]=0+3=3
A=[0,3,6]=0+3+6=9
A=[0,3,6,11]=0+3+6+11=20
Which of the following is a personal security safeguard?
A) sending valuable data only via email or IM
B) using single password for all the sites
C) removing high-value assets from computers
D) storing browsing history, temporary files, and cookies
The personal security safeguard is s removing high-value assets from computers. The correct option is C.
What is a personal security safeguard?Prescribed safeguards and controls to meet the security needs of an information system. Security features, management limitations, human security, physical structure, area, and device security are all examples of safeguards.
For extremely sensitive personal health information, encrypted storage and transfer are required.
Therefore, the correct option is C) removing high-value assets from computers.
To learn more about personal security safeguards, refer to the link:
https://brainly.com/question/24924687
#SPJ1
which term describes a field in the ipv4 packet header that contains an 8-bit binary value used to determine the priority of each packet?
Differentiated services describes a field in the ipv4 packet header that contains an 8-bit binary value used to determine the priority of each packet.
What is ipv4 packet?Application data, including usage and source/destination addresses, is contained in an Internet Protocol version 4 (IPv4) packet header. 20 bytes of data make up an IPv4 packet header, which is typically 32 bits long.
A packet is a network communication data unit with fixed or variable lengths. The header, body, and trailer are the three parts that make up a single packet.
A 20-byte header contains almost 13 multipurpose fields that each hold a specific piece of related object information, such as the application, data type, and source and destination addresses. The following are thorough descriptions of each header field:
Version: This only uses four packet header bits and contains the Internet header format.Internet header length (IHL): Information about IP header length is kept in this 32-bit field.Service type (ToS): This lists the network service parameters.Datagram size: This has combined data and header length.Learn more about IPv4 packet
https://brainly.com/question/29316957
#SPJ4
i. weak passwords ii. inappropriate use of the internet iii. inappropriate use of e-mail iv. divulging confidential information the above items typically constitute employee security violations.
Weak passwords, inappropriate use of the internet, inappropriate use of e-mail, and divulging confidential information, these mention items typically constitute employee security policy violations.
Violation of employee policies can cause harm to the employees themselves. Losses obtained include misuse of employee personal data. The company should be responsible for maintaining the personal data of its employees. As for employees, you should not give the password regarding your personal account to other people, including the company. A policy violation occur when a user records an expense with details violating the company's policies.
Learn more about policy violations, here https://brainly.com/question/11566483
#SPJ4
to find a value in an ordered array of 200 items, how many values must binary search examine at most?
Answer:
8
Explanation:
Jerry has a problem with a package he just received—two items from his order are missing. Who should he contact to resolve the problem?.
Jerry can contact customer service repsentative in the delivery service that he used. Customer service will help to solve your problem.
Customer service refers to the assistance and advice provided by a company to those people who buy or use its products or services. Customer service has jobdesc to help and handle the complain the customer that used a company product. If you have problem with the package, service or product of company, you can complain it, and the customer service will help you to solve it. It's free as far as the problem of the product is caused by damage of delivery service. You're able to respond quickly and effectively, resulting in a positive customer experience.
Learn more about Customer service, here https://brainly.com/question/13540066
#SPJ4
diagnostic procedures (e.g., uroflowmetry) that are performed to study urine storage and voiding functions are assigned a code from which subcategory of the bladder category in the urinary system subsection of surgery?
The code would come from the subcategory of 'Cystometry and Urodynamic Studies' in the Bladder category of the Urinary System subsection of Surgery.
Which subcategory of the bladder category in the urinary system subsection of surgery?Uroflowmetry is a diagnostic procedure used to study urine storage and voiding functions. It is used to measure the volume and flow rate of urine passed during voiding. This procedure is typically used to diagnose and monitor conditions such as:
Urinary tract infectionsBladder outlet obstructionOveractive bladderUroflowmetry falls under the subcategory of 'Cystometry and Urodynamic Studies' in the Bladder category of the Urinary System subsection of Surgery. This subcategory is used to code procedures that evaluate the bladder's ability to store and evacuate urine. Other procedures in this category include:
Cystometric studies Urethral pressure profilometryUrethral sphincter electromyographyLearn more about Programming: brainly.com/question/23275071
#SPJ4
allowing the user to do too much and adding controls that most users haven't seen and won't use is called:
A preview is provided by thoughtful design, which is transparent and simple to understand and enables users to quickly fix their mistakes.
Describe feature creep ?Allowing the user to do too much and adding controls that the majority of users haven't seen and won't utilize is known as feature creepYou can restrict individual records while allowing certain users to view certain fields in a certain object to precisely control data access.Thoughtful design offers a preview, is clear and easy to understand, and allows users to easily correct their errors.Scope creep, often referred to as feature creep, is the process of adding too many features to a product that make it too complex or challenging to use.To learn more about feature creep refer to:
https://brainly.com/question/15220628
#SPJ4
enter your entire script below. do not include statements to drop objects as your script will be executed against a clean schema. you may include select statements in sub queries in your insert statements, but do not include select queries that return records for display. continue to use the purchase 61 and purchase item 61 tables that you created and modified in the previous problems. increase the shippping cost of every purchase from manufacturers in massachusetts ('ma') by 10%. round your calculations to two decimal points. hint: use the in clause. do not use a join
UPDATE purchase61
SET shipping_cost = ROUND(shipping_cost * 1.10, 2)
WHERE manufacturer IN (SELECT manufacturer FROM purchaseitem61 WHERE state = 'MA')
How to update the column?This statement will update the shipping_cost column in the purchase61 table for every purchase where the manufacturer is in the list of manufacturers in Massachusetts, as determined by the subquery. The shipping cost will be increased by 10% by multiplying it by 1.10, and then rounded to two decimal points using the ROUND function.
Note that you should not use a join in this statement, as the IN clause allows you to compare values in the manufacturer column with the results of the subquery without using a join.
This can make the statement more efficient and easier to read.
To Know More About SQL, Check Out
https://brainly.com/question/13068613
#SPJ1