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
Design
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.
Q:
Students taking courses and satisfying course prerequisites is an example of recursive relationship.
Q:
An instance of an entity may be related to another instance of the same entity.
Q:
Discuss how the violation of 4NF might potentially occur in this example.
Q:
Discuss how the violation of BCNF might potentially occur in this example.
Q:
Discuss how the violation of 3NF might potentially occur in this example.
Q:
Discuss how the violation of 2NF might potentially occur in this example.
Q:
Exposures is a specialty retailer of fine gifts, picture frames, albums, scrapbooks, as well as occasional gift ideas. Visit their Web site at www.exposureonline.com, and using the registration, billing, catalog, and shopping cart screens below, discuss the possibility of normal design violations in the questions below.Discuss how the violation of 1NF might potentially occur in this example.
Q:
Discuss how the violation of 4NF might potentially occur in this example.
Q:
Discuss how the violation of BCNF might potentially occur in this example.
Q:
Describe 3NF violation and how to redesign the table to correct it.
Q:
Describe 2NF violation and how to redesign the table to correct it.
Q:
Jerry, the owner of Exotic Flower's Inc., built a small greenhouse to store several types of exotic flowers that he purchases from wholesale suppliers around the world. Each exotic flower Jerry buys and resells falls into one of several flower groups that differ with respect to their storage needs, duration, time in bloom, price, etc. Each of the orders placed by customers specifies the type of exotic flower, the supplier it came from, the date of order, expected delivery date, flower condition on delivery, as well as the quantity ordered. Customer's data contain all the standard information needed to collect payment and deliver the flowers. Describe 1NF violation and how to redesign the table to correct it.
Q:
Discuss how the violation of 4NF might potentially occur in this example.
Q:
Discuss how the violation of BCNF might potentially occur in this example.
Q:
Describe 3NF violation and how to redesign the table to correct it.
Q:
Describe 2NF violation and how to redesign the table to correct it.
Q:
Describe 1NF violation and how to redesign the table to correct it.
Q:
BCNF violations can occur in only in tables with a __key.
Q:
In an all-key table, part of the key can determine multiple values of at most __ field(s).
Q:
BCNF violation occurs when a __ field determines __.
Q:
3NF violation occurs when a __ field determines another __ field.
Q:
In the JobClient table, __ field violates 3NF.
Q:
Correcting 2NF violation would remove ambiguity regarding clients __.
Q:
2NF violation in JobClient table exists in records with JobID __.
Q:
In the JobClient table, JobID-ClientID is not a determinant because of the resulting ambiguity in the __ field.
Q:
Phone field values with more than one phone number in JobClient table violate __ normal form.
Q:
Normalized design would place client's work, home, and cell phone numbers in a __, together with the ClientID.
Q:
In JobClient table, 1NF is violated by __ field.
Q:
In a normalized design, deleting a record for a particular job would affect __ fields.
Q:
Deleting a record for a job with ID 7 in JobClient table would also remove all the information on __.
Q:
When inserting new client information into the JobClient table, without a particular job assignment, you must specify __ field.
Q:
Changing Mountain Coffee's phone number only in the first record of the JobClient table would lead to __ data.
Q:
When changing Mountain Coffee's phone number in a table with normalized design, you would have to change the phone number exactly __.
Q:
Changing Mountain Coffee's phone number only in the first record of the JobClient table would create an __ problem.
Q:
__ columns in JobClient table contain duplicate data.
Q:
The lack of foreign keys is seen as an __ of normalized designs.
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. JobClient table design is referred to as __ design.
Q:
Third normal form (3NF) states that a __ field may not determine another __ field.