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
Modern Database Management
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
- Question: Based on the given problem, create an algorithm and a block diagram, and write the program code: Function: y=xsinx Interval: [0,π] Requirements: Create a graph of the function. Show the coordinates (x and y). Choose your own scale and show it in the block diagram. Create a block diagram based on the algorithm. Write the program code in Python. Requirements: Each step in the block diagram must be clearly shown. The graph of the function must be drawn and saved (in PNG format). Write the code in a modular way (functions and the main part should be separate). Please explain and describe the results in detail.arrow_forward23:12 Chegg content://org.teleg + 5G 5G 80% New question A feed of 60 mol% methanol in water at 1 atm is to be separated by dislation into a liquid distilate containing 98 mol% methanol and a bottom containing 96 mol% water. Enthalpy and equilibrium data for the mixture at 1 atm are given in Table Q2 below. Ask an expert (a) Devise a procedure, using the enthalpy-concentration diagram, to determine the minimum number of equilibrium trays for the condition of total reflux and the required separation. Show individual equilibrium trays using the the lines. Comment on why the value is Independent of the food condition. Recent My stuff Mol% MeOH, Saturated vapour Table Q2 Methanol-water vapour liquid equilibrium and enthalpy data for 1 atm Enthalpy above C˚C Equilibrium dala Mol% MeOH in Saturated liquid TC kJ mol T. "Chk kot) Liquid T, "C 0.0 100.0 48.195 100.0 7.536 0.0 0.0 100.0 5.0 90.9 47,730 928 7,141 2.0 13.4 96.4 Perks 10.0 97.7 47,311 87.7 8,862 4.0 23.0 93.5 16.0 96.2 46,892 84.4…arrow_forwardYou are working with a database table that contains customer data. The table includes columns about customer location such as city, state, and country. You want to retrieve the first 3 letters of each country name. You decide to use the SUBSTR function to retrieve the first 3 letters of each country name, and use the AS command to store the result in a new column called new_country. You write the SQL query below. Add a statement to your SQL query that will retrieve the first 3 letters of each country name and store the result in a new column as new_country.arrow_forward
- We are considering the RSA encryption scheme. The involved numbers are small, so the communication is insecure. Alice's public key (n,public_key) is (247,7). A code breaker manages to factories 247 = 13 x 19 Determine Alice's secret key. To solve the problem, you need not use the extended Euclid algorithm, but you may assume that her private key is one of the following numbers 31,35,55,59,77,89.arrow_forwardConsider the following Turing Machine (TM). Does the TM halt if it begins on the empty tape? If it halts, after how many steps? Does the TM halt if it begins on a tape that contains a single letter A followed by blanks? Justify your answer.arrow_forwardPllleasassseee ssiiirrrr soolveee thissssss questionnnnnnnarrow_forward
- 4. def modify_data(x, my_list): X = X + 1 my_list.append(x) print(f"Inside the function: x = {x}, my_list = {my_list}") num = 5 numbers = [1, 2, 3] modify_data(num, numbers) print(f"Outside the function: num = {num}, my_list = {numbers}") Classe Classe that lin Thus, A pro is ref inter Ever dict The The output: Inside the function:? Outside the function:?arrow_forwardpython Tasks 5 • Task 1: Building a Library Management system. Write a Book class and a function to filter books by publication year. • Task 2: Create a Person class with name and age attributes, and calculate the average age of a list of people Task 3: Building a Movie Collection system. Each movie has a title, a genre, and a rating. Write a function to filter movies based on a minimum rating. ⚫ Task 4: Find Young Animals. Create an Animal class with name, species, and age attributes, and track the animals' ages to know which ones are still young. • Task 5(homework): In a store's inventory system, you want to apply discounts to products and filter those with prices above a specified amount. 27/04/1446arrow_forwardOf the five primary components of an information system (hardware, software, data, people, process), which do you think is the most important to the success of a business organization? Part A - Define each primary component of the information system. Part B - Include your perspective on why your selection is most important. Part C - Provide an example from your personal experience to support your answer.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