(b) Consider the following SQL statement.
SELECT * FROM employee
WHERE surname LIKE 'P__ris' AND department_no IS NOT NULL
ORDER BY salary, employee_no;
What output does this query produce?
Question # 5
(a) Explain the fundamental concept of functional dependencies, including how they define relationships between attributes in a relational database schema. Elucidate your answer in five sentences.
(b) Given the relational model below, normalize it to 3NF. Make sure you list the Functional Dependencies along with each relation and include all relations (each relation with its functional dependencies) in the summary.
Customers (CID, FirstName, LastName, Email, Address, Company, CompanyInfo)
FD1: CID ? FirstName, LastName, Email, Address, Company, CompanyInfo
FD2: Company ? CompanyInfo