DATABASE SYSTEMS (LOOSELEAF)-W/MINDTAP
DATABASE SYSTEMS (LOOSELEAF)-W/MINDTAP
13th Edition
ISBN: 9781337761833
Author: Coronel
Publisher: CENGAGE L
bartleby

Concept explainers

Question
Book Icon
Chapter 6, Problem 7RQ

a.

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 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 (ISBN, BookTitle, Edition)

  • Here, “ISBN” indicates the primary key.
  • “BookTitle” and “Edition” are partial dependent on ISBN.

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 (BookTitle, Publisher)

  •  “BookTitle” are transitive dependent on “Publisher”.

Normal form:

  • The relation is in second normal form (2NF), because there is transitive dependency in this database table.

The representation of dependency diagram for table2 is shown below:

Table3:

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

Table3 (Author_Num, LastName)

  • Here, “Author_Num” indicate the primary key...

Blurred answer
Students have asked these similar questions
What are the two errors in my pseudocode?Module getAverage(Integer value1, Integer value2, Integer value3)                 Declare Integer average                 average = value1 + value2 + value3 / 3                 Display average            End Module
Where did I make an error in my pseudocode module???Code:Module main()                 Call raiseToPower(2, 1.5)            End main              Module raiseToPower(Real value, Integer power)                 Declare Real result                 Set result = value ^ power                 Display result            End raiseToPower
Why does my pseudocode not perform what I asked? Don't know whats wrong with it.// This program asks the user to enter a value             // between 1 and 10 and validates the input.             Declare Integer value                         // Get a value from the user.             Display "Enter a value between 1 and 10."             Input value               // Make sure the value is between 1 and 10.             While value < 1 AND value > 10                         Display "ERROR: The value must be between 1 and 10."                         Display "Enter a value between 1 and 10."                         Input value             End While
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning