...
September 1, 2024

SQL

Question 2 The following relations are used to store data about students, courses, enrollment of students in courses and teachers of courses. Attributes for primary key […]
September 2, 2024

Normalization

Question 21 Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Schema […]
September 2, 2024

Normalization

Question 24 Consider the following relational schemes for a library database: Book(Title, Author, Catalog_ no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) with in the following […]
September 2, 2024

Normalization

Question 27 Relation R has eight attributes ABCDEFGH . Fields of R contain only atomic values. F = {CH→G, A→BC, B→CFG, E→A, F→EG}, is a set […]