Looking for Database Systems Lab(BCSE302P) test answers and solutions? Browse our comprehensive collection of verified answers for Database Systems Lab(BCSE302P) at lms.vit.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
While converting from ER to relational model, many-many relationships are always mapped to a separate relation. State true or false.
Physical data independence is the the ability to change the conceptual scheme without changing external views or programs. State true or false
Clustered indexing method never stores data pages in the leaf nodes of the index.
Serial schedule supports concurrency. State true or false.
Which normal form ensures that there is no partial dependency?
Assume that the patient and doctor details are maintained together in a table. In a scenario, where the patient details are removed from the table what sort of anomaly can occur in this case?
In relational algebra, Rho denotes which operation?
Serializability check has to be done for every serial schedule. State true or false.
Suppose for a new patient, until and unless the patient opts for a physician in hospital, data of the patient cannot be added, or else we will have to set the physician information as NULL. What type of anomaly is this?
Granting privileges to users is an example of --------