Dr. Robbins wants to know if there are different opinions regarding the value of public school education between Native American
1 answer:
You might be interested in
Answer:
Check the explanation
Explanation:
Ans 1) storing the data in one single row comes with its own barriers and that is if you delete one of the record in the spreadsheet, all the equivalent records which you didn't wanted to delete would be deleted. For take for instance, if you wish to delete the record of author "James Taylor" then all the books he has written would also be deleted from the spreadsheet.
Ans 2) In 1NF, all row is expected to have only 1 tuple, but here in this spreadsheet the title field for Author "James Taylor" has 2 books, so it would be separated into single rows.
Ans 3) The table in the attached image below doesn't delete with Delete anomaly, i.e., for author "May Norton" if you delete this record, then the only book written by her would be deleted.
So, you have to convert this table into 2NF.
Make separate tables for Author and Book
Author(Author Name, Author Country)
Books(Author Name, Book title, Publisher, Publisher Location, Year, price)
This cannot be normalized any further.
Answer:
1st question:
Use the variables k, d, and s so that they can read three different values from standard input an integer, a float, and a string respectively. On one line, print these variables in reverse order with exactly one space in between each. On a second line, print them in the original order with one space in between them.
Solution:
In Python:
k = input() #prompts user to input value of k i.e. integer value
d = input() #prompts user to input value of d i.e. float value
s = input() #prompts user to input value of s i.e. a string
print (s, d, k) #displays these variable values in reverse order
print (k, d, s)#displays these variable values in original order
In C++:
#include <iostream> // to use input output functions
using namespace std; //to identify objects like cin cout
int main() { //start of main function
int k; //declare int type variable to store an integer value
float d; // declare float type variable to store a float value
string s; // declare string type variable to store an integer value
cin >> k >> d >> s; //reads the value of k, d and s
cout << s << " " << d << " " << k << endl; //displays these variables values in reverse order
cout << k << " " << d << " " << s << endl; } // displays these variable values in original order
Explanation:
2nd question:
You would like the user of a program to enter a customer’s last name. Write a statement that asks user "Last Name:" and assigns input to a string variable called last_name.
Solution:
In Python:
last_name = input("Last Name:")
# input function is used to accept input from user and assign the input value to last_name variable
In C++:
string last_name; //declares a string type variable named last_name
cout<<"Last Name: "; // prompts user to enter last name by displaying this message Last Name:
cin>>last_name; // reads and assigns the input value to string variable last_name
The programs alongwith their outputs are attached.
