
Explanation of Solution
Three components of
The three components of the database design are as follows:
- Tables
- When data are organized in rows and columns, it is called as table.
- Relationship
- The relationship laid between two tables are established using a row.
- Metadata
- Metadata gives information about other data or simply, it is a data about the data.
Normalization:
When an unstructured table is converted in a way to form one or more properly structured table is called as normalization.
Importance of the normalization:
The main purpose of normalization is to convert the unstructured table into structured table and the importances to perform normalization are as follows:
- Eliminate data redundancy.
- Isolating the data such that any changes made in the table does not affect other contents.
- Ensures proper data dependencies.
- Makes data to be consistent through the table.
Data integrity problem:
Data integrity problem arises when the accuracy and consistency of the data stored in the database is not maintained.
- Consider the information present in a table needs to be updated and that change should be reflected to the entire database contents and if the contents are not properly updated then the data integrity problem arises.
Consequence of data integrity problem:
The main consequence of the data integrity problem is that the data contents present in the table are not properly updated and any action that needs to be processed for that table and those contents can produce inconsistency in the results.
- The results obtained from that table will be incorrect and inconsistent.
Example table with data integrity problem:
Consider the below table named “Bank” with the necessary contents:
Table name: Bank
Name | Date_of_join | Branch_id | BranchName |
James | Mar 3,2014 | 101 | S1B |
Rita | Jan 22,2011 | 100 | MB |
Ron | Oct 2,2000 | 108 | S8B |
joules | Aug 21,2002 | 100 | MB |
Zita | Jan 22,2011 | 100 | MB |
Larry | Apr 2,2000 | 108 | S8B |
In the above the table, the name of the branch “MB” has to be changed to “MSB”:
Table name: Bank
Name | Date_of_join | Branch_id | BranchName |
James | Mar 3,2014 | 101 | S1B |
Rita | Jan 22,2011 | 100 | MSB |
Ron | Oct 2,2000 | 108 | S8B |
joules | Aug 21,2002 | 100 | MB |
Zita | Jan 22,2011 | 100 | MSB |
Larry | Apr 2,2000 | 108 | S8B |
In the above table, the highlighted content of the table is found to be improperly updated and will lead to data integrity problem. When the data of the account holders whose branch name of “MSB” needs to be counted but since the data has been improperly updated the count of the result produced will be incorrect and to avoid this kind of problem normalization is the best choice.
Normalization of a table:
The above table “Bank” is being normalized to avoid the data integrity problem and needs to be split into two tables to obtain data consistency in them.
Table name: Bank
Name | Date_of_join | Branch_id |
James | Mar 3,2014 | 101 |
Rita | Jan 22,2011 | 100 |
Ron | Oct 2,2000 | 108 |
joules | Aug 21,2002 | 100 |
Zita | Jan 22,2011 | 100 |
Larry | Apr 2,2000 | 108 |
Table name: NameofBranch
Branch_id | BranchName |
100 | MSB |
101 | S1B |
108 | S8B |
Therefore, from the above table, the redundancy of the data is being avoided, thus avoiding the inconsistency with the contents of the table...

Want to see the full answer?
Check out a sample textbook solution
Chapter 5 Solutions
Using MIS (10th Edition)
- I need help writing pseudocode for this function. The following pseudocode statement calls a function named half, which returns a value that is half that of the argument. (Assume both the result and number variables are Real.) Set result = half(number)arrow_forwardNeed help converting my pseudocode to python, AND have a flowchart showing everything!The code:Main Module Call InputModuleEnd Main Module Module InputModule // This module gets input from the user Declare Principal, AnnualRate, Years as Float Output "Enter the Principal amount (P): " Input Principal Output "Enter the Annual Interest Rate (in percentage, e.g., 5 for 5%): " Input AnnualRate Output "Enter the number of Years to repay the loan: " Input Years Call DisplayPayment(Principal, AnnualRate, Years)End Module Module DisplayPayment(Principal, AnnualRate, Years) // This module calculates and displays the monthly payment Declare R, N as Float Declare MonthlyPayment as Float Declare PowerFactor as Float // second local variable // Calculate monthly interest rate R and number of months N Set R = (AnnualRate / 100) / 12 Set N = Years * 12 // Calculate PowerFactor = (1 + R)^N Set PowerFactor = (1 + R) ^ N // Calculate…arrow_forwardWhats wrong with my pseudocode? Where did I make an error?Code: Module main() Declare Real mileage Call getMileage() Display “You’ve drive a total of “, mileage, “ miles End Module Module getMilage() Display “Enter your mileage: “ Input mileage End Modulearrow_forward
- I need help!! Writing a long pseudocode for a modular program that will display the monthly payment on a mortgage. P=Principal amount borrowed (loan)R=Rate of interest computed for each monthN=Number of months to pay back the loan or mortgageThe help I need is creating a module that you can input the principle, rate of percentage, and years to repay the loan, and another module "displaypayment" that accepts the 3 values and calculates the monthly payment needed for the rates. Lastly 2 local variables needed!Equation:Monthly Payment=[(R*(1+R)^N)/((1+R)^N-1)]*Parrow_forwardTwo pseudocode questions I need help with: How do I design a module called findSum that will display the sum of two integer passed by parameter, and a module called findArea that will display the area of a rectangle when passed 2 real values for the length and width of the rectangle?arrow_forwardFor the pseudocode module, what is displayed with the call findValue(1, 4, 2)?Module findValue(Integer a, Integer b, Integer c) Declare Integer value value = b + c - a Display valuearrow_forward
- I need help finishing my python rock paper scissors code, where it asks the user "rock, paper, scissors", the user types either option (repeatedly asks until its one of the three), and for a random option from the code to select also rock paper scissors. The end result would be you winning, code winning, or a tie.My code:import randomOPTIONS = ("ROCK", "PAPER", "SCISSOR") def getInput(): """ Function getInput() will receive and validate user input to be the string ROCK, PAPER, or SCISSOR. Input must be spelled correctly and in all capital letters. Function will return the validated input @return user input as ROCK, PAPER, OR SCISSOR """ #need help here def checkWinner(user, computer): """ Function checkWinner will accept 2 string parameters that must be unique values of ROCK, PAPER, or SCISSOR. Functions should return true if the string in parameter user beats the string in parameter computer in a game of rock…arrow_forwardI need help understanding how could I got the IP Address for the 1st Host on this Subnet, the IP Address for the Last Host on this Subnet & the Broadcast Address for this Subnet My Explanation:8 bits --> 17 & 0 128 64 32 16 | 8 4 2 1 0 0 0 1 0 0 0 1 -->17+ 0 0 0 0 0 0 0 0 --> 0 0 0 0 0 0 0 0 0 --> 0 (The Major (Base) Network Address): 142.20.33.0 To find the broadcast address, we can set all the bits in the host portion of the address to 1, which gives us 142.20.33.255. Based on the subnet mask 255.255.255.0, no bits were borrowed from the host portion, meaning 8 bits remain in the host portion. Using the formula 2^h – 2 (where h represents the number of host bits), we get 2^8 - 2 = 254 hosts. 8 bits --> 17 & 252 128 64 32 16 | 8 4 2 1 0 0 0 1 0 0 0 1 --> 17+ 1 1 1 1 1 1 0 0 --> 252 0 0 0 1…arrow_forwardWhich of the following opens when you click the launcher in the Size group on the Ribbon? Question 19Select one: a. Size dialog box b. Layout dialog box c. Width and Height dialog box d. Format dialog boxarrow_forward
- How do you resize a graphic object horizontally while keeping the center position fixed? Question 20Select one: a. Drag a side sizing handle. b. Press [Ctrl] and drag a side sizing handle. c. Press [Alt] and drag a side sizing handle. d. Press [Shift] and drag a side sizing handle.arrow_forwardWhich of the following indicates that a graphic is anchored to the nearest paragraph? Question 18Select one: a. X and Y coordinates b. An anchor symbol c. A paragraph symbol d. ruler marksarrow_forwardWhich command in the Adjust group allows you to change one picture for another but retain the original picture's size and formatting? Question 17Select one: a. Change Picture b. Replace c. Swap d. Relinkarrow_forward
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase 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 LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning





