B-- Database for Management (INT300) Assignment 1 Summer Semester 2021-2022 CoLing comel Soest Som 1. What is a function

[answerhappygod]

B Database For Management Int300 Assignment 1 Summer Semester 2021 2022 Coling Comel Soest Som 1 What Is A Function 1 (19.17 KiB) Viewed 32 times

B-- Database for Management (INT300) Assignment 1 Summer Semester 2021-2022 CoLing comel Soest Som 1. What is a functional dependency? Give an example not used in the text. 2. Consider the following Student Registration relation Student Registration (Student Id. Cours Id. student Name, Student_address, Course_Title, Credit Hour, Nationality Code, Nationality Name, grade. year, semester) Assume the following functional dependencies: The key for this relation is Student_Id, Cours_Id (Student Id. Course Id) à (Student Name Student address, Course Title. Credit Hour, Nationality Code, Nationality Name, grade, year semester) Student Idà (Student Name, Student address, Nationality Code, Nationality Name) Cours là Course Title, Credit Hour Nationality Code à Nationality Name i. What normal the relation is in ii. Normalize the relation up to 3NF 2