Category Archives: Database Systems - Page 3

Dependencies in database

Database functional dependencies example Given the relation LDS (L, D, S) with the following functional dependencies definitions: L ->D and (S, D) -> L LDS is decomposed into two relations: LD (L, D) and SL (S, L) which are populated as …

Read more »

Sql relational division example

Problem Given the following database tables Employee (SSN, name, location) Assigned (SSN, project_name, duration) Project (project_name, category, budget, location) Write SQL statements to find the following: Project names with a budget smaller than the average budget of projects in a …

Read more »

Page 3 of 3123