Scribd
Upload
29 views4 pages

Normalized Tables Sample

The document outlines the process of normalizing a database through various stages, starting from Un-Normalized Form (UNF) to Boyce-Codd Normal Form (BCNF). It includes examples of tables at each normalization stage, detailing how data is split into separate tables to eliminate redundancy. The final schema consists of tables for Teacher, Student, Skills, and Company.

Uploaded by

Tanisha Agarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
29 views4 pages

Normalized Tables Sample

The document outlines the process of normalizing a database through various stages, starting from Un-Normalized Form (UNF) to Boyce-Codd Normal Form (BCNF). It includes examples of tables at each normalization stage, detailing how data is split into separate tables to eliminate redundancy. The final schema consists of tables for Teacher, Student, Skills, and Company.

Uploaded by

Tanisha Agarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Normalized Tables and Sample Data

### Steps for Normalization with Tables and Data

1. **UN-NORMALIZED FORM (UNF)**

| Student_id | Student_name | Technical_skills | Non_technical_skills | GitHub_link | Teacher_id |

|------------|--------------|------------------|-----------------------|-------------------|------------|

|1 | Alice | HTML, CSS | Communication | github.com/alice | 101 |

---

### 1NF (First Normal Form)

| Student_id | Student_name | Skill_type | Skill_name | GitHub_link | Teacher_id |

|------------|--------------|--------------|------------|-------------------|------------|

|1 | Alice | Technical | HTML | github.com/alice | 101 |

---

### 2NF (Second Normal Form)

**Split into Two Tables:**

1. **Student**:

| Student_id | Student_name | GitHub_link | Teacher_id |

|------------|--------------|-------------------|------------|

|1 | Alice | github.com/alice | 101 |

2. **Skills**:
| Student_id | Skill_type | Skill_name |

|------------|--------------|------------|

|1 | Technical | HTML |

---

### 3NF (Third Normal Form)

**Split Tables:**

1. **Company**:

| Company_id | Company_name | Website_link |

|------------|--------------|---------------|

| C1 | ABC Corp | abc.com |

2. **Company Details**:

| Company_id | Company_address | Company_description |

|------------|-----------------------|---------------------|

| C1 | 123 Street, City A | IT Solutions |

---

### 5. BCNF (Boyce-Codd Normal Form)

**Split Tables:**

1. **Job**:

| Job_id | Job_position | CTC | Company_id |

|--------|--------------|-----|------------|

| J1 | Developer | 10L | C1 |
2. **Application Details**:

| Student_id | Job_id |

|------------|--------|

|1 | J1 |

---

### Final Schema

1. Teacher Table

| Teacher_id | Teacher_name | Teacher_phone_no | Teacher_email | Teacher_password |

|------------|--------------|------------------|---------------|------------------|

| 101 | Dr. Smith | 1234567890 | smith@example | pass123 |

2. Student Table

| Student_id | Student_name | GitHub_link | Teacher_id |

|------------|--------------|-------------------|------------|

|1 | Alice | github.com/alice | 101 |

3. Skills Table

| Student_id | Skill_type | Skill_name |

|------------|--------------|------------|

|1 | Technical | HTML |

4. Company Table

| Company_id | Company_name | Website_link |

|------------|--------------|--------------|

| C1 | ABC Corp | abc.com |


---

Let me know if you'd like additional clarifications!

You might also like