...
September 5, 2024

Functional-Dependency

Question 45 Every time the attribute A appears, it is matched with the same value of attribute B but not the same value of attribute C. […]
September 6, 2024

Database-Management-System

Question 2 Consider a database of fixed-length records, stored as an ordered file. The database has 25,000 records, with each record being 100 bytes, of which […]
September 6, 2024

Normalization

Question 68 Consider the following table : Faculty (facName, dept, office, rank, dateHired) (Assume that no faculty member within a single department has same name. Each […]
September 8, 2024

SQL

Question 20 (a) How is redundancy reduced in the following models? (i) Hierarchical (ii) Network (iii) Relational Write a one line answer in each case. (b) […]