Design the following two tables that might be used in the Student Registration System. Note that the same student Id might appear in many rows of each of these tables.
a. A table implementing the relation CoursesRegisteredFor, relating a student’s Id and the identifying numbers of the courses for which she is registered
b. A table implementing the relation CoursesTaken, relating a student’s Id, the identifying numbers of the courses he has taken, and the grade received in each course
a.
b.
Specify the predicate corresponding to each of these tables.
Solution:
For the ?rst table: Student X is registered for Course Y
For the second table: Student X has taken Course Y and gotten Grade Z
You might also like to view...
________ floods a computer with requests until it shuts down denying access to legitimate users
A) An encryption virus B) A DoS attack C) A polymorphic virus D) Port blocking
To select nonadjacent items, select the first item as usual, press and hold down the ____ key, and then while holding down the key, select the additional items.
A. HOME B. FN C. COMMAND D. OPTION
Unsolicited email messages are known as ____________________ or junk mail.
Fill in the blank(s) with the appropriate word(s).
How to specify cell range from A9 to A99 in Excel? Select one:
a. (A9, A99) b. (A9 : A99) c. (A9 to A99) d. (A9 - A99)