Consider the set of relations given below and SQL query implemented on the relations:
Student: Roll_Number, Name, DOB
Courses: Course_No, CourseName, Instructor
Enroll: Roll_no, Course_No, Grade
SELECT DISTINCT Name
FROM Student, Courses, Enroll
WHERE Student.Roll_No= Enroll.Roll_No
AND Courses.Instructor= RAVI
AND Courses.Course_No= Enroll.Course_No
Which of the following set is computed by the given SQL Query?
Identify the capabilities of SELECT statement.
Consider an ordered file with 1,00,000 records stored on a disk using un-spanned file organization. Block size is 2048 bytes and record length 256 bytes. If primary indexing is used over a field of size 10 bytes and block pointer size is 6 bytes. Then number of block access is required to search for a record.
In the reflexive rule, true dependencies generated are classified as:
Generalization is a bottom up design process that combines several entities sets, which share the same features into a higher-level entity set