-- Write your code here
includes scenarios for restaurant menus and social media profiles. Textbook Solutions: Fundamentals of Database Systems Solutions covers integrity constraints and relational algebra. database exercises and solutions pdf
The primary key should be a combination of the student ID and the advisor ID ( ) to ensure uniqueness for each relationship. Foreign Key Link: branch_name table should be a foreign key referencing the branch_name Exercise 3: Normalization & Functional Dependencies Consider a relation and its functional dependencies (FDs). LTH, Lunds Tekniska Högskola Show that a relation is in (Third Normal Form) but not in (Boyce-Codd Normal Form). Solution Overview 3NF Check: A relation is in 3NF if for every non-trivial FD is a superkey or is a prime attribute (part of a candidate key). BCNF Check: It fails BCNF if there is a non-trivial FD a superkey. To fix this, you must -- Write your code here includes scenarios for