đź“„
EBIS3003-2021
  • Introduction to the Course
  • Preliminaries
    • donorschoose.org
    • Installing Software
    • Sequel Pro Local Access
    • Import donorschoose.org Data to MySQL Server
    • MySQL Setting for Client Software
  • SQL
    • Class Activity 2 - Creating New Tables (Week 2)
    • Inserting Table
    • Select / Functions
    • Grouping
  • PYTHON
    • Installing Anaconda
    • Running Jupyter Notebook
    • Connecting MySQL via Python
  • Assignments
    • In-class Activity - ER (Week 5)
    • Homework Assignment 1
      • Solutions
    • Homework Assignment 2
    • In-Class Activity - Python (Week 11-12)
    • In-Class Activity - Normalization (Week 14)
Powered by GitBook
On this page
  • Solutions:
  • 1. 2NF
  • 2. Two Additional Relations for 3NF

Was this helpful?

  1. Assignments

In-Class Activity - Normalization (Week 14)

PreviousIn-Class Activity - Python (Week 11-12)

Last updated 3 years ago

Was this helpful?

Consider the following 1NF table:

1.Identify “partial dependencies” in the table above.

2.Create THREE tables in 2NF from the given table.

3. Identify “transitive dependencies” from your answer in step 2.

4. Create FOUR tables in 3NF from your answer in step 2.

Solutions:

1. 2NF

2. Two Additional Relations for 3NF