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:
def leap_year(y):
if y % 4 == 0:
return 1
else:
return 0
def number_of_days(m,y):
if m == 2:
return 28 + leap_year(y)
elif m == 1 or m == 3 or m == 5 or m == 7 or m == 8 or m ==10 or m == 12:
return 31
elif m == 4 or m == 6 or m == 9 or m == 11:
return 30
def days(m,d):
if m == 1:
return 0 + d
if m == 2:
return 31 + d
if m == 3:
return 59 + d
if m == 4:
return 90 + d
if m == 5:
return 120 + d
if m == 6:
return 151 + d
if m == 7:
return 181 + d
if m == 8:
return 212 + d
if m == 9:
return 243 + d
if m == 10:
return 273 + d
if m == 11:
return 304 + d
if m == 12:
return 334 + d
def days_left(d,m,y):
if days(m,d) <= 60:
return 365 - days(m,d) + leap_year(y)
else:
return 365 - days(m,d)
print("Please enter a date")
day=int(input("Day: "))
month=int(input("Month: "))
year=int(input("Year: "))
choice=int(input("Menu:\n1) Calculate the number of days in the given month.\n2) Calculate the number of days left in the given year.\n"))
if choice == 1:
print(number_of_days(month, year))
if choice == 2:
print(days_left(day,month,year))
Explanation:
Hoped this helped
In excel spreadsheets, you need to consider specifying relationships between the information you have
stored in your spreadsheets when creating formulas. The elements that will help
you understand using spreadsheet are the constants, operators, references and
functions. This will enable you to use the formulas, without hassle in
spreadsheets.
A computational instruction with operands is command so computational instructionis just a opcode.
B. opcode
There is only one programming language that is closest to a human language and is the most easy to learn other than HTML or CSS.
That language would be AppleScript. for both its simplicity and power, it has become an ideal language for basic Apple programmers to learn.
