A university wants to schedule the classrooms for final exams. The attributes are given below:
1 answer:
Answer:
See explaination
Explanation:
Clearly the entities are as follows:-
Course
Section
Room
Test
The relationship among entities are as follows:-
Course has Section
Test is conducted for Course
Test is conducted in Section
Test is conducted in Room
Attributes of each entities are as follows:-
Course (CourseID, Name, Department)
Section (SectionID, Enrollment)
Room (RoomNumber, Capacity, Building)
Test (Time)
Section is a week entity as, there may be same sections for different courses, therefore section uses the primary key of course entity as foreign key.
Also entity Test is dependent upon the entities Room,Section and Course, therefore primary keys of these entities will be used as foreign key in the Test entity.
Check attachment for the ER diagram
You might be interested in
Answer:
# The user is prompted to enter the year
# the entered year is assigned to y
y = int(input("Enter the year: "))
# the remainder when y is divided by 19 is assigned to a
a = y % 19
# The quotient is assigned to b when y is divided by 100
b = y // 100
# The remainder is assigned to c when y is divided by 100
c = y % 100
# The quotient is assigned to d when b is divided by 4
d = b // 4
# The remainder is assigned to e when b is divided by 4
e = b % 4
# The quotient is assigned to g when 8 * b + 13 is divided by 25
g = (8 * b + 13) // 25
# The remainder is assigned to h when 19 * a + b - d - g + 15 is divided by 30
h = (19 * a + b - d - g + 15) % 30
# The quotient is assigned to j when c is divided by 4
j = c // 4
# The remainder is assigned to k when c is divided by 4
k = c % 4
# The quotient is assigned to m when a + 11 * h is divided by 319
m = (a + 11 * h) // 319
# The remainder is assigned to r when 2 * e + 2 * j - k - h + m + 32 is divided by 7
r = (2 * e + 2 * j - k - h + m + 32) % 7
# The quotient is assigned to n when h - m + r + 90 is divided by 25
n = (h - m + r + 90) // 25
# The remainder is assigned to p when h - m + r + n + 19 is divided by 32
p = (h - m + r + n + 19) % 32
# The date of easter is displayed
print ("Easter falls on day ", p, "of month ", n);
Explanation:
The code is written in Python and is well commented. A sample image of program output is attached.
