Normalization: The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables. First normal form (1NF): If a table does not contain any replicate fields or groups of fields then that model is called as first normal form. In this form, entities do not contain any single instance of the repeating variable. It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected. Second normal form (2NF): The value of all non-primary key attributes should be dependent on the primary key attribute. If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity. The partial dependencies should be removed from the data model. Third normal form (3NF): The value of any non-primary key attributes will not depend on any other non-primary key attributes. If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted. It is termed as transitive dependency. Partial dependency: A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1 st normal form. Transitive dependency: A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key. Functional dependency: An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency. In a table one attribute is functionally dependent on another attribute to take one value.

Question

The dependency diagram indicates that authors are paid royalty for each book they write for a publisher.The amount of royalty can vary by author,by book ,and by edition of the book. a.Based on the dependency diagram,create a database whose tables are atleast in 2NF showing the dependency diagram for each table. b.Create a database whose tables are atleast in 3NF,showing the dependency diagram for each table.

Answer 1

Question

100%

Chapter 6, Problem 6RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

First normal form (1NF):

If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.

In this form, entities do not contain any single instance of the repeating variable.

It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected.

Second normal form (2NF):

The value of all non-primary key attributes should be dependent on the primary key attribute.

If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity.

The partial dependencies should be removed from the data model.

Third normal form (3NF):

The value of any non-primary key attributes will not depend on any other non-primary key attributes.

If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted.

It is termed as transitive dependency.

Partial dependency:

A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1^st normal form.

Transitive dependency:

A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key.

Functional dependency:

An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency.

In a table one attribute is functionally dependent on another attribute to take one value.

Explanation of Solution

b.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Explanation of Solution

c.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

Here, C1 indicate the primary key.

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Table2:

Create the database table with name of Table2 is given below:

Table2 (C1, C3, C4)

Here, C1 and C3 indicate the primary key and C1 indicates the foreign key that belongs to Table1 and C4 indicates the foreign key that belongs to Table3...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

The dependency diagram indicates that authors are paid royalty for each book they write for a publisher.The amount of royalty can vary by author,by book ,and by edition of the book. a.Based on the dependency diagram,create a database whose tables are atleast in 2NF showing the dependency diagram for each table. b.Create a database whose tables are atleast in 3NF,showing the dependency diagram for each table.

QUESTION 1 The dependency diagram in figure below indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book. Book royalty dependency diagram See attached for diagram Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.

The dependency diagram below indicates that authors are paid royalties for each book they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book. (10) a) Based on the dependency diagram above, create a database whose tables are at least in 2NF, showing the dependency diagram for each table. b) Create a database whose tables are in 3NF, showing the dependency diagram for each table. (8) (8)

Answer 2

Question

100%

Chapter 6, Problem 6RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

First normal form (1NF):

If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.

In this form, entities do not contain any single instance of the repeating variable.

It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected.

Second normal form (2NF):

The value of all non-primary key attributes should be dependent on the primary key attribute.

If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity.

The partial dependencies should be removed from the data model.

Third normal form (3NF):

The value of any non-primary key attributes will not depend on any other non-primary key attributes.

If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted.

It is termed as transitive dependency.

Partial dependency:

A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1^st normal form.

Transitive dependency:

A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key.

Functional dependency:

An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency.

In a table one attribute is functionally dependent on another attribute to take one value.

Explanation of Solution

b.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Explanation of Solution

c.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

Here, C1 indicate the primary key.

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Table2:

Create the database table with name of Table2 is given below:

Table2 (C1, C3, C4)

Here, C1 and C3 indicate the primary key and C1 indicates the foreign key that belongs to Table1 and C4 indicates the foreign key that belongs to Table3...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 3

Question

100%

Chapter 6, Problem 6RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

First normal form (1NF):

If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.

In this form, entities do not contain any single instance of the repeating variable.

It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected.

Second normal form (2NF):

The value of all non-primary key attributes should be dependent on the primary key attribute.

If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity.

The partial dependencies should be removed from the data model.

Third normal form (3NF):

The value of any non-primary key attributes will not depend on any other non-primary key attributes.

If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted.

It is termed as transitive dependency.

Partial dependency:

A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1^st normal form.

Transitive dependency:

A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key.

Functional dependency:

An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency.

In a table one attribute is functionally dependent on another attribute to take one value.

Explanation of Solution

b.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Explanation of Solution

c.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

Here, C1 indicate the primary key.

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Table2:

Create the database table with name of Table2 is given below:

Table2 (C1, C3, C4)

Here, C1 and C3 indicate the primary key and C1 indicates the foreign key that belongs to Table1 and C4 indicates the foreign key that belongs to Table3...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 4

Question

100%

Chapter 6, Problem 6RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

First normal form (1NF):

If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.

In this form, entities do not contain any single instance of the repeating variable.

It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected.

Second normal form (2NF):

The value of all non-primary key attributes should be dependent on the primary key attribute.

If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity.

The partial dependencies should be removed from the data model.

Third normal form (3NF):

The value of any non-primary key attributes will not depend on any other non-primary key attributes.

If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted.

It is termed as transitive dependency.

Partial dependency:

A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1^st normal form.

Transitive dependency:

A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key.

Functional dependency:

An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency.

In a table one attribute is functionally dependent on another attribute to take one value.

Explanation of Solution

b.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Explanation of Solution

c.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

Here, C1 indicate the primary key.

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Table2:

Create the database table with name of Table2 is given below:

Table2 (C1, C3, C4)

Here, C1 and C3 indicate the primary key and C1 indicates the foreign key that belongs to Table1 and C4 indicates the foreign key that belongs to Table3...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 5

Question

100%

Answer 6

Question

100%

Answer 7

Chapter 6, Problem 6RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

First normal form (1NF):

If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.

In this form, entities do not contain any single instance of the repeating variable.

It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected.

Second normal form (2NF):

The value of all non-primary key attributes should be dependent on the primary key attribute.

If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity.

The partial dependencies should be removed from the data model.

Third normal form (3NF):

The value of any non-primary key attributes will not depend on any other non-primary key attributes.

If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted.

It is termed as transitive dependency.

Partial dependency:

A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1^st normal form.

Transitive dependency:

A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key.

Functional dependency:

An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency.

In a table one attribute is functionally dependent on another attribute to take one value.

Explanation of Solution

b.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Explanation of Solution

c.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

Here, C1 indicate the primary key.

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Table2:

Create the database table with name of Table2 is given below:

Table2 (C1, C3, C4)

Here, C1 and C3 indicate the primary key and C1 indicates the foreign key that belongs to Table1 and C4 indicates the foreign key that belongs to Table3...

Answer 8

Chapter 6, Problem 6RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

First normal form (1NF):

If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.

In this form, entities do not contain any single instance of the repeating variable.

It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected.

Second normal form (2NF):

The value of all non-primary key attributes should be dependent on the primary key attribute.

If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity.

The partial dependencies should be removed from the data model.

Third normal form (3NF):

The value of any non-primary key attributes will not depend on any other non-primary key attributes.

If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted.

It is termed as transitive dependency.

Partial dependency:

A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1^st normal form.

Transitive dependency:

A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key.

Functional dependency:

An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency.

In a table one attribute is functionally dependent on another attribute to take one value.

Answer 9

Chapter 6, Problem 6RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

First normal form (1NF):

If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.

In this form, entities do not contain any single instance of the repeating variable.

It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected.

Second normal form (2NF):

The value of all non-primary key attributes should be dependent on the primary key attribute.

If any attribute is depending on the partial primary key then it should determine the other attributes for an instance of the entity.

The partial dependencies should be removed from the data model.

Third normal form (3NF):

The value of any non-primary key attributes will not depend on any other non-primary key attributes.

If any non-primary key attributes depend on any other non-primary key attribute then it should be moved or deleted.

It is termed as transitive dependency.

Partial dependency:

A partial dependency exists at that time of an attributes depends only a part of primary key. This dependency is related with 1^st normal form.

Transitive dependency:

A transitive dependency exists at that time of an attributes depends on another attribute which is not part of primary key.

Functional dependency:

An association between two attributes or two set of attributes in a same relational database table, which is having some constraints is known as functional dependency.

In a table one attribute is functionally dependent on another attribute to take one value.

Answer 10

Explanation of Solution

b.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Answer 11

Explanation of Solution

b.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Answer 12

Explanation of Solution

c.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

Here, C1 indicate the primary key.

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Table2:

Create the database table with name of Table2 is given below:

Table2 (C1, C3, C4)

Here, C1 and C3 indicate the primary key and C1 indicates the foreign key that belongs to Table1 and C4 indicates the foreign key that belongs to Table3...

Answer 13

Explanation of Solution

c.

Dependencies diagrams for each database table:

Table1:

Create the database table with name of Table1 is given below:

Table1 (C1, C2)

Here, C1 indicate the primary key.

C2 are partial dependent on C1.

Normal form:

The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes.

The representation of dependency diagram for table1 is shown below:

Table2:

Create the database table with name of Table2 is given below:

Table2 (C1, C3, C4)

Here, C1 and C3 indicate the primary key and C1 indicates the foreign key that belongs to Table1 and C4 indicates the foreign key that belongs to Table3...

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 17

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 18

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 19

Trending nowThis is a popular solution!

Answer 20

Trending nowThis is a popular solution!

Answer 21

Trending nowThis is a popular solution!

Answer 22

Trending now

Answer 23

This is a popular solution!

Answer 24

See solution

Check out sample textbook solution

Answer 25

Ch. 6 - Prob. 1RQ Ch. 6 - Prob. 2RQ Ch. 6 - Prob. 3RQ Ch. 6 - Prob. 4RQ Ch. 6 - Prob. 5RQ Ch. 6 - Prob. 6RQ Ch. 6 - Prob. 7RQ Ch. 6 - Prob. 8RQ Ch. 6 - Prob. 9RQ Ch. 6 - Prob. 10RQ

Solution Summary: The author explains normalization, which minimizes data redundancy and dependency in relational databases.

Concept explainers

Explanation of Solution

Explanation of Solution

Chapter 6 Solutions