
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)
- Need help writing the pseudocode for the findMin function with attachedarrow_forwardCreate a static function in C# where poachers appear and attempt to hunt animals. It gets the location of the closest animal to itself. Take account of that the animal also move too, so it should update the closest location (x, y) everytime it moves to a new location. Use winforms to show the movements of poachers.arrow_forwardCreate a static function in C# where poachers appear and attempt to hunt animals. It gets the location of the closest animal to itself. Take account of that the animal also moves too, so it should update the closest location (x, y) everytime it moves to a new location. Use winforms to show to movementsarrow_forward
- I have to develop an efficient parallel numerical integration program on a 2-D mesh but I'm struggling. And it has to be in Cstararrow_forwardAn employee is departing from the company you work for. Explain why it could be best practice not to delete their user account but to lock it instead.arrow_forwardthe nagle algorithm, built into most tcp implementations, requires the sender to hold a partial segment's worth of data (even if pushed) until either a full segment accumulates or the most recent outstanding ack arrives. (a) suppose the letters abcdefghi are sent, one per second, over a tcp connection with an rtt of 4.1 seconds. draw a timeline indicating when each packet is sent and what it contains.arrow_forward
- Just need some assistance with number 3 please, in C#arrow_forwardHow do we find the possible final values of variable x in the following program. Int x=0; sem s1=1, s2 =0; CO P(s2); P(s1); x=x*2; V(s1); // P(s1); x=x*x; V(s1); // P(s1); x=x+3; V(s2); V(s1); Ocarrow_forwardLab 07: Java Graphics (Bonus lab) In this lab, we'll be practicing what we learned about GUIs, and Mouse events. You will need to implement the following: ➤ A GUI with a drawing panel. We can click in this panel, and you will capture those clicks as a Point (see java.awt.Point) in a PointCollection class (you need to build this). о The points need to be represented by circles. Below the drawing panel, you will need 5 buttons: о An input button to register your mouse to the drawing panel. ○ о о A show button to paint the points in your collection on the drawing panel. A button to shift all the points to the left by 50 pixels. The x position of the points is not allowed to go below zero. Another button to shift all the points to the right 50 pixels. The x position of the points cannot go further than the You can implement this GUI in any way you choose. I suggest using the BorderLayout for a panel containing the buttons, and a GridLayout to hold the drawing panel and button panels.…arrow_forward
- If a UDP datagram is sent from host A, port P to host B, port Q, but at host B there is no process listening to port Q, then B is to send back an ICMP Port Unreachable message to A. Like all ICMP messages, this is addressed to A as a whole, not to port P on A. (a) Give an example of when an application might want to receive such ICMP messages. (b) Find out what an application has to do, on the operating system of your choice, to receive such messages. (c) Why might it not be a good idea to send such messages directly back to the originating port P on A?arrow_forwardDiscuss how business intelligence and data visualization work together to help decision-makers and data users. Provide 2 specific use cases.arrow_forwardThis week we will be building a regression model conceptually for our discussion assignment. Consider your current workplace (or previous/future workplace if not currently working) and answer the following set of questions. Expand where needed to help others understand your thinking: What is the most important factor (variable) that needs to be predicted accurately at work? Why? Justify its selection as your dependent variable.arrow_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





