Question: 1. Here is a table representing a relation named R MBC Identify: 1. The attributes of R 2. The schema of R 3. The tuples

1. Here is a table representing a relation named R MBC Identify: 1. The attributes of R 2. The schema of R 3. The tuples of R. 4. The components of the tuples for each attribute of R. Which of the following is NOT a true statement about relation R? a) The schema of R is R(A,B,C) b) (0,3,6) is a tuple of R. c) (3,4,5) is a tuple of R. d) 0 is the value of the A-component of one of the tuples of R. 2. Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken, and the grades students have gotten in these courses. Courses have a number, a department, and a title, for example, "CS101: Introduction to computing" has department CS, number 101, and title- "Introduction to Computing." Numbers are assigned by departments, and different departments may use the same number, Students are represented by their (unique) student ID and their name. "Enrollments" each consist of a course, a student who took that course, and the grade the student got in the course. If we created a relational schema for this database, which of the following would LEAST likely be an attribute of some relation? a) enrollment b) grade c) studentID d) department
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
