RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Relational Data Analysis
Relational Constraints
DB Normal Forms
Third Normal Form
Table Joins User Views
Functional Dependencies - Exercise
Functional dependencies, part 2
Representing functional dependencies
Objective:
Represent functional dependencies using proper notation.
Exercise scoring
This exercise is worth a total of 10 points.
You will receive up to five points for correctly identifying each functional dependency in the given relations.
Instructions
Identify the functional dependencies in the following relations and represent the dependencies using the proper notation.
Book (BookID, Title, Publisher, Year, ISBN)
Computer (CompID, CPU, Memory, HardDrive, Floppy, Monitor)
Submitting your exercise
Type or paste the normalized relations into the text box below, then click
Submit
to submit them and view a results page.