CHAR(n) A.Foreign key b.continuously-valued numeric c.variable-width d.surrogate key e.fixed-width string data type f.discreetly-valued numeric VARCHAR(n) A.Foreign...
CHAR(n)
A.Foreign key
b.continuously-valued numeric
c.variable-width
d.surrogate key
e.fixed-width string data type
f.discreetly-valued numeric
VARCHAR(n)
A.Foreign key
b.continuously-valued numeric
c.variable-width
d.surrogate key
e.fixed-width string data type
f.discreetly-valued numeric
IDENTITY or AUTO_INCREMENT
A.Foreign key
b.continuously-valued numeric
c.variable-width
d.surrogate key
e.fixed-width string data type
f.discreetly-valued numeric
DECIMAL(x,y)
A.Foreign key
b.continuously-valued numeric
c.variable-width
d.surrogate key
e.fixed-width string data type
f.discreetly-valued numeric
INT
A.Foreign key
b.continuously-valued numeric
c.variable-width
d.surrogate key
e.fixed-width string data type
f.discreetly-valued numeric
Homework Answers
Dear Student ,
As per requirement submitted above kindly find below solution.
Question 1:
Answer :e.fixed-width string data type
Explanation :
- char(n) is a fixed-width string data type
- primary key of one table when used in another table it becomes foreign key in another table.
- variable-width means can store upto max characters but will take width as per the value in the column.
***************************************
Question 2:
Answer :c.variable-width
Explanation :
- varchar(n) is a variable-width data.
- primary key of one table when used in another table it becomes foreign key in another table.
- char(n) is fixed width data type.
***************************************
Question 3:
Answer :b.continuously-valued numeric
Explanation :
- IDENTITY or AUTO_INCREMENT is continuously-valued numeric
- This means one a column is given as auto increment or identity then no need to given the value of the column while inserting records
- This value will be incremented automatically.
***************************************
Question 4:
Answer :f.discreetly-valued numeric
Explanation :
- DECIMAL(x,y) is a discreetly-valued numeric
- Decimal can store fractional numbers like 3.2,8.9 etc.
***************************************
Question 5:
Answer :f.discreetly-valued numeric
Explanation :
- INT is a discreetly-valued numeric
- INT can store numeric values like 1,100,1000 etc.
***************************************
NOTE :PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.
Add Answer to:
CHAR(n)
A.Foreign key
b.continuously-valued numeric
c.variable-width
d.surrogate key
e.fixed-width string data type
f.discreetly-valued numeric
VARCHAR(n)
A.Foreign...
My C program is supposed to make a random key the same length of clear_text string...
My C program is supposed to make a random key the same length of
clear_text string and then use the random key to encrypt
clear_text, but I can’t get it to work.
A wΝΗ 1 #include <stdio.h> 2 #include<stdlib.h> 3 #include<time.h> 4 char* make_rand_key(int length, char* key); 5 void encrypt(); 7- int main() { 8 encrypt(); 9 } 10 char* make_rand_key(int length, char* key){ int range=78; int max=48; char c='a'; int i; 'srand(time(NULL)); for(i=0;i<length;i++){ C=rand()%range_max; key[i]=c; key[i]='\0'; return key; 23...
rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name...
rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name varchar(25) student last name major_id integer the ID of the student's major; a foreign key for the major_id in the rider_major table rider_major Column Data Type Description major_id integer the primary key major_name varchar(50) student first name major_description varchar(100) student last name Use the Tables above to answer the questions. Questions: 1. Write a SQL statement to add a student record to the rider_student...
Write a psuedocode for this program. #include <iostream> using namespace std; string message; string mappedKey; void...
Write a psuedocode for this program. #include <iostream> using namespace std; string message; string mappedKey; void messageAndKey(){ string msg; cout << "Enter message: "; getline(cin, msg); cin.ignore(); //message to uppercase for(int i = 0; i < msg.length(); i++){ msg[i] = toupper(msg[i]); } string key; cout << "Enter key: "; getline(cin, key); cin.ignore(); //key to uppercase for(int i = 0; i < key.length(); i++){ key[i] = toupper(key[i]); } //mapping key to message string keyMap = ""; for (int i = 0,j...
The following code is a C Program that is written for encrypting and decrypting a string....
The following code is a C Program that is written for encrypting
and decrypting a string. provide a full explanation of the working
flow of the program.
#include <stdio.h> int main() { int i, x; char str[100]; printf("\n Please enter a valid string: \t"); gets (str); printf ("\n Please choose one of the following options: \n"); printf ("1 = Encrypt the given string. \n"); printf("2 = Decrypt the entered string. \n"); scanf("%d",&x); // using switch case statements switch (x) {...
Help please ASSIGNEMENT 1: Create table NATION along with following data: 40create table nation 41 (natcode char(3) not null 42 natname varchar (20) 43 exchrate decimal(9,5) 44 constraint pk natio...
Help please
ASSIGNEMENT 1: Create table NATION along with following data: 40create table nation 41 (natcode char(3) not null 42 natname varchar (20) 43 exchrate decimal(9,5) 44 constraint pk nation primary key (natcode))s 45 Add data into the table nation 46insert into nation values ('UK', 'United Kingdom',1) 47insert into nation values USA, 'United States',0.67) 48insert into nation values ('AUS,'Australia',0.46) 49insert into nation values (' IND,India',0.8228) DELIVERABLE 1: Screen shot evidence of the above table and data in MySQL workbench
ASSIGNEMENT...
Consider the following methods’ headers: public static int one(int a, char b, double c, String d)...
Consider the following methods’ headers: public static int one(int a, char b, double c, String d) public static double two(double x, double y) public static char three(int r, int s, char t, double u) Answer the following questions: Q1) What is the signature of method one? Answer: Q2) What is the return type of method two? Answer: Q3) What the formal parameters of method three? Answer: Q4) How many actual parameters are needed to call the method three? Answer: Q5)...
#include <iostream> #include<string> #include<vector> using namespace std; struct patient { string name; char Gender; int d,m,y;...
#include <iostream> #include<string> #include<vector> using namespace std; struct patient { string name; char Gender; int d,m,y; string nationality; int civilID; int phoneNumber; string TypeOfInsurance; }; Activities I. Declare a variable from the struct Patient called pat. II. Fill out the information of pat by reading them from the input. III. Declare a pointer of type Patient called pat_ptr and assign the address of pat to it. IV. Change the value of name field of pat by accessing it through pat_ptr....
def average_word_length(string): num_words = 0 if not type(string)==str: return "Not a string" if not "A" or...
def average_word_length(string): num_words = 0 if not type(string)==str: return "Not a string" if not "A" or not "B" or not "C" or not "D" or not "E" or not "F" or not "G" or not "H" or not "I" or not "J"\ or not "K" or not "L" or not "M" or not "N" or not "O" or not "P" or not "Q" or not "R" or not "S" or not "T"\ or not "U" or not "V" or not...
tx,y) printf('"Xd %d\n",x,y); void stutt (int a, int b) ( Type Definitions (5 POINTS EACH) 1....
tx,y) printf('"Xd %d\n",x,y); void stutt (int a, int b) ( Type Definitions (5 POINTS EACH) 1. define a stack type that points to a stacknode" structure for s stack that will manipulate real mumbers Strud steck no de int data shiud stackrode米nett, det Shudt stacknode toct nodej a single real number, respectively 2. define a tarver type that consists of two parts ("partl" and "part2") which contain an aray of 5 integgrs snd tyhedeb strut twver int arod I51 aYrOL...
Name: True/False & Multiple Choice (2 points each) (True / False ) 2 A char literal...
Name: True/False & Multiple Choice (2 points each) (True / False ) 2 A char literal '2', a string literal "2", and the numeric literal 2 are identical and stored the same way though they are different types. 3 Since comments do not affect the program execution, you don't need to have it at all. 4. After the following statements are executed, the value of the variable rem is 3. 1. A preprocessor directive line starts with a pound sign...
My C program is supposed to make a random key the same length of
clear_text string and then use the random key to encrypt
clear_text, but I can’t get it to work.
A wΝΗ 1 #include <stdio.h> 2 #include<stdlib.h> 3 #include<time.h> 4 char* make_rand_key(int length, char* key); 5 void encrypt(); 7- int main() { 8 encrypt(); 9 } 10 char* make_rand_key(int length, char* key){ int range=78; int max=48; char c='a'; int i; 'srand(time(NULL)); for(i=0;i<length;i++){ C=rand()%range_max; key[i]=c; key[i]='\0'; return key; 23...
The following code is a C Program that is written for encrypting
and decrypting a string. provide a full explanation of the working
flow of the program.
#include <stdio.h> int main() { int i, x; char str[100]; printf("\n Please enter a valid string: \t"); gets (str); printf ("\n Please choose one of the following options: \n"); printf ("1 = Encrypt the given string. \n"); printf("2 = Decrypt the entered string. \n"); scanf("%d",&x); // using switch case statements switch (x) {...
Help please
ASSIGNEMENT 1: Create table NATION along with following data: 40create table nation 41 (natcode char(3) not null 42 natname varchar (20) 43 exchrate decimal(9,5) 44 constraint pk nation primary key (natcode))s 45 Add data into the table nation 46insert into nation values ('UK', 'United Kingdom',1) 47insert into nation values USA, 'United States',0.67) 48insert into nation values ('AUS,'Australia',0.46) 49insert into nation values (' IND,India',0.8228) DELIVERABLE 1: Screen shot evidence of the above table and data in MySQL workbench
ASSIGNEMENT...
tx,y) printf('"Xd %d\n",x,y); void stutt (int a, int b) ( Type Definitions (5 POINTS EACH) 1. define a stack type that points to a stacknode" structure for s stack that will manipulate real mumbers Strud steck no de int data shiud stackrode米nett, det Shudt stacknode toct nodej a single real number, respectively 2. define a tarver type that consists of two parts ("partl" and "part2") which contain an aray of 5 integgrs snd tyhedeb strut twver int arod I51 aYrOL...
Name: True/False & Multiple Choice (2 points each) (True / False ) 2 A char literal '2', a string literal "2", and the numeric literal 2 are identical and stored the same way though they are different types. 3 Since comments do not affect the program execution, you don't need to have it at all. 4. After the following statements are executed, the value of the variable rem is 3. 1. A preprocessor directive line starts with a pound sign...
Most questions answered within 3 hours.
-
Write a program to solve the Josephus problem, with the following
modification:
Sample Input:
./a.out n...
asked 1 hour ago -
At the start of a CD it is spinning at a rate of 525 rpm
(revolutions...
asked 2 hours ago -
4. Without doing any calculations, predict whether the observed
∆T would increase, decrease or remain the...
asked 3 hours ago -
Based on the range, which of the following sets of scores has
the greatest variability? 3,...
asked 4 hours ago -
Ripples in a pond travel at a velocity of 3 m/s with one peak
passing a...
asked 4 hours ago -
A man stands on the roof of a building of height 13.0 mm and
throws a...
asked 4 hours ago -
The extent to which assets are financed by borrowed funds and
other liabilities is indicated by:...
asked 5 hours ago -
Explain in detail
Germany is the fifth largest economy
explain what goods and services Germany specializes...
asked 6 hours ago -
The density of platinum is 21.45 g/mL. If a cube of platinum
with a mass of...
asked 6 hours ago -
Accounts Receivable
Sales
A/R Posting
Extended Sales Invoice
Packing Slip
Compare invoice to packing slip 2...
asked 6 hours ago -
Michaella, age 23, is a full-time law student and is claimed by
her parents as a...
asked 6 hours ago -
Why are polymers not typically casted into products?
asked 6 hours ago