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
- My daughter is a Girl Scout and it is time for our cookie sales. There are 15 neighbors nearby and she plans to visit every neighbor this evening. There is a 40% likelihood that someone will be home. If someone is home, there is an 85% likelihood that person will make a purchase. If a purchase is made, the revenue generated from the sale follows the Normal distribution with mean $18 and standard deviation $5. Using @RISK, simulate our door-to-door sales using at least 1000 iterations and report the expected revenue, the maximum revenue, and the average number of purchasers. What is the probability that the revenue will be greater than $120?arrow_forwardQ4 For the network of Fig. 1.41: a- Determine re b- Find Aymid =VolVi =Vo/Vi c- Calculate Zi. d- Find Ay smid e-Determine fL, JLC, and fLE f-Determine the low cutoff frequency. g- Sketch the asymptotes of the Bode plot defined by the cutoff frequencies of part (e). h-Sketch the low-frequency response for the amplifier using the results of part (f). Ans: 28.48 2, -72.91, 2.455 KS2, -54.68, 103.4 Hz. 38.05 Hz. 235.79 Hz. 235.79 Hz. 14V 15.6ΚΩ 68kQ 0.47µF Vo 0.82 ΚΩ V₁ B-120 3.3kQ 0.47µF 10kQ 1.2k0 =20µF Z₁ Fig. 1.41 Circuit forarrow_forwarda. [10 pts] Write a Boolean equation in sum-of-products canonical form for the truth table shown below: A B C Y 0 0 0 1 0 0 1 0 0 1 0 0 0 1 1 0 1 0 0 1 1 0 1 0 1 1 1 1 0 1 1 0 a. [10 pts] Minimize the Boolean equation you obtained in (a). b. [10 pts] Implement, using Logisim, the simplified logic circuit. Include an image of the circuit in your report.arrow_forward
- Using XML, design a simple user interface for a fictional app. Your UI should include at least three different UI components (e.g., TextView, Button, EditText). Explain the purpose of each component in your design-you need to add screenshots of your work with your name as part of the code to appear on the interface-. Screenshot is needed.arrow_forwardQ4) A thin ring of radius 5 cm is placed on plane z = 1 cm so that its center is at (0,0,1 cm). If the ring carries 50 mA along a^, find H at (0,0,a).arrow_forward4. [15 pts] A logic function F of four variables a; b; c; d is described by the following K-map. Derive the fully minimized SOP logic expression form of F. cd ab 00 01 11 10 00 0 0 0 1 01 1 0 0 1 11 1 0 1 1 10 0 0 1 1arrow_forward
- 2. [20 pts] Student A B will enjoy his picnic on sunny days that have no ants. He will also enjoy his picnic any day he sees a hummingbird, as well as on days where there are ants and ladybugs. a. Write a Boolean equation for his enjoyment (E) in terms of sun (S), ants (A), hummingbirds (H), and ladybugs (L). b. Implement in Logisim, the logic circuit of E function. Use the Circuit Analysis tool in Logisim to view the expression, include an image of the expression generated by Logisimarrow_forwardHow would I go about creating this computer database in MariaDB with sql? Create a database name "dbXXXXXX" Select the database using the "use [database name]" command. Now you are in the database. Based on the above schema from Enrolment System database, create all the tables with the last 6 digits of "123456", then the table name for table Lecturer should be "123456_Lecturer". Refer to basic SQL lecture note to create table that has primary keys and Foreign Keys. Provide the datatype of each attributes. Add a column called "Department" with datatype "VARCHAR(12)" to the table "Lecturer". Shows the metadata of the updated "Lecturer" table. (Use Describe command) Drop the "Department" column from the table "Lecturer", and show the metadata of the updated "Lecturer" table. Insert three (3) data to each of the table in the tables created. Note: If you have foreign key issues, please disable foreign key constraints before inserting the data, see below SET FOREIGN_KEY_CHECKS=0;…arrow_forwardCSE330 Discrete Mathematics 1. In the classes, we discussed three forms of floating number representations as given below, (1) Standard/General Form, (2) Normalized Form, (3) Denormalized Form. 3. Consider the real number x = (3.395) 10 (a) (b) Convert the decimal number x into binary format up to 7 binary places (7 binary digits after decimal) Convert the calculated value into denormalized form and calculate fl(x) for m=4 Don't use any Al tool show answer in pen a nd paper then take pi ctures and sendarrow_forward
- Simplify the following expressions by means of a four-variable K-Map. AD+BD+ BC + ABDarrow_forwardCSE330 Discrete Mathematics 1. In the classes, we discussed three forms of floating number representations as given below, (1) Standard/General Form, (2) Normalized Form, (3) Denormalized Form. 2. Let ẞ 2, m = 6, emin = -3 and emax = 3. Answer the following questions: Compute the minimum of |x| for General and Normalized form (a) Compute the Machine Epsilon value for the General and Denormalized form. If we change the value of emax to 6 then how will it affect the value of maximum scale invariant error for the case of Normalized form? Explain your answer. show answer in pen a Don't use any Al tool nd paper then take pi ctures and sendarrow_forwardCSE330: Discrete Mathematics 1. In the classes, we discussed three forms of floating number representations as given below, (1) Standard/General Form, (2) Normalized Form, (3) Denormalized Form. Now, let's take, ẞ = 2, m = 3, emin = -2 and emax = 3. Based on these, answer the following: (a) (b) (c) (d) What are the maximum/largest numbers that can be stored in the system by these three forms defined above? (express your answer in decimal values) What are the non-negative minimum/smallest numbers that can be stored in the system by the denormalized form? (express your answer in decimal values) How many numbers (both non-negative and negative) can be represented in the above mentioned system using the general form? Explain your answer. Find all the decimal numbers for e = 3 and e = 2 in denormalized form, plot them on a real line and prove that all the numbers are not equally spaced. Write the equally spaced sets for the number line you drew. show your answer in Don't use any Al tool pen…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
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database 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 Learning