Concept explainers
Videos
Define each of the following terms:
- supertype
- subtype
- specialization
- entity cluster
- completeness constraint
- enhanced entity-relationship (EER) model
- supertype/subtype hierarchy
- total specialization rule
- generalization
- disjoint rule
- overlap rule
- partial specialization rule
- universal data model
(a)
Definition of supertype
Explanation of Solution
Supertype is an entity that has relationship with one or more subtypes and contains some common subtype attributes. For example, when we are designing a data model for the employee, then we can have employee as a supertype, and its attributes like salary employee and contracted employee are taken as subtype.
(b)
Subtype
Explanation of Solution
Subtypes are the subgroups of the supertype entities. Each subtype consists of some unique attributes and is different from each other. For example, when we are creating a data model for the employee details, here we have one supertype entity employee with many subtype entities like part time employee, full time employee, and salaried employee, etc.
(c)
Specialization
Explanation of Solution
It is an opposite approach of the generalization. It is used to break down the higher level of the entity into the subgroups of lower level entity. Specialization is used to identify the subset entity that is sharing some common and distinguished characters.
Example:
(d)
Entity cluster
Explanation of Solution
Entity cluster is a useful way to represent the data model for large and complex organization. Entity cluster is a collection of various entities that are combined to form one common entity. An entity can be considered as virtual in the entity cluster. These entities are developed with the purpose of the reliability and simplification of data. EER diagram of an entity cluster is given below:
(e)
Completeness constraints
Explanation of Solution
Completeness constraints are used to check that the supertype entity must have an occurrence of the subtype entity. It is basically used to check the common attributes among the supertype and the subtype. There are two types of completeness constraints:
- Partial specialization: In Partial specialization, it is not necessary that all the subtype and the supertype entities are related to each other totally. There might be some cases where a partial relationship between the entities is possible. It can be represented by using a single line. Consider the below given diagram.
- Total specialization: In total specialization, it is necessary that all the subtype and the supertype entities are related to each other totally. It can be represented by using a single line. Consider the below given diagram.
Here, a person has a license. Suppose we have 5 people among which only 2 have license and rest do not. Then, it is a case of partial specialization. Here, it not necessary that all the people have license, there might be some persons who do not possess a license.
Here, the license should always belong to a particular person, i.e., there is no license without a person. This is a case of total specialization.
(f)
Enhanced entity-relationship (EER) model.
Explanation of Solution
Enhanced entity-relationship (EER) model is the enhanced model form of entity relational data model. It is a higher-level conceptual model of the computer science that is used to develop the advance databases, complex software designs, and geographic information systems (GIS), etc. Enhanced entity-relationship (EER) model reflects the data properties and constraints more precisely. It also consists of all the concepts of the entity relation diagram, specialization, and generalization.
(g)
Supertype/subtype hierarchy.
Explanation of Solution
Supertype/subtype hierarchy is the structure in which the supertype and the subtype entities are leveled according to their order. This organization of data make the data more modular and easier to understand and use.
(h)
Total specialization rule
Explanation of Solution
Total specialization rule is used to ensure that every entity of the subtype belongs to the supertype entity, i.e., there must be no entity of superclass which is not belongs to the subtype.
(i)
Generalization.
Explanation of Solution
Generalization is a process of extracting common features from multiple entities source in order to create a new entity. it helps in reducing the size of schema. Generalization provide one entity from multiple entity. Bottom − up designing strategies are used in the Generalization.
In Generalization entity all the all higher-level entities have the lower level entity. There is no higher entity without the lower level entity.
(j)
Disjoint rules
Explanation of Solution
The disjoint rule specifies that the entity object of supertype can only be the member of any of the subtype. For example, let’s consider animal as a supertype. Then it can have subtype entities like dog, cat, etc., In disjoint rule, the supertype class animal can be associated with the dog or cat at one time. i.e., the animal can be either dog or cat.
(k)
Overlap rule
Explanation of Solution
In the overlap rule, the supertype can be associated with more than one subtype entities. For example, consider a supertype entity student that can be associated with many subjects like math, English, Hindi and many more.
(l)
Partial specialization rules
Explanation of Solution
Partial specialization rules allow that the entity of supertype must not always need to belong to the subtype entity. Consider a supertype entity vehicle having subtypes entities car and truck. Here motorcycle is also subtype of vehicles, but it is not specified as subtype in the data model. Thus, if a vehicle is a car, then it must appear in the object of car and if the vehicle is a truck, it must appear in the object of truck. But if the vehicle is a motorcycle, then it cannot appear in any of the subtypes.
(m)
Universal data model
Explanation of Solution
Universal data model can be used as a starting point for the data modeling project. It is also known as a data model pattern. Advantages of using the Universal data model:
- Project takes less time and efforts to develop as all the essential components and structures are already designed and need only to be customized according to the requirement.
- Data models of the existing database are easier to read by the data modeler and other data management experts, as it is based on the common components seen in the other situations.
Want to see more full solutions like this?
Chapter 3 Solutions
Pearson eText for Modern Database Management -- Instant Access (Pearson+)
Additional Engineering Textbook Solutions
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
Introduction To Programming Using Visual Basic (11th Edition)
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
Vector Mechanics for Engineers: Statics
- 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
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning