What are stored attributes?
Click to see answer
Attributes whose values are actually stored in the database.
Click to see question
What are stored attributes?
Attributes whose values are actually stored in the database.
What is the definition of a relationship in the context of entities?
A relationship is an association among entities.
What is the relationship set between Students and Courses?
Takes.
What does Chapter 2 introduce?
Different data models used to represent the data of a database.
What are simple (or atomic) attributes?
Attributes that take a single and indivisible value for each entity.
What are derived attributes?
Attributes whose values are computed from other attributes.
Provide an example of a relationship between entities.
A student (s) takes a course (c).
What does the relationship 'Takes' represent?
It represents the association between students and the courses they enroll in.
What is the frequency of adding a new employee in the RBMS?
Low.
Give examples of simple attributes.
Emp#, GPA, Address (as a single character string).
What is the result of extensive discussions among employees, managers, system analysts, and database designers?
A requirements document.
What is the definition of specialization in data modeling?
Specialization is the process of defining a specialized entity set from a given entity set.
What is a relationship set?
All relationships of the same meaning among entities of a given set of entity sets.
What process is overviewed in Chapter 2?
The database design process.
What is an example of a binary 1-to-1 relationship?
Manages between Employees and Departments.
Give an example of a derived attribute.
Age from Birthdate.
Provide an example of how students are related to courses.
s1 takes c1, s1 takes c2, s2 takes c1.
What are composite attributes?
Attributes that take values that can be further divided into subparts.
How often should the inventory of a product be checked in the RBMS?
Medium.
What does IS_A semantics imply in specialization?
Every entity in a sub entity set is also an entity in the super entity set.
What type of document may be generated first in the RBMS development process?
An informal document.
Which model is covered in detail in Chapter 2?
The entity-relationship model.
What is an example of a unary 1-to-1 relationship?
Is_married_to on Persons.
What is the difference between IS_A hierarchy and no IS_A hierarchy in ER modeling?
IS_A hierarchy allows for specialization of entities, while no IS_A hierarchy does not.
How can annual salary be derived?
From monthly salary.
What is a strong entity?
An entity that can exist independently and can uniquely identify itself.
Provide examples of composite attributes.
Name (First_Name, Middle_Name, Last_Name) and Address (Street_Address, City, State, Zipcode).
What are generalization and specialization hierarchies referred to as?
IS_A hierarchies.
What is a super entity set in the context of generalization?
Students is a super entity set (supertype).
What is the frequency of making a purchase in the RBMS?
High.
When should a sub entity set be used?
When its entities have significant special features (attributes and relationships) not shared by other entities in the original entity set.
What is an example of a data model?
The Relational Data Model.
What is the purpose of using a super entity set in ER modeling?
To significantly simplify the ER diagram when sub entity sets share common properties.
What is an example of a sub entity set in ER modeling?
The TA entity set, which may have attributes specific to teaching assistants.
What are G_Students and UG_Students in relation to Students?
They are sub entity sets (subtypes).
What type of relationship is represented in the ER diagram?
Unary relationship.
What is the definition of an entity?
An object or concept that exists and is distinguishable.
What type of relationship is represented in the ER diagram?
Binary relationship.
What defines a key of an entity set?
A set of attributes that can uniquely identify every potential entity of the entity set and remains minimal.
What is a weak entity?
An entity whose existence depends on the existence of other (strong) entities.
What information is required for Clerk in the RBMS?
Employee id, Name (first and last), Address, Salary Rate, Hours.
What is the definition of generalization in the context of entity sets?
Generalization is the process of defining a generalized entity set from a given set of semantically related entity sets.
What does an IS_A hierarchy represent in ER modeling?
A relationship where a sub entity inherits attributes and relationships from a super entity.
What is a data model?
A tool used to specify real-world objects (entities), relationships among them, constraints on them, and their manipulation.
What is an example of an attribute of a relationship?
Orders.
What is the concept of generalization in data modeling?
It is the process of extracting shared characteristics from two or more classes to create a generalized superclass.
How do graduate and undergraduate students relate to courses in ER modeling?
Graduate/undergraduate students can take only graduate/undergraduate courses, illustrating specialization.
Where should grade information be stored in a relationship?
In the relationship between Students and Courses.
What does a super entity set contain?
All common attributes of sub entity sets.
What is an n-ary relationship in the context of ER diagrams?
A relationship among n entity sets E1, E2, ..., En.
What is the name of the unary relationship in the ER diagram?
is_married_to.
What does the notation (0, m) indicate in the relationship between Professors and Students?
A professor can advise zero or many students.
What are the key attributes of the 'Employees' table in the Relational Data Model?
Emp#, Name, Dept_Name.
What type of relationship is represented in the ER diagram involving Orders, Products, Projects, and Suppliers?
Ternary relationship.
When should a super entity set be considered in ER modeling?
When sub entity sets share significant common properties.
What is the minimality property in the context of keys?
If any attribute is removed from a key, the remaining attributes no longer form a key.
What are the attributes of the G_Students entity set?
Sid, Name, GPA, GRE.
Which entities are involved in the relationship example provided?
Products, Projects, Suppliers.
What details are included in the Manager information?
Employee id, Annual Salary, Position.
Can you give examples of entities?
A person, an organization, an airplane, a course.
What determines whether an entity is strong or weak?
The way the data is modeled.
What is database design?
The process of representing data related to a real-world application in a format that conforms to a data model and facilitates efficient access.
What are the subclasses in the generalization example provided?
G_Students and UG_Students.
What is the Inheritance Principle?
A sub entity set inherits all properties (all attributes and relationships) from the super entity set.
What is the cardinality of the relationship between Students and Courses?
(1, 6) for Students and (5, n) for Courses.
What does a one-to-one relationship represent in ER modeling?
Each entity in set A is related to exactly one entity in set B and vice versa.
What does the notation (1, 1) indicate in the relationship between Students and Professors?
Each student must be advised by exactly one professor.
What does a data model describe?
Real-world objects (entities), relationships, constraints, and manipulation.
What attributes are associated with the entity 'Persons' in the ER diagram?
SSN, Name, Age.
What does min_card represent in an n-ary relationship?
The minimum number of relationships in R an entity in Ei may participate in.
What is the cardinality between Orders and Products in the ternary relationship?
(1, m) - One Order can have many Products.
Is 'Sid' of Students a key?
It depends on whether 'Sid' can uniquely identify every student.
What is the difference between an IS_A hierarchy and no IS_A hierarchy?
An IS_A hierarchy involves inheritance of attributes, while no IS_A hierarchy does not.
What does the notation (1, m) signify in relationships?
It indicates a one-to-many relationship.
What are the key attributes of the 'Departments' table in the Relational Data Model?
Name, Location.
What product information is required in the RBMS?
Product#, Product Name, Quantity on Hand, Invoice Price, Sale Price.
What is the superclass in the generalization example?
Students.
What are the attributes of the UG_Students entity set?
Sid, Name, GPA, SAT.
What does the notation (1, 6) signify in the context of Students?
Each student can be enrolled in 1 to 6 courses.
What notation represents a one-to-many relationship in ER modeling?
RE (0, m) (0, 1).
What does the general connectivity format represent?
It indicates the range of relationships an entity can participate in.
What attributes are associated with the Professors entity?
Pid, Name, Age.
What is a requirement for employee identification in the RBMS?
Each employee must have a unique ID.
What does database design include?
Basic facts, relationships, and constraints related to a real-world application.
What does max_card represent in an n-ary relationship?
The maximum number of relationships in R an entity in Ei may participate in.
What is the cardinality of the relationship 'is_married_to'?
(0,1) for both sides.
What are the two properties of an entity?
It exists and it is distinguishable.
What is the cardinality between Orders and Projects in the ternary relationship?
(1, n) - One Order can be associated with many Projects.
What are the key components of a data model?
Entities, relationships, constraints, and manipulation.
Is 'Name' a key?
It depends on whether 'Name' can uniquely identify every entity in the set.
What does the Supply information indicate?
Which supplier supplies what products.
What does the notation (1, n) signify in relationships?
It indicates a one-to-many relationship as well, but with a different cardinality.
What does the notation (5, n) signify in the context of Courses?
Each course can have 5 to many students enrolled.
What type of relationship exists between entities E1 and E2 in a many-to-many relationship?
Each entity in E1 or E2 participates in zero or more relationships.
How is a many-to-many relationship represented in ER modeling?
RE (0, m) (0, n).
What is the relationship between G_Students and UG_Students?
They are semantically related entity sets used for generalization.
What attributes are associated with the Students superclass?
Sid, Name, and GPA.
What is the purpose of the Introduction section in a requirements document?
To state the objectives.
What is the domain of an attribute?
The set of values that an attribute can take on.
What attributes are associated with the Students entity?
Sid, Name, Age.
What are single-valued attributes?
Attributes that take a single value (simple or composite) for each entity.
What is the cardinality between Orders and Suppliers in the ternary relationship?
(0, r) - An Order may have zero or many Suppliers.
What is the general format for connectivity?
0 <= min_card <= max_card.
Is '(Sid, Name)' a key?
It depends on whether this combination can uniquely identify every student.
How is the connectivity of an entity set determined in an n-ary relationship?
By its minimum and maximum cardinality (min_card and max_card).
Who proposed the Entity-Relationship (ER) model?
Peter Chen in 1976.
What type of information is needed for Customer in the RBMS?
Customer information (specific details not provided).
What are the valid positions for managers in the RBMS?
Assistant manager, manager, senior manager.
What type of relationship is described as one-to-many?
A relationship where each entity of E1 participates in zero or more relationships while each entity of E2 participates in at most one relationship.
What determines the data model used in database design?
The DBMS (Database Management System) used to host the database system for the application.
What does the notation (0, 1) signify in a one-to-one relationship?
It indicates that an entity may or may not participate in the relationship.
What type of relationship does a ternary relationship provide?
More accurate information.
What does the notation (0, r) signify in relationships?
It indicates a zero-to-many relationship.
What is an identifying relationship in ER diagrams?
A relationship used to identify a weak entity set with its corresponding strong entity set.
What standardized tests are associated with the subclasses?
GRE for G_Students and SAT for UG_Students.
What does 'many-to-many' mean in the context of entity relationships?
It means that each entity can relate to multiple entities in the other set.
How is the domain of an attribute usually represented?
By a type.
What is the difference between an entity set and a relationship set in ER modeling?
An entity set represents a collection of similar entities, while a relationship set represents associations between entities.
In the context of entities, what does (min_card, max_card) signify?
The minimum and maximum number of relationships an entity can have.
Is '(Name, Home_addr, Birthdate)' of Students a key?
It depends on whether this combination can uniquely identify every student.
What are multi-valued attributes?
Attributes that take a set of values for each entity.
What should be described in the 'Information to be contained in the system' section?
Entities and relationships among them.
What does the Purchase information detail?
Who buys what from whom.
What are the two key portions of the Requirements Document used for conceptual design?
The 'Information to be contained' and 'Integrity constraints'.
In a one-to-many relationship, what does (0, m) indicate?
An entity in set A can be related to zero or many entities in set B.
What is an extension of the ER model?
Extended Entity-Relationship model (EER model).
What constraint is placed on customer purchases in the RBMS?
No customer can buy more quantity of a product than the quantity on hand.
What is the definition of the role of an entity set in a relationship?
The function it performs in the relationship.
What does Domain(A) represent?
The domain of attribute A.
What does the notation (x, y) represent in ER diagrams?
It represents the connection and connectivity between entities.
What does the notation R E (min_card, max_card) represent?
It shows the relationship R between entity E with specified cardinality.
What can be incorrectly derived from binary relationships?
(s2, p2, j1).
What is the maximum number of skills an engineer can use for any given project?
At most one skill.
In a one-to-many relationship, how many relationships can an entity from E1 participate in?
Zero or more relationships.
In the context of ER modeling, what does CAB stand for?
Customers, Accounts, Banks.
Give an example of a multi-valued attribute.
Authors of Books.
How can the role of an entity set be determined?
From properly chosen names.
What is an example of a data model?
The Object-Oriented Data Model.
What does the example (1, 5) (5, 60) indicate?
Students can participate in 1 to 5 relationships, while Courses can participate in 5 to 60 relationships.
What is the cardinality of the relationship between Customers and Accounts?
(1, m), meaning one customer can have many accounts.
What is an example of a domain for an attribute 'Sid'?
char(9) – character string of length 9.
What is the purpose of an identifying relationship?
To establish a link between a weak entity set and its strong entity set.
What is the purpose of the dedicated International Conference on ER Approach?
It focuses on Conceptual Modeling.
What does the IS_A hierarchy represent in this context?
It represents the relationships between different categories of students and their attributes.
What is the relationship between Skills and Projects in the ER model?
Skills (1, m) to Projects (1, r).
What is the primary objective of the Retail Business Management System (RBMS)?
To allow clerks to check product inventory and sales discount information.
What is a requirement regarding suppliers' contact information in the RBMS?
Different suppliers must have different telephone numbers.
What is the purpose of the 'Transaction information' portion of the Requirements Document?
To create indexes and to design programs.
What are integrity constraints in a requirements document?
All constraints to be enforced.
What are the components involved in the ternary relationship example?
supply, supply_to, and uses.
In a one-to-many relationship, how many relationships can an entity from E2 participate in?
At most one relationship.
In the relationship between Students and Courses, what does 'is_TA_of' represent?
It indicates the role of students as teaching assistants for courses.
What is the cardinality of the relationship between Banks and Accounts?
(1, n), meaning one bank can have many accounts.
What does 'Name varchar(30)' signify?
A character string of variable length up to 30 characters.
What are the two types of students mentioned in the hierarchy?
GRE Students and UG Students.
What is the relationship between Projects and Engineers in the ER model?
Projects (1, n) to Engineers participates (1, m).
What is a relationship set in the context of entity sets?
A relationship set R among entity sets E1, E2, ..., En.
What does the notation (0, 2) signify in the context of Students?
It indicates that a student can be associated with 0 to 2 courses.
What are the main entities in the Object-Oriented Data Model?
Employees and Departments.
What common attributes do all students share in this hierarchy?
id, Name, GPA.
What type of data does 'Age number' represent?
A number.
What has the ER model become in terms of conceptual schema design?
The de facto standard tool.
What is the cardinality of the relationship between Accounts and Banks?
(1, 1), meaning each account is associated with exactly one bank.
What information is provided in the Transactions section of a requirements document?
Operations to be supported and their estimated frequencies.
What additional capabilities do authorized managers have in the RBMS?
They can check sales statistics, order products, and hire/fire employees.
Why might the Requirements Document be revised?
Due to problems encountered in the later phases of database design.
What does it mean for an entity e1 in E1 to participate in a relationship R?
It means that a relationship in R contains e1.
What does the notation (1, m) signify in the context of ER modeling?
It indicates a one-to-many relationship.
What is the input required for making a purchase in the RBMS?
Product ID, customer ID, quantity, etc.
What are attributes in the context of an entity set?
The properties of an entity set.
What is an example of a data model?
The Hierarchical Data Model.
What does the notation (1, 6) signify in the context of Courses?
It indicates that a course must be associated with 1 to 6 students.
What attributes are associated with Accounts in the ER model?
Acct# and Balance.
What additional attributes are associated with GRE Students?
Salary and Rank.
What is the purpose of conducting surveys of potential users in requirement collection?
To gather information about static structuring requirements.
Are the terms 'relationship' and 'relationship set' used interchangeably?
Yes, they are often used interchangeably.
What attributes are associated with the Employee entity?
Emp#, Name, Department.
What does the notation (1, n) signify in the context of ER modeling?
It indicates a one-to-many relationship as well, but with a different cardinality.
What type of relationship is characterized by many-to-many connectivity?
Many-to-many (m-to-m) relationship.
Who can check product inventory in the RBMS?
Clerks of the business.
What does connectivity in a relationship specify?
The mapping between the entity sets participating in the relationship.
What do the notations (5, n) and (0, m) represent in the relationship?
They represent the cardinality constraints for the relationship between Students and Courses.
What is the expected outcome of a successful purchase in the RBMS?
The customer purchases the product of the right quantity, and the total cost along with the time/date are displayed.
What are some examples of attributes for the entity set 'Students'?
Sid, Name, Address, GPA, Status.
In the Hierarchical Data Model, what are the main components?
Departments and Employees.
What is a multivalued attribute in an ER diagram?
An attribute that can have multiple values for a single entity.
What is the highest level in the IS_A hierarchy?
Persons.
What is the first phase of database design?
Requirement collection and analysis.
Can multiple relationships exist among the same set of entity sets?
Yes, several relationships may exist among the same set of entity sets.
What type of information needs to be identified during requirement collection?
What information needs to be present.
What is one of the data models that has been developed?
The Entity-Relationship Model (ER Model).
What attributes are associated with the Department entity?
Name, Location.
What is a relationship in the context of entity sets?
A relationship R is between entity sets E1 and E2, where every entity in E1 or E2 participates in R.
What are dynamic processing requirements?
Requirements that specify how the database will handle various transactions and queries.
What is the suitable way to handle grade information in a relationship?
Attach the grade information with the relationship.
What is an example of a binary many-to-many relationship?
The relationship between Students and Courses.
What happens if the product ID or customer ID is incorrect during a purchase?
The purchase will fail.
What is a one-to-one (1-to-1) relationship?
A relationship where for each entity in E1, there is at most one associated entity in E2, and vice versa.
What type of information can clerks access in the RBMS?
Product inventory and product sales discount information.
What are some examples of attributes for the entity set 'Books'?
Title, ISBN, Authors, Publisher, Year.
