...
October 26, 2023

Functional-Dependency

Question 71 In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is […]
October 27, 2023

Database-Management-System

Question 6 Let Ri(z) and Wi(z) denote read and write operations on a data element z by a transaction Ti, respectively. Consider the schedule S with […]
October 28, 2023

Database-Management-System

Question 104 We wish to construct a B+ tree with fan-out (the number of pointers per node) equal to 3 for the following set of key […]
July 27, 2024

Normalization

Question 26 Consider the following relational schema: Suppliers(sid:integer, sname:string, city:string, street:string) Parts(pid:integer, pname:string, color:string) Catalog(sid:integer, pid:integer, cost:real) Assume that, in the suppliers relation above, each supplier […]
error: Alert: Content selection is disabled!!