Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Humanities
Q:
Plymouth Car Rental (PCR) started in with two compact cars and has expanded its fleet of vehicles with several sedans and trucks. When a customer books a rental, his/her age has to be at least 18 for compact cars and sedans, which are rented by the day and must be returned the following morning by 11 AM. Trucks are rented for a maximum of six hours. The owner requires a deposit on the reservation to be paid within seven days of booking. Vehicle records consist of the makes and types (Honda sedan), color, seating capacity, required deposit, rental rate and rental limit (in hours). Customer data consists of customer's names, addresses, phone numbers, and birth dates. Bookings identify the customer, vehicle, as well as the time rented and returned. There can be several payments up until the reservation date. Payments must reflect the payment status for each booking, including deposit, when the deposit was made, then each of the payments made, and when the entire payment was completed.In addition, PCR decided to reward their customers who refer other customers with gas coupons on their future rentals (which also servers the purpose of retaining those customers). Because the business is booming, PCR added several other vehicles, both trucks and sedans and wants to expand information gathered on these. In particular, PCR wants to track several truck-related attributes such as towing capacity and whether it has a snow plow or not. For the sedans, geared towards nature explorers, it wants to track the type and capacity of bike racks, and whether it has a canoe rack.For questions 82 - 86, please refer to the preceding paragraph.Describe the nature of recursive relationship in this case (if any) and discuss how it would be modeled in the ER diagram for this database.
Q:
If we could have a client with two tax returns that have an identical general portion and different specialized portion, this would be an example of the __.
Q:
The fact that the specialized part of the return retains the attributes of the general part is called __.
Q:
If client's type (based on ownership, for example) was determining the type of specialized portion of tax returns, this field would be called a ___.
Q:
The specialized part of a client's tax return that is specific for this particular group of clients is called a __ entity.
Q:
A tax return can have __ tax forms, and a tax form can appear in __ returns.
Q:
The relationship between a tax return and all of its component tax forms is a __ recursive relationship.
Q:
A set of tax forms used in building a tax return could be viewed as tax return's __.
Q:
In the consultant mentor and mentored relationship, employee/consultant table is both a __ table and a __ table.
Q:
The foreign key in employee/consultant table establishing the recursive relationship between consultant mentors and mentored would be denoted as __.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients. In addition, each of the consultants (employees) has a senior consultant as a mentor to help with some of the more challenging jobs and to evaluate employee's performance. In turn, a particular employee (consultant) that has a senior employee as a mentor, can be a mentor himself to a more junior employee. Further, each of the jobs the company deals with has some things that are in common, starting with ID, date/time started/ended, and so forth. Also, there are some tax forms that must be filed with every client, regardless of specifics of a business situation. On the other hand, there are some specific forms that apply to certain types of business situations, but are different or simply not required for other clients.For questions 72-81, please refer to the preceding paragraph.The recursive relationship between consultant mentors and mentored has a __ cardinality.
Q:
In equipment supertype and computer subtype example, the computer subtype is said to __ all the attributes of the equipment supertype.
Q:
Equipment supertype and its computer and printer subtypes is an example of __ specialization and __ rule.
Q:
Total specialization means that all instances of __ must also belong to at least one __ category.
Q:
Specialized entities with different attribute lists are often called __ entities.
Q:
The general entity that contains a list of common attributes is often called a __ entity.
Q:
Supertype/subtype hierarchies are also called __ hierarchies.
Q:
Generalization/specialization hierarchies are also called __ hierarchies.
Q:
Supervisor relationship is an example of a __ recursive relationship between a supervisor and his/her subordinates.
Q:
In a recursive relationship, the entity involved is both a __ and a __.
Q:
Bill of materials is an example of a __ recursive relationship between a product and its components.
Q:
A recursive relationship between a product and its components is called __.
Q:
Modeling many-to-many recursive relationships requires a(n) __ table.
Q:
Supervisor relationship is an example of a __ relationship between a __ and his/her __.
Q:
Relationship between an instance of an entity and another instance of the same entity is called a __ relationship.
Q:
Recursive relationship is a relationship between an __ of an entity and __ of that same entity.
Q:
Specialized portions of the tax return that are different for different types of clients would be called which of the following?a) General entityb) Subtype entityc) Supertype entityd) Sublime entity
Q:
The general portion of the tax return common to all the returns would be called which of the following?
a) Specialized entity
b) Subtype entity
c) Supertype entity
d) Sublime entity
Q:
The fact that all specialized portions of returns retain common set of attributes from a general portion of the return is known as which of the following?
a) Subset
b) Superset
c) Inheritance
d) Overlap
Q:
Having all client's tax returns belong to at most one specialized sub-type category would be an example of which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
Having all client's tax return belong to at least one specialized sub-type category would be an example of which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
Having some client's tax return that do not contain specialized attributes would be an example of which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
Viewing client's tax return with some common attributes and some specialized attributes, which of the following characterizations would be most accurate?
a) Partial specialization and disjoint rule
b) Partial specialization and overlap rule
c) Total specialization and disjoint rule
d) Total specialization and overlap rule
Q:
Recognizing that all the client's tax returns have some attributes in common, and that some are specific to the client's business situation (industry, ownership structure, etc.) would be represented in a database using which of the following?
a) One-to-many recursive relationship
b) Many-to-many recursive relationship
c) Supertype/subtype hierarchy
d) One table with a special field
Q:
Modeling the relationship between client's tax returns and tax forms requires which of the following?
a) Separating tax returns and tax forms into two tables
b) Listing all the required tax forms for a given return in a single table using several different fields
c) Listing all the required tax forms for a given return in a single table using a single additional field
d) Modeling this relationship does not require any action at all
Q:
The relationship between tax returns and tax forms used to build it can be viewed as which of the following?
a) One-to-many retroactive relationship
b) One-to-many recursive relationship
c) Many-to-many retroactive relationship
d) Many-to-many recursive relationship
Q:
For the employee (consultant) entity, which of the following is true?
a) Consultant is the parent but not the child entity.
b) Consultant is both the parent and the child entity.
c) Consultant is the child but not the parent entity.
d) Consultant is neither the parent nor the child entity.
Q:
Modeling consultant mentors and consultant being mentored requires which of the following?
a) Separating mentors and mentored into two separate tables
b) Another non-key Mentored? yes/no indicator field
c) Another foreign-key CONSULTANT$Mentored field
d) No action is needed to model this relationship.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients. In addition, each of the consultants (employees) has a senior consultant as a mentor to help with some of the more challenging jobs and to evaluate employee's performance. In turn, a particular employee (consultant) that has a senior employee as a mentor, can be a mentor himself to a more junior employee. Further, each of the jobs the company deals with has some things that are in common, starting with ID, date/time started/ended, and so forth. Also, there are some tax forms that must be filed with every client, regardless of specifics of a business situation. On the other hand, there are some specific forms that apply to certain types of business situations, but are different or simply not required for other clients.For questions 44-56, please refer to the preceding paragraph.The relationship between consultant mentors and mentored is an example of which of the following?a) One-to-many retroactive relationshipb) One-to-many recursive relationshipc) Many-to-many robust relationshipd) Many-to-many recursive relationship
Q:
Equipment supertype and its computer and printer subtypes are examples of which of the following?a) Partial specialization onlyb) Partial specialization and disjoint rulec) Total specialization and disjoint ruled) Partial specialization and overlap rule
Q:
The concept of inheritance means which of the following?
a) Any instance of a supertype inherits all the properties of the subtype.
b) Any instance of a supertype inherits some of the properties of the subtype.
c) Any instance of a subtype inherits all the properties of the supertype.
d) Any instance of a subtype inherits some of the properties of the supertype.
Q:
The case when an instance of the supertype may belong to more than one subtype category is called which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
The case when an instance of the supertype may belong to at most one subtype category is called which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
The case when all the instances of the supertype must belong to at least one of the subtype categories is called which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
The fact that some instances of the supertype do not have to belong to any of the subtypes is called which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
Q:
Which of the following is an example of a many-to-many recursive relationship?
a) Students and courses they are taking
b) Courses and their prerequisites
c) Products and their components
d) Orders and products that are purchased
Q:
Which of the following is an example of a one-to-many recursive relationship?
a) Students and courses they are taking
b) Courses and their prerequisites
c) Products and their components
d) Orders and products that are purchased
Q:
In a recursive relationship, which of the following is true of the entity involved?
a) The entity is the parent, but not the child.
b) The entity is the child, but not the parent.
c) The entity is both the parent and the child.
d) The entity is neither the parent nor the child.
Q:
Representing a many-to-many recursive relationship requires which of the following?
a) Additional table with a composite primary key that acts as a foreign key
b) Additional foreign key that is also a primary key in the same table
c) Additional table with a primary key, but without a foreign key
d) No additional table modification
Q:
Representing a one-to-many recursive relationship requires which of the following?
a) Additional table with a composite primary key that acts as a foreign key
b) Additional foreign key that is also a primary key in the same table
c) Additional table with a primary key, but without a foreign key
d) No additional table modification
Q:
Bill-of-materials relationship are (in general) an example of which of the following?
a) One-to-one relationship
b) One-to-one recursive relationship
c) Many-to-many relationship
d) Many-to-many recursive relationship
Q:
Supervisor relationship is an example of which of the following?
a) One-to-many relationship
b) One-to-many recursive relationship
c) Many-to-many relationship
d) Many-to-many recursive relationship
Q:
Student courses and their prerequisites is an example of which of the following?
a) One-to-many relationship
b) One-to-many recursive relationship
c) Many-to-many relationship
d) Many-to-many recursive relationship
Q:
In an example of supervisor relationship, the recursive relationship lies in which of the following?
a) Relationship between a particular employee and all of his/her supervisors
b) Relationship between a particular employee and another employee
c) Relationship between a particular supervisor and another supervisor
d) Relationship between a particular supervisor and all of his/her subordinates
Q:
In an example of students and course prerequisites, the recursive relationship lies in which of the following?
a) Relationship between a particular course and a particular student
b) Relationship between a particular student and a particular course
c) Relationship between a particular course and another course
d) Relationship between a particular student and another student
Q:
The relationship between an instance of an entity and another instance of the same entity is an example of which of the following?
a) Relative relationship
b) Recursive relationship
c) Robust relationship
d) Retroactive relationship
Q:
Supertype/subtype hierarchies are used to model situations where some instances of an entity are involved in relationships that other instances are not.
Q:
The general portion of the tax return inherits all the attributes of the specialized portion.
Q:
All clients having at most one specialized portion is an example of the overlap rule.
Q:
Having a client's tax return without a specialized portion is an example of partial specialization.
Q:
The general part of tax returns common for all clients is referred to as subtype entity.
Q:
The relationship between a client's tax return and all of its required tax forms is a many-to-many recursive relationship.
Q:
Mentor and mentored consultants should be kept in the same table with CONSULTANT$mentor as a foreign key drawing values from the primary key.
Q:
Senior consultant mentors and the more junior consultants that are being mentored should be separated in two different tables.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients. In addition, each of the consultants (employees) has a senior consultant as a mentor to help with some of the more challenging jobs and to evaluate employee's performance. In turn, a particular employee (consultant) that has a senior employee as a mentor, can be a mentor himself to a more junior employee. Further, each of the jobs the company deals with has some things that are in common, starting with ID, date/time started/ended, and so forth. Also, there are some tax forms that must be filed with every client, regardless of specifics of a business situation. On the other hand, there are some specific forms that apply to certain types of business situations, but are different or simply not required for other clients.For questions 17-26, please refer to the preceding paragraph.The relationship between consultant mentors and mentored is many-to-many.
Q:
The relationship between consultant mentors and mentored is an example of a recursive relationship.
Q:
Disjoint rule means that an instance of the supertype may belong to several subtype categories.
Q:
Partial specialization means that some instances of supertype do not belong to any of the subtype categories.
Q:
Subtype tables do not need copies of the primary key.
Q:
Discriminator is an attribute of the supertype entity.
Q:
Modeling generalization/specialization hierarchies involves one table with common attributes and additional tables for subtype attributes.
Q:
The best solution for supertype/subtype hierarchies is to just split the table into two or more tables, with data about each of the subtypes.
Q:
A family of products with a number of common attributes and a number of product-specific properties is an example of supertype/subtype hierarchy.
Q:
Storing hierarchical structure in a single table results in numerous empty cells.
Q:
Bill of materials is an example of a generalization/specialization hierarchy.
Q:
Generalization/specialization hierarchies are also called supertype/subtype hierarchies.
Q:
Storing bill of materials in a single table results in numerous empty cells.
Q:
Modeling many-to-many recursive relationships requires an additional table.
Q:
Modeling a one-to-many recursive relationship requires an additional table.
Q:
Supervisors and their subordinates are an example of relative relationship.