BCS 260 Lecture Notes - Unique Key, Foreign Key, Candidate Key

3 views5 pages
1 Jul 2022
Course
Professor

Document Summary

Learn to apply the process for normalizing relations first normal. Recall from our functional dependency discussion that (courseid, year) dept, course. No, it can"t be since the primary key must be a candidate key, and by definition a candidate key is a minimal superkey and cannot include extra attributes. What are we worried about (courseid, year) (dept, course) So you see why we need ram to be part of pk. The dbms would let us add this tuple even though it violates the fd. This is strange, the determinant here is part of the candidate key. Since the fd: make a new table (courses, eliminate the rhs from enrollment, create a foreign key. The process of intentionally designing a relation that is not normalized. We do not always fully normalize our database sometimes we leave some attributes together even though we know that this creates duplication.

Get access

Grade+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers
Class+
$30 USD/m
Billed monthly
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
7 Verified Answers

Related textbook solutions

Related Documents

Related Questions