in your notes books and in your vopy
Enroll a student identified by her snum into the class named 'Introduction to Database Systems' is the following transactions, state the SQL isolation level you would use.
1. Enroll a student identified by her snum into the class named 'Introduction to Database Systems'.
<u>Explanation:</u>
Since enroll is unique in the university enrollment database schema and field name is SNUM and it is data type is an integer. To identify student class name and department name and name of student SNUM field is used for searching in university enrollment database schema. Enrollment changing is not possible of the student’s not possible or not good practices in university enrollment database schema.
If a query had been made class wise or department wise enrollment is played an important role.
For assign, a faculty is made on the class id or department id.
Answer:
ansList =input().split() #get input and split it by space
ansList = [int(i) for i in ansList if int(i)>0] #turn string to integer,and get all positive integers
print(ansList)
Explanation: I think this would work for you. I leace comments in the answer.
Answer:
public class Main
{
public static void main(String[] args) {
System.out.println(starString(4));
}
public static String starString(int n){
double p = Math.pow(2,n);
String s = "";
for(int i=0; i<p; i++)
s += "*";
return s;
}
}
Explanation:
Create a method named starString that takes an integer parameter, n
Get the 2 to the nth power using pow method and set it to the p
Create an empty string that will hold the asterisks
Create a for loop that will iterate p times. Inside the loop, concatenate an asterisk to the s
Return the s
Inside the main method, call the method with an integer parameter
There are some function which can be performed with database but not with a spread sheet, these functions include:
1. Enforcement of data type.
2. Support for self documentation.
3. Defining the relationship among constraints in order to ensure consistency of data.
