Concept explainers
a.
Normalization:
The process used to minimize data redundancy and dependency in a relational
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 1st 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.
b.
Explanation of Solution
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:
c.
Explanation of Solution
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.
Normal form:
- The relation is in third normal form (3NF), since there is no transitive dependency and no repeated attributes...
Trending nowThis is a popular solution!
Chapter 6 Solutions
Database Systems: Design, Implementation, & Management
- Exercise 6 page 233 Given the dependency diagram shown in Figure Q6.6, answer Items 6a−6c. Identify and discuss each of the indicated dependencies. Create a database whose tables are at least in 2NF, showing the dependency dia- grams for each table. Create a database whose tables are at least in 3NF, showing the dependency dia- grams for each table.arrow_forwardGiven the dependency diagram: a.Identify and dicuss each of the indicated dependencies. b.Create a database whose tables are atleast in 2NF,showing the dependency diagram for each table. c.Create a database whose tables are atleast in 3NF,showing the dependency diagram for each table.arrow_forwardThe dependency diagram below indicates that authors are paid royalties foreach book that they write for a publisher. The amount of the royalty can vary by author,by book, and by edition of the book.Based on the dependency diagram, create a database whose tables are at least in 2NF,showing the dependency diagram for each table.arrow_forward
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning