Concept explainers
Videos
Define each of the following terms:
- determinant
- functional dependency
- transitive dependency
- recursive foreign key
- normalization
- composite key
- candidate key
- normal form
- partial functional dependency
- enterprise key
- surrogate primary key
(a)
Definition of determinant
Explanation of Solution
Determinant is an attribute of the database table that is used todetermines the corresponding values of another column in the same table uniquely. As given in the definition any primary key attribute, candidate key attribute, or any non-prime attribute, non-candidate attribute can be a determinant. Consider the table given below:
| Employee_ID | Employee_name | Employee_salary |
| 101 | ram | 20000 |
| 102 | Shyam | 10000 |
| 103 | Rita | 30000 |
In the given table the employee_ID is considered as a determinant and it is also a prime key attribute here. as here, only employee_ID can identify the value of the other columns uniquely, whereas no other can.
(b)
Definition of functional dependency
Explanation of Solution
It helps in identifying the table attributes which are related and dependent to each other. For example: if there are two columns in the table A and B. Then the functional dependency between them is represented as:
A→B
Here, all the attribute in the column A is functionally dependent on B. Consider the table given below:
| Employee_ID | Employee_name |
| 101 | ram |
| 102 | Shyam |
| 103 | Rita |
Here employee_ID→employee_name
(As if we know the employee ID, then we definitely get the name of the employee), i.e., employee_ID is functionally dependent on employee_name
(c)
Definition of transitive dependency
Explanation of Solution
A dependency is to be transitive only if it is formed by two functional dependencies indirectly. Consider the relations given below:
A→B
B→C
Here, A is functionally dependent on B, and B is functionally dependent on C. As here, C is formed by the combination of two functional dependencies; hence, we can conclude that C is having transitive dependency. It only occurs when there are three or more attribute in a given relation. It helps us in normalizing the database in 3NF (i.e., 3 rd Normal Form)
(d)
Definition of recursive foreign key
Explanation of Solution
Foreign key is a key which represents the primary key attributes in the table. Recursive foreign key is a foreign key which refers to the primary key in the same table. Consider a scenario of table having details of employee and managers. Here, managers are also employees. In the column of employee ID the ID of all the employees are present. In the column of the manager ID, only some employees that are managers have their unique identity, and the rest is null. Here employee ID is not null, but the manger ID can be null, in the case of those employees which are not managers.
(e)
Definition of normalization
Explanation of Solution
Normalization is used to remove the redundancy (i.e., duplication and replication) and dependency of the data.it helps in making searching, sorting, indexing, retrieval of data, etc. easy. It also helps in increasing efficiency, accessibility of data. Type of normalization is given below:
- 1 NF
- 2 NF
- 3 NF
- Boycee Codd Normal Form
- 6 NF
(f)
Definition of composite key
Explanation of Solution
It is a combination of two or more columns in the table. It can be used to identify each row in the table uniquely. Here, when the candidate key is combined it must be unique; however, if it is taken individually then this it is not necessary to be unique. It is also known as concatenated key. Consider an example of student ID and class ID, here it is also possible that a student is enrolled in 2 or more subject. And a course ID is also associated with the more than one student ID. In case to identify the proper details of student with course ID, we need to use both values of course ID and the student ID i.e., candidate key.
(g)
Definition of candidate key
Explanation of Solution
An attribute or a combination of attribute that helps in identifying a row in relation.it value is not null and unique for attributes.it can be simple or composite key. There can be multiple candidate keys in the database, and it is also possibly that among that candidate key one is the primary key.
(h)
Definition of normal form
Explanation of Solution
Normal forms are given below:
- 1NF(First normal form )
- Second normal form
- Third normal form
- BCNF
- Fourth normal form
- 1 NF: table must follow the given properties for being in the first normal form:
- Second normal form: table must follow the given properties for being in the second normal form:
1. It should be in 1 NF
2. There is no partial dependency
- Third normal form: table must follow the given properties for being in the third normal form
- BCNF (Boyce Codd Normal Form): it is a upgraded version of the 3 NF.
- Fourth normal form: conditions are given below:
1. Attributes should be single valued.
2. Columns name must be unique
3. Here, ordering of data does not matter
1. it should be in 2 NF
2. There is no transitive dependency
1. Here, the given should be in 3 rd normal form
2. And for each functional dependency (X(Y) there should be a super key. >
1. It sould be in BCNF
2. And, there is no multivalued attribute.
(i)
Definition of partial functional dependency
Explanation of Solution
Partial functional dependency means that a non-prime attribute is functionally dependent on a part of a candidate key.
(j)
Definition of enterprise key
Explanation of Solution
The term enterprise key is given by expert developer to the prime key if it is unique for the whole database, and not only for a relation. And the concept of making the prime key more like as in the object-oriented environment is known as an object identifier.
(k)
Definition of surrogate primary key
Explanation of Solution
Surrogate primary key is developed to make the key structure easy. This key is developed for the purpose of data analysis. This key is not displayed to users. Surrogate primary key can be available when:
- There is a composite primary key.
- The natural primary key is inefficient.
- The natural primary key is recycled as there it needs to be unique every time.
Want to see more full solutions like this?
Chapter 4 Solutions
Pearson eText for Modern Database Management -- Instant Access (Pearson+)
Additional Engineering Textbook Solutions
Java How to Program, Early Objects (11th Edition) (Deitel: How to Program)
SURVEY OF OPERATING SYSTEMS
Problem Solving with C++ (10th Edition)
Starting Out With Visual Basic (8th Edition)
Degarmo's Materials And Processes In Manufacturing
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
- ut da Q4: Consider the LIBRARY relational database schema shown in Figure below a. Edit Author_name to new variable name where previous surname was 'Al - Wazny'. Update book_Authors set Author_name = 'alsaadi' where Author_name = 'Al - Wazny' b. Change data type of Phone to string instead of numbers. عرفنه شنو الحل BOOK Book id Title Publisher_name BOOK AUTHORS Book id Author_name PUBLISHER Name Address Phone e u al b are rage c. Add two Publishers Company existed in UK. insert into publisher(name, address, phone) value('ali','uk',78547889), ('karrar', 'uk', 78547889) d. Remove all books author when author name contains second character 'D' and ending by character 'i'. es inf rmar nce 1 tic عرفته شنو الحل e. Add one book as variables data? عرفته شنو الحلarrow_forwardAdd a timer in the following code. public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; private Timer timer; private long elapsedTime; public GameGUI(Labyrinth labyrinth, Player player, Dragon dragon) { this.labyrinth = labyrinth; this.player = player; this.dragon = dragon; String playerName = JOptionPane.showInputDialog("Enter your name:"); player.setName(playerName); elapsedTime = 0; timer = new Timer(1000, e -> { elapsedTime++; repaint(); }); timer.start(); } @Override protected void paintComponent(Graphics g) { super.paintComponent(g); int cellSize = Math.min(getWidth() / labyrinth.getSize(), getHeight() / labyrinth.getSize());}arrow_forwardChange the following code so that when player wins the game, the game continues by creating new GameGUI with the same player. However the player's starting position is same, everything else should be reseted. public static void main(String[] args) { Labyrinth labyrinth = new Labyrinth(10); Player player = new Player(9, 0); Random rand = new Random(); Dragon dragon = new Dragon(rand.nextInt(10), 9); JFrame frame = new JFrame("Labyrinth Game"); GameGUI gui = new GameGUI(labyrinth, player, dragon); frame.setLayout(new BorderLayout()); frame.setSize(600, 600); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.add(gui, BorderLayout.CENTER); frame.pack(); frame.setResizable(false); frame.setVisible(true); } public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; private Timer timer; private long…arrow_forward
- Create a menu item which restarts the game. Also add a timer, which counts the elapsed time since the start of the game level. When the restart is pressed, the restarted game should ask the player' name (in the GameGUI constructor) and set the score of player to 0 (player.setScore(0)), and the timer should restart again. And create a logic so that if the player loses his life (checkGame if the condition is false), then save this number together with his name into two variables. And display two buttons where one quits the game altogether (System.exit(0)) and the other restarts the game. public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; private final ImageIcon playerIcon = new ImageIcon("data/images/player.png"); private final ImageIcon dragonIcon = new ImageIcon("data/images/dragon.png"); private final ImageIcon wallIcon = new ImageIcon("data/images/wall.png"); private final ImageIcon…arrow_forwardPlease original work Analyze the complexity issues of processing big data What are five complexities and talk about the reasons they make the implementation complex. Please cite in text references and add weblinksarrow_forwardCreate a Database in JAVA Netbeans that saves name of the player and how many labyrinths did the player solve. Record the number of how many labyrinths did the player solve, and if he loses his life, then save this number together with his name into the database. Create a menu item, which displays a highscore table of the players for the 10 best scores public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; private void checkGameState() { if (player.getX() == 0 && player.getY() == labyrinth.getSize() - 1) { JOptionPane.showMessageDialog(this, "You escaped! Congratulations!"); System.exit(0); } if (Math.abs(player.getX() - dragon.getX()) <= 1 && Math.abs(player.getY() - dragon.getY()) <= 1) { JOptionPane.showMessageDialog(this, "The dragon caught you! Game Over."); System.exit(0); } } } public…arrow_forward
- Create a Database in JAVA OOP that saves name of the player and how many labyrinths did the player solve. Record the number of how many labyrinths did the player solve, and if he loses his life, then save this number together with his name into the database. Create a menu item, which displays a highscore table of the players for the 10 best scores. Also, create a menu item which restarts the game. public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; private void checkGameState() { if (player.getX() == 0 && player.getY() == labyrinth.getSize() - 1) { JOptionPane.showMessageDialog(this, "You escaped! Congratulations!"); System.exit(0); } if (Math.abs(player.getX() - dragon.getX()) <= 1 && Math.abs(player.getY() - dragon.getY()) <= 1) { JOptionPane.showMessageDialog(this, "The dragon caught you! Game Over.");…arrow_forwardChange the following code so that the player can see only the neighboring fields at a distance of 3 units. public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; private final ImageIcon playerIcon = new ImageIcon("data/images/player.png"); private final ImageIcon dragonIcon = new ImageIcon("data/images/dragon.png"); private final ImageIcon wallIcon = new ImageIcon("data/images/wall.png"); private final ImageIcon emptyIcon = new ImageIcon("data/images/empty.png"); public GameGUI(Labyrinth labyrinth, Player player, Dragon dragon) { this.labyrinth = labyrinth; this.player = player; this.dragon = dragon; setFocusable(true); addKeyListener(new KeyAdapter() { @Override public void keyPressed(KeyEvent e) { char move = switch (e.getKeyCode()) { case KeyEvent.VK_W -> 'W'; case…arrow_forwardQ/ Fill in the table below with the correct answers for the network devices and components required, then draw the topology diagram for the network of this three-story building: I want a drawing Cisco Packet tracer Ground Floor: This floor will house the main server room, reception area, and a few conference rooms. The server room should contain the core network devices that will connect the entire building. The reception area and conference rooms need network access require access for mobile devices for visitors and guests with devices. First Floor: This floor is dedicated to offices with workstations, each needing reliable network connectivity for staff computers, IP phones, IP camera, and printers. Second Floor (Education Department): This floor consists of educational spaces requiring controlled internet access. Only the educational website (https://uokerbala.edu.iq) should be accessible, with all other sites restricted.. Device Media type Location floor Type of IP Static/dynamic…arrow_forward
- Problem Statement You are working as a Devops Administrator. Y ou’ve been t asked to deploy a multi - tier application on Kubernetes Cluster. The application is a NodeJS application available on Docker Hub with the following name: d evopsedu/emp loyee This Node JS application works with a mongo database. MongoDB image is available on D ockerHub with the following name: m ongo You are required to deploy this application on Kubernetes: • NodeJS is available on port 8888 in the container and will be reaching out to por t 27017 for mongo database connection • MongoDB will be accepting connections on port 27017 You must deploy this application using the CL I . Once your application is up and running, ensure you can add an employee from the NodeJS application and verify by going to Get Employee page and retrieving your input. Hint: Name the Mongo DB Service and deployment, specifically as “mongo”.arrow_forwardI need help in server client project. It is around 1200 lines of code in both . I want to meet with the expert online because it is complicated. I want the server send a menu to the client and the client enters his choice and keep on this until the client chooses to exit . the problem is not in the connection itself as far as I know.I tried while loops but did not work. please help its emergentarrow_forwardI need help in my server client in C languagearrow_forward
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education