To access the Database Design Module, go to: ign Module, go to: http:/ladbe.kenn

Question

To access the Database Design Module, go to: ign Module, go to: http:/ladbe.kennesaw.edu/ http://adbc.kennesaw.edu/ Functional Dependencies In this section go through the following sections/scenarios: Introduction Help (Read instruction on how to use this sub module) Hospital scenario University scenario Stocks scenario Normalization In this section go through the following sections/scenarios: Help (Read instructions on how to create tables and designate Primary Keys) Employee scenario Auto Theft Scenario Property scenario Customer scenario Medicine scenario

Explanation / Answer

Normal Form

2NF

1NF

2NF

3NF

2NF

3NF

4NF

3NF

1NF

Normal Form

1. No Partial Dependencies

2NF

1. No multi-value attributes

1NF

1. No dependency between non-key attributes

2NF

1. All attributes are dependent on the key

3NF

1. All attributes are dependent on the whole key

2NF

1. All attributes are dependent on nothing but the key

3NF

1. Similar to BCNF

4NF

1. No transitive dependencies

3NF

1. For a table to be considered a relation, it must at least satisfy

1NF

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.