BITE302L Database Systems (Theory) Winter 2024-25 (B2+TB2) [VL2024250502774]
Looking for BITE302L Database Systems (Theory) Winter 2024-25 (B2+TB2) [VL2024250502774] test answers and solutions? Browse our comprehensive collection of verified answers for BITE302L Database Systems (Theory) Winter 2024-25 (B2+TB2) [VL2024250502774] at moovit.vit.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Consider the relation schema LICENSE(License_id, Fname, Lname, City, Phone, Age, primary key(License_id)). An expression in relational algebra to find out the name of city, average age and number of license holders in each city can be
100%
0%
0%
0%
View this question
Consider the set of functional dependencies F = {A determines BC, CD determines E, B determines D, E determines A} defined on a relation schema R(A, B, C, D, E). The closure of AB is
100%
0%
0%
0%
View this question
Consider the relational database schema BOOK_COPY(Book_id, Branch_id, Title, Publisher, primary key(Book_id, Branch_id)), BOOK_LOAN(Book_id, Branch_id, Card_no, Issue_date, Return_date, primary key(Book_id, Branch_id, Card_no)), LIBRARY_BRANCH(Branch_id primary key, Name, Address). One of the foreign keys in the schema is
0%
0%
100%
0%
View this question
Let R(A, B, C, D, E, F) be a relation schema with functional dependencies: A determines B, A determines C, CD determines E, CD determines F, B determines E. Which of the following functional dependencies does not hold on R?
100%
0%
0%
0%
View this question
Consider the set of functional dependencies F = {A determines BC, CD determines E, B determines D, E determines A} defined on a relation schema R(A, B, C, D, E). The closure of CD is
100%
0%
0%
0%
View this question
If XY determines Z and Z determines UV then
0%
100%
0%
0%
View this question
If an ER schema has two strong entity types and are involved in an association with cardinality constriant many to many and if one of the entity types has a multi valued attribute then the corresponding relational database schema will have
100%
0%
0%
0%
View this question
If an ER schema has a strong entity type and a weak entity type then the corresponding relational database will have
0%
0%
0%
100%
View this question
Consider the relation schema R(A, B, C, D) and the set of functional dependencies F = {A determines B, B determines C, C determines D}. A key of R is
0%
0%
0%
100%
View this question
Consider the relational database schema REGISTRATION (License_id, Car_id, Registered, primary key(License_id, Car_id)), CAR(Car_id primary key, Model, Year, Color). An expression in relational algebra to find out the license id of license holder and the model of the car owned by them can be
0%
0%
100%
0%
View this question
Want instant access to all verified answers on moovit.vit.ac.in?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!