What is Functional Dependency? steps to solve functional dependency? what will the functional dependency and keys for
Fantastic news! We've Found the answer you've been seeking!
Question:
What is Functional Dependency? steps to solve functional dependency? what will the functional dependency and keys for the above entity?
1. Entity name: Employee
Attributes: SSN, Employee ID, Fname, Lname, Start date, Position, Phone number, DOB
What will be
- Keys:
- Functional dependencies: Left ,both side and right
- Attribute closures
- Unique keys:
2. Entity name: Time sheet
Attributes: Employee ID, Time sheet ID, Start time, End time, Date
What will be
- Keys:
- Functional dependencies: Left ,both side and right
- Attribute closures
- Unique keys:
3. Entity name: Payment
Attributes: Payment ID, Order ID, Price, Date
What will be
- Keys:
- Functional dependencies: Left ,both side and right
- Attribute closures
- Unique keys:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: