For this lab we will be completing the Normalization step for several of your en

Question

For this lab we will be completing the Normalization step for several of your entities from your E/R diagram. You will normalize the following entities to 3rd normal form - show ALL steps - 1st normal form, 2nd normal form and 3rd normal form for each of the following entities: PATIENT, BED, EMPLOYEE, DEPARTMENT, TREATMENT, TEST

After going through your steps of normalization - add in your Foreign keys based on your cardinalities from your E/R diagram. You will add new attributes to several of your tables.

Explanation / Answer

Answer:

Here, I have following given entities to form as normalization form.

The given following entities are:

1st Normal Form: In this 1NF, there is no two rows of the data must contain the repeating values or the group of information. Thus, it represents the value of the columns must be unique.

So, it can be achieved by a 1st normal form by avoiding the entering of duplicate values of a particular column in a table.

This can be avoided by adding a PRIMARY KEY which does not allow any duplicate values to store.

From the given entities, the “Patient” is the main and it can be assigned as PRIMARY KEY. And now, the entities will be as follows:

2nd Normal Form:

In the 2NF, it should be same as the 1st Normal Form and every non-key column will depends on the entire Primary Key (that’s no partial dependency).

So for the given entities, there should be a column which is depends on the Primary Key. So here it can assume the entity "BED" which is depends on the Primary Key value “Patient”.

So, hence by this we can achieve the 2nd Normal Form.

3rd Normal Form:

In the 3NF, it should be same as the 2nd Normal Form and no column is depends on the non-key field of table (that’s no transitive dependency).

From the given entities, the entity “TEST” is dependent on the entity “TREATMENT” and it is not dependent on any other entities.

Thus, it has to move the entity “TEST” to another a new table keeping the entity “TREATMENT” as the primary key of that table.

Therefore, by performing this it can be formed as the 3rd Normal Form.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

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