Concept explainers
Explanation of Solution
Database is the organized collection of associated data elements which is used to have the record the things or items of interest.
- It is often defined as the structure to hold the data.
- It contains the elements like schemas, views, tables (which are linked through foreign keys), queries and many other elements.
- Database and database management are interdependent.
Entity:
The basic block for building the data collected about person, place, event, or thing is called as entity.
- Entities denote attributes that can have many instances.
- Entity is about the gathering of the information about the place, person, or thing. For example: a patient, a musician, and so on.
- To locate the information in the entity, they have a name, short description about what they are and identifier.
- Identifiers are used to find each and every specific instance of an entity.
- So, it is the purpose of having identifiers with unique values.
Example:
The example of an entity is given below:
- STUDENT – the student is the person name that collects the details of student information. So the STUDENT acts as the entity.
- EMPLOYEE - the employee is the person name that collects the details of employee information. So the EMPLOYEE acts as the entity.
Attribute:
- The data are organized in tables, which consist of rows and columns is called as attributes.
- A data in a row or column of a table are called fields.
- In a database table, column fields are also referred as attributes of a database object.
- For example: In a customer table, “cust_id”, “cust_name”, “cust_addr” and “mobile_no” are the attributes.
Field:
- Relational database is a database, which organizes data according to the relational model as table and table consists of rows and columns.
- The table is also called data file.
- Group of related row is called record which is also called database object or entity.
- Often, the group of related column is called field.
- Group of records is called table.
Relational database:
- Relational database is a set of multiple data organized by tables, records, and columns and it creates the relationship between the database tables.
- The individual value in table provides the link from one table to another.
Storage of data in relational database:
- Relational database is a database which organizes data according to the relational model as table and table consists of rows and columns.
- A data in a row or column of a table is called fields.
- Fields in a database table are also referred as attributes of a database object.
- Group of related fields is called record which is also called database object or entity.
- Group of records are called table
- Storing data in relational database offers the following advantages:
- The data stored in this can be retrieved quickly and easily by the computer.
- The data stored in relational database can be displayed in any order.
- For example, to get information about songs from a music CD, the information about a particular artist, songs, and song title can be displayed individually in any order.
Role of Entity-relationship diagram in database:
An entity-relationship diagram represents the important elements of database in a graphical form.
- Entity-relationship (ER) diagram is the technique used to design the relational database.
- ER diagram is useful to create the data model, which serves business process. Additionally, the diagram ensures whether data is accurate, well-formed and easy for retrieval.
- An Entity-relationship diagram is represented in the graphical form that shows only important elements such as:
- Record types
- Attributes
- Relationship between entities
- For example, consider the following diagram:
- The rectangular box represents the entities such as Customer and Account.
- The oval symbol represents the attributes such as Firstname, Customer _id, Address, Username and Password.
- The diamond symbol represents the relationship between two entities.
- Here, it shows the one-to-one relationship between the Customer and Account.
- The relationship shows that one customer is allowed to access the one account.
- Here, it shows the one-to-one relationship between the Customer and Account.
Role of normalization in database:
Normalization is a process of dividing the tables by more than one idea into set of tables such that each and every table contains only one idea.
Nature and purpose of normalization process in database:
The nature and purpose of normalization process in database is given below:
- The normalization process helps to minimize the data redundancy and dependency in database.
- It is a method to remove all inconsistencies and bring the database to consistent state.
The normalization process obeys the following rules.
- Select the source of data and transform into an unnormalized table (UNF).
- Convert the unnormalized table into first normal form (1NF).
- Convert the first normal form data into second normal form (2NF).
- Convert the second normal form data into third normal form (3NF).
In some cases, the data in third normal form may be inconsistencies state. For this case, we may perform the following transformations. There are,
- Convert the third normal form data into Boyce-Codd normal form (BCNF).
- Convert the Boyce-Codd normal form data into fourth normal form (4NF).
- Convert fourth normal form data into fifth normal form (5NF).
Non-relational database management system:
- A non-relational database gives a
mechanism for storing and recovery of data that is modeled in means other than the tabular relationships used in relational databases. - The non-relational databases are gradually used in big data and real time web applications.
Difference between relational DBMS and non-relational DBMS:
Relational DBMS | Non-relational DBMS |
The relational DBMS works with structured data. | The non-relational DBMS works with semi-structured data. |
It supports joins. | It does not contain join, so it will work fast. |
The relationship in RDBMS via constraints. | It supports documents with different fields. |
It is built-in data integrity. | Huge data stores |
Want to see more full solutions like this?
Chapter 6 Solutions
Essentials of MIS (12th Edition)
- Please 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_forwardCreate 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_forward
- Change 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_forwardProblem 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_forward
- I 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_forwardExercise docID document text docID document text 1 hot chocolate cocoa beans 7 sweet sugar 2345 9 cocoa ghana africa 8 sugar cane brazil beans harvest ghana 9 sweet sugar beet cocoa butter butter truffles sweet chocolate 10 sweet cake icing 11 cake black forest Clustering by k-means, with preprocessing tokenization, term weighting TFIDF. Manhattan Distance. Number of cluster is 2. Centroid docID 2 and docID 9.arrow_forward
- Change the following code so that there is always at least one way to get from the left corner to the top right, but the labyrinth is still randomized. The player starts at the bottom left corner of the labyrinth. He has to get to the top right corner of the labyrinth as fast he can, avoiding a meeting with the evil dragon. Take care that the player and the dragon cannot start off on walls. Also the dragon starts off from a randomly chosen position public class Labyrinth { private final int size; private final Cell[][] grid; public Labyrinth(int size) { this.size = size; this.grid = new Cell[size][size]; generateLabyrinth(); } private void generateLabyrinth() { Random rand = new Random(); for (int i = 0; i < size; i++) { for (int j = 0; j < size; j++) { // Randomly create walls and paths grid[i][j] = new Cell(rand.nextBoolean()); } } // Ensure start and end are…arrow_forwardChange the following code so that it checks the following 3 conditions: 1. there is no space between each cells (imgs) 2. even if it is resized, the components wouldn't disappear 3. The GameGUI JPanel takes all the JFrame space, so that there shouldn't be extra space appearing in the frame other than the game. Main(): Labyrinth labyrinth = new Labyrinth(10); Player player = new Player(9, 0); Dragon dragon = new Dragon(9, 9); JFrame frame = new JFrame("Labyrinth Game"); GameGUI gui = new GameGUI(labyrinth, player, dragon); frame.add(gui); frame.setSize(600, 600); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setVisible(true); public class GameGUI extends JPanel { private final Labyrinth labyrinth; private final Player player; private final Dragon dragon; //labyrinth, player, dragon are just public classes private final ImageIcon playerIcon = new ImageIcon("data/images/player.png");…arrow_forwardMake the following game user friendly with GUI, with some simple graphics. The GUI should be in another seperate class, with some ImageIcon, and Game class should be added into the pane. The following code works as this: The objective of the player is to escape from this labyrinth. The player starts at the bottom left corner of the labyrinth. He has to get to the top right corner of the labyrinth as fast he can, avoiding a meeting with the evil dragon. The player can move only in four directions: left, right, up or down. There are several escape paths in all labyrinths. The player’s character should be able to moved with the well known WASD keyboard buttons. If the dragon gets to a neighboring field of the player, then the player dies. Because it is dark in the labyrinth, the player can see only the neighboring fields at a distance of 3 units. Cell Class: public class Cell { private boolean isWall; public Cell(boolean isWall) { this.isWall = isWall; } public boolean isWall() { return…arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education