Create a Horse table with the following columns, data types, and constraints:
ID - integer with range 0 to 65 thousand, auto increment, primary key
RegisteredName - variable-length string with max 15 chars, not NULL
Breed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred
Height - number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0
BirthDate - date, must be ≥ Jan 1, 2015
Note: Not all constraints can be tested due to current limitations of MySQL.
Answers
Answer:
see pictures. Brainly doesn't allow SQL code here.
Explanation:
I did not investigate the constraints other than the NOT NULL constraint. This will actually cause the INSERT to fail because the last value has NULL for a RegisteredName.
Related Questions
Execute and explain this program using // in Layman's language. Thank you!
Answers
The explanation of the program using layman's language is:
It wants to find the highest and lowest contributions madeIt wants to discover how many individual contributions were needed to reach the targetThe total amount of contributions collectedThe program wants to test various input data for contributions and how many contributions are needed to reach the goal.What is a Program?This refers to the sequence of instructions in a programming language that executes the instruction given to the computer.
Hence, we can see that different input sizes would be used to test the program as it is in the testing stage to see just how efficient the program is.
Read more about programs here:
https://brainly.com/question/1538272
#SPJ1
List and describe the five moral dimensions that are involved in political, social, and ethical issues. Which do you think will be the most difficult for society to deal with? Support your opinion.
Answers
The five moral dimensions are:
Information rights and obligations.Property rights and obligationsSystem quality.Quality of life, Accountability and control.I see that Quality of life is most difficult for society to deal with as there ae lots of rich and poor people and the government have not been able to bridge the gap between them.
What are the morals about?The five main moral dimensions that are known to be written above are said to be tied together in regards to ethical, social, and political issues that are seen in any information society.
Therefore, The five moral dimensions are:
Information rights and obligations.Property rights and obligationsSystem quality.Quality of life, Accountability and control.Learn more about moral dimensions from
https://brainly.com/question/15130761
#SPJ1
How would you describe data communication system vis a vis computer networking.
Answers
Data communications is known to be the movement of digital data between two or a lot of computers while computer networking is known to be a form of telecommunications network that gives room for computers to be able to exchange data.
What is the difference between communication system and network?Data Communication is one that works in the area of communicating process and it entails all the different areas and through a lot of process but Computer Networking is one that moves information and allow file movement across different localities to pass data.
Therefore, Data communications is known to be the movement of digital data between two or a lot of computers while computer networking is known to be a form of telecommunications network that gives room for computers to be able to exchange data.
Learn more about Data communications from
https://brainly.com/question/14657016
#SPJ1
Data frames can be subset by a chosen value using ==.
Ex: df[df.x == 5] gives all the rows in the data frame df for which the column x has a value of 5.
Write a program that performs the following tasks:
Load the file mtcars.csv into a data frame called df
Create a new data frame df_cyl by subsetting the data frame based on a user defined value for the column cyl.
Print the shape of the new data frame.
Answers
Using python knowledge and writing code importing pandas, it is possible to create a function that corresponds to what you want.
Writting in python:import pandas as pd
if __name__ == "__main__":
df=pd.read_csv('mtcars.csv')
cylinders=int(input())
print(df[df.cyl==cylinders].shape)
See more about python at brainly.com/question/18502436
#SPJ1
Data elements in a relational database are organized into ____
Answers
Data elements in a relational database are organized into _Tables_
Hope it helps!
Write an if-else statement for the following: If user_tickets is less than 5, assign num_tickets with 1. Else, assign num_tickets with user_tickets. Sample output with input: 3 Value of num_tickets: 1
Answers
The if-else statement as based on python 3.8 is given below
if user_tickets < 5:
num_tickets = 1
else:
num_tickets = user_tickets
Note that if this code is to work properly, a person need to first declare user_tickets before the if-else statements.
What is this if statement?The if/else statement is known to be that which carry out a block of code if a given condition is true.
Note that If the condition is false, a given or another block of code iis one that can be executed.
Learn more about if-else statements from
https://brainly.com/question/18736215
#SPJ1
which window would show you bindings for local area connection 2?
Answers
8. Choose the 3 correct statements for the code below.
class BaseLayer:
def __init__(self, name=""):
self.name = name
def __repr__(self):
return f"{self.name}Layer"
class ActivationLayer(BaseLayer):
def __init__(self, size):
super().__init__("Activation")
self.size = size
class FCLayer(BaseLayer):
def __init__(self, size):
super().__init__("FullyConnected")
self.size = size
Answers
The correct statements for the code below are:
An object of the ActivationLayer class has a name attribute.print(FCLayer(42)) prints FullyConnectedLayer.When creating an object of the BaseLayer class, the name argument must be given.What is activation layer?Activation layer is known to be the added into the code after the weight layer.
Note that The correct statements for the code below are:
An object of the ActivationLayer class has a name attribute.print(FCLayer(42)) prints FullyConnectedLayer.When creating an object of the BaseLayer class, the name argument must be given.See options below
An object of the ActivationLayer class has a name attribute.
An object of the BaseLayer class has a size attribute.
print(FCLayer(42)) prints FullyConnectedLayer.
When creating an object of the ActivationLayer class, the size argument must be given.
When creating an object of the BaseLayer class, the name argument must be given.
Learn more about code from
https://brainly.com/question/26497128
#SPJ1
Create a python program that converts number grades to letter grades.
Console
Letter Grade Converter
Enter numerical grade: 90
Letter grade: A
Continue? (y/n): y
Enter numerical grade: 88
Letter grade: A
Continue? (y/n): y
Enter numerical grade: 80
Letter grade: B
Continue? (y/n): y
Enter numerical grade: 67
Letter grade: C
Continue? (y/n): y
Enter numerical grade: 59
Letter grade: F
Continue? (y/n): n
Bye!
Specifications
The grading criteria is as follows:
A 88-100
B 80-87
C 67-79
D 60-66
F <60
Assume that the user will enter valid integers for the grades.
The program should continue only if the user enters “y” or “Y” to continue.
Answers
The python program that converts number grades to letter grades is as written below.
How to create a python program?The python program that converts number grades to letter grades is as written below;
def test(nums):
return ["A" if grade >= 88
else ("B" if grade >= 80
else ("C" if grade >= 67
else ("D" if grade >= 60
else ("C" if grade < 60
for grade in nums]
Read more about python codes at; https://brainly.com/question/26497128
#SPJ1
A touchscreen is a type of _____ screen.
capacitive
interactive
resistive
LED
Answers
Answer:
LED
Explanation:
touch screen is the assembly of both an input ('touch panel') and output ('display') device. The touch panel is normally layered on the top of an electronic visual display of an information processing system. The display is often an LCD, AMOLED or OLED display while the system is usually a laptop, tablet, or smartphone.
A
Two of the three following numbers
are equal. Which of the following
numbers is not equal to the other
two numbers?
0100 1101
binary
B
77 (decimal -
base 10)
C
4E16
(Hexadecimal
-base 16)
Answers
C is not equal to the other two numbers.
Explanation:
A is 77
B is 77
but C is actually 78.
For Captive Analytics firms clients are well defined? True or false
Answers
From the aspect of captive Analytics firms, clients are well-defined. Yes, in this case, the given statement stands true.
What are captive Analytics firms?Captive Analytics firms save the exceedingly exclusive data, typically in the BFSI space, and hire specialists in setting up their division. And then the crew grows primarily based totally on the ROI and the sort of initiatives they take up.
Thus, From the aspect of captive Analytics firms, clients are well-defined. Yes, in this case, the given statement stands true.
Learn more about captive Analytics firms:
https://brainly.com/question/24304837
#SPJ1
Question 4 (5 points) If your social media accounts are___________, college admissions representatives can look at your social media activity when deciding whether or not to accept you at their school. O restricted private firewalled Opublic Question 4 ( 5 points ) If your social media accounts are___________ , college admissions representatives can look at your social media activity when deciding whether or not to accept you at their school . O restricted private firewalled Opublic
Answers
If your social media accounts are public, college admissions representatives can look at your social media activity when deciding whether or not to accept you at their school.
What is a public social media account?Public social media account is also known as the open account, in which any people can check the person's post and like and share the post. Basically, famous people like to keep their account public to gain more publicity.
Thus, option D is correct.
For more details about Public social media account, click here:
https://brainly.com/question/23378133
#SPJ1
Answer: The answer is B: Public
Explanation:
Retype the below code. Fix the indentation as necessary to make the program work.
if 'New York' in temperatures:
if temperatures['New York'] > 90:
print('The city is melting!')
else:
print('The temperature in New York is', temperatures['New York'])
else:
print('The temperature in New York is unknown.')
Sample output with input: 105
The city is melting!
Perferred in Python
Answers
The retyped code fixing the indentation problem is attached below
Proper Indentation in pythonThe proper indentation of lines of codes in python can be done by hitting the the space 4 times or by using the Tab button
The values assigned to the dictionary with variable_name temperatures is missing but I have provided an assumed dictionary to enable the proper writing and Indentation of the lines of code.
Hence we can conclude that The retyped code fixing the indentation problem is attached below.
Learn more about errors of proper indentation : https://brainly.com/question/18497347
#SPJ1
steps to copy and paste text/information from website to Ms-word using keyboard
Answers
Answer: Highlight the text you want to copy. Use the shortcut key combination Ctrl + C on a PC or Command + C on a Mac to copy the text. Move the text cursor to where you want to paste the text. Press Ctrl + V on a PC or Command + V on a Mac to paste the text
Explanation:
just copy and past by highlighting the text you want and clicking ctrl and c at the same time then ctrl and v to put it on word
26. A network administrator is looking to expand the available bandwidth of his extranet remote branch by adding another leased line. The ISP has notified the administrator that another physical serial connection will need to be added to his gateway router. Which of the following will realise this?
A. Add a distribution layer card into the router allowing another gigabit ethernet port.
B. Add a layer 3 switch into the network.
C. Install a WAN interface card with appropriate interface connectors to the
router.
D. Multiplex the existing serial using the appropriate commands in the config
file.
27. What happens after configure a rule with IP address 0.0.0.0 and wildcard mask 255.255.255.255?
A. This is default configuration B. Block all IP address
C. Allow all IP addresses
D. Nothing will happens
Answers
The option that will realize the above case is that Add a distribution layer card into the router allowing another gigabit ethernet port.
How do one Increase Bandwidth on RouterThe steps are:
Alter the Router's Location. Then Reboot your Router.Have a Dual-bandwidth Router. Then do Update the Router's Firmware.So therefore, The option that will realize the above case is that Add a distribution layer card into the router allowing another gigabit ethernet port.
Learn more about expanding bandwidth from
https://brainly.com/question/25898149
#SPJ1
An engineer is developing an algorithm to diagnose a person’s illness based on their reported symptoms.
In this scenario, the engineer would likely want to favor __________ as the most important category when developing their algorithm.
Answers
The engineer would likely want to favor accuracy as the most important category when developing his or her algorithm.
What is an algorithm?An algorithm can be defined as a standard formula or procedures which consist of a set of finite steps and instructions that are executed on a computer system, in order to enable a software solve a particular problem under appropriate conditions.
In this scenario, the engineer would likely favor accuracy as the most important category when developing his or her algorithm to diagnose illness in a person based on their reported symptoms.
Read more on algorithm here: brainly.com/question/24793921
#SPJ1
Accuracy
The engineer would likely want to favor accuracy as the most important category when developing her algorithm.
An algorithm is a standard formula or procedures which consist of a set of finite steps and instructions that are executed on a computer system, to enable a software to solve a problem under appropriate conditions.
This engineer would favor accuracy as the most important category when developing her algorithm to diagnose illness in a person based on his reported symptoms.
You've determined that your email program, Outlook, is not working, and your
manager tells you to reboot your email program. Which of these should you NOT do?
Answers
You've determined that your email program, Outlook, is not working, and your manager tells you to reboot your email program Go and restart outlook. If it begins offevolved and works fine, then Outlook is fine, if now no longer, continue to the following approach to troubleshoot.
Why is my Outlook Email now no longer working?Remove and re-upload the e-mail account at the Outlook app. Check for any pending updates in your tool or for the Outlook app. Remove the Outlook app out of your telecellsmartphone and re-down load it out of your tele cellsmartphone's app save to make certain which you have the maximum up to date Outlook app. Restart your smartphone/too.
Go and restart outlook. If it begins offevolved and works fine, then Outlook is fine, if now no longer, continue to the following approach to troubleshoot. Press the Windows key and press “r” to your keyboard and sort outlook.exe /reset navpane in the “Run” conversation box. Press “Enter” to run OutlookWhile the using of Microsoft Outlook, you may have come upon several forms of mistakes which restrict you from getting access to it completely. And one of the maximum encountered mistakes is ‘Outlook isn't closing’, even after clicking the go out button a couple of times.Read more about managers:
https://brainly.com/question/24553900
#SPJ1
How could this
innovation change society?
Answers
Answer:
invention such as new tool devices progress and resistance benefits to society inventions selfie lies and provide new way to build move communicate heal learn and play
Most antivirus software is effective against:
Group of answer choices
only those viruses active on the Internet and through e-mail
only those viruses already known when the software is written
any virus
any virus except those in wireless communications applications
Answers
Explanation:
only those viruses already known when the software is written
Which of the following shows how to correctly declare pointer variable x?
A. int x;
B. int &x;
C. ptr x;
D. int *x;
Answers
Answer:
declaration of pointer variables are done using *
Explanation:
* denotes the declared variable is a pointer which can hold address of another location. To get values of any address & is used. For example, we have an integer variable a to which holds a value 10. if you want to read the address of the variable a, use &a. To store this address in any other memory declare a pointer variable.
int a = 10;
int *loc_a;
loc_a = &a;
6.24 LAB: Convert to binary - functions
Write a program that takes in a positive integer as input, and outputs a string of 1's and 0's representing the integer in binary. For an integer x, the algorithm is:
As long as x is greater than 0
Output x % 2 (remainder is either 0 or 1)
x = x // 2
Note: The above algorithm outputs the 0's and 1's in reverse order. You will need to write a second function to reverse the string.
Ex: If the input is:
6
the output is:
110
The program must define and call the following two functions. Define a function named int_to_reverse_binary() that takes an integer as a parameter and returns a string of 1's and 0's representing the integer in binary (in reverse). Define a function named string_reverse() that takes an input string as a parameter and returns a string representing the input string in reverse.
def int_to_reverse_binary(integer_value)
def string_reverse(input_string)
in python
Answers
The program illustrates the use of functions, iterations and modulo operator
The complete programThe program written in Python is as follows:
import math
def int_to_reverse_binary(integer_value):
remainder = ""
while integer_value>=1:
remainder+=str(integer_value % 2)
integer_value=math.floor(integer_value/2)
reverse_string(remainder)
def reverse_string(input_string):
binaryOutput=""
for i in range(len(input_string)-1,-1,-1):
binaryOutput = binaryOutput + input_string[i]
print(binaryOutput)
integer_value = int(input("Enter a Number : "))
int_to_reverse_binary(integer_value)
Read more about Python programs at:
https://brainly.com/question/13246781
#SPJ1
How will quantum computing affect artificial intelligence applications
Answers
Answer:
it is very helpful
Explanation:
Quantum computing opens the door potentially solving very large and complex computational problems that are basically impossible to solve on traditional computers.
List several advantages developing software in a higher-level language has over developing software in machine language.
Answers
Reusability and ease of access
The software will be machine independent
The software will be user-friendly
Find and print the maximum values of each column in the subset
Answers
Using python knowledge it is possible to write a function that displays the largest sets of an array.
Writting in pythonimport pandas as pd
cars_df=pd.read_csv('Cars.csv')#cars.csv is not provided, using random data
userNum = int(input())
cars_df_subset=cars_df[:userNum]
print(cars_df_subset.max())
See more about python at brainly.com/question/18502436
#SPJ1
Someone please help me, i have exams in 2 hours please help me :-(
Answers
Explanation:
Let me help you
Answer to MCQ a:CELL
Answer to MCQ b:Cursor
Answer to MCQ c:Table
Answet to MCQ d:Spreadsheet
Answer to MCQ e:F2 function key
Answer to MCQ f:Right aligned
Answer to MCQ g:Left aligned
Good luck for your exam :)
Select the correct answer.
Lavinia wants to use a protocol for sharing files on a computer network. Which protocol is designed for that purpose?
A. DHCP
B. DNS
C. FTP
D. HTTP
Answers
Answer:
C. FTP
Explanation:
FTP is a network protocol for transmitting files between computers.
describe the purpose of working directory and how it can be speed or slow file access
Answers
Explanation:
The working directory is just a file path on your computer that sets the default location of any files you read. If you want to read a file 'file.txt'.
After turning the volume all the way up on your speakers, you still cannot hear any sound. Which of the following should be your the next step?
OPTIONS
You should replace your system speakers.
You should try to re-install your sound card.
You should unplug your computer and plug it back in.
You should check that your sound isn't muted.
Answers
The option to do among the above in terms of your the next step is to you should check that your sound isn't muted.
What to do when sound is not coming from speakers?
The likely things to do to Fix sound or audio issues in Windows are:
Check the speaker output. Also Check sound settings. Fix the audio drivers of the system.Note that the right and first thing to do if one do not hear any sound is to check if the system is on mute and so, The option to do among the above in terms of your the next step is to you should check that your sound isn't muted.
Learn more about audio issues from
https://brainly.com/question/14649463
#SPJ1
Write a program to print the absolute value of a number entered by the user. E.g.-
INPUT: 1 OUTPUT: 1
INPUT: -1 OUTPUT: 1
Answers
The program to print the absolute value of a number entered by the user will be:
number = int(input("Enter a number: "))
print(abs(number))
What is a program?It should be noted that a computer program is a set of instructions that are in a programming language for a computer to execute.
Furthermore, computer programs are one component of software that also includes documentation and other intangible components.
In conclusion, the program is illustrated above.
Learn more about program on:
https://brainly.com/question/24833629
#SPJ1