Q&A Hero

Humanities

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.
Q: First normal form (1NF) states that all fields must contain __ values only.
Q: Tables that are designed to contain duplicate data are called __ tables.
Q: Normalized designs place entities in __ tables.
Q: Tables that are designed to be free of duplicate data are called __ tables.
Q: Assuming the JobID is the primary key in JobClient table, which of the following normal forms is violated with respect to Name field.a) 1NFb) 2NFc) 3NFd) BCNF
Q: Assuming the JobID-ClientID is a primary key in JobClient table, which of the following normal forms is violated with respect to DateTimeStart field? a) 1NF b) 2NF c) 3NF d) BCNF
Q: Having multiple phone numbers in a Phone field violates which of the following normal forms? a) 1NF b) 2NF c) 3NF d) BCNF
Q: In tables with concatenated keys, which of the following normal form violation has a potential for occurring? a) 2NF b) BCNF c) 4NF d) All of the above
Q: Boyce-Codd Normal Form (BCNF) states which of the following? a) A part of the primary key may not determine a non-key field. b) A non-key field may not determine another non-key field. c) A part of a non-key field may not determine the primary key field. d) The primary key may not determine a non-key field.
Q: Having a part of CustomerID primary key come from customer's email address, violates which of the following normal forms? a) 1NF b) 2NF c) 3NF d) BCNF
Q: In the JobClient table, the presence of ClientID violates which of the following normal forms? a) 1NF b) 2NF c) 3NF d) 4NF
Q: Which of the following fields in JobClient table violates 3NF? a) JobID b) ClientID c) Name d) Phone
Q: Which of the following is the reason(s) ClientID field in the JobClient table violates 3NF? a) ClientID determines Name field. b) ClientID determines Phone field. c) ClientID determines both Name and Phone field. d) ClientID does not violate 3NF.
Q: After correcting 2NF error for JobClient table, which of the following would be true of the new table? a) ClientID would be the primary key and JobID the foreign key. b) ClientID would be the primary key and Phone the foreign key. c) JobID would be the primary key and ClientID the foreign key. d) JobID would be the primary key and Phone the foreign key.
Q: Correcting 2NF violation in JobClient table would involve which of the following? a) Just deleting one of the inconsistent records b) Creating Job table with a record for each job date/time c) Creating a Phone table with a record for each phone d) Doing nothing at all
Q: After correcting the 2NF violation, the primary keys would act as a) determinants. b) foreign keys. c) non-key fields. d) concatenations.
Q: JobID-ClientID is not a determinant for JobClient table because of which of the following records? a) Records with JobIDs 1 and 2 b) Records with JobIDs 3 and 4 c) Records with JobIDs 6 and 7 d) Records with JobIDs 10 and 11
Q: JobClient table violates 1NF on which of the following fields? a) Name b) Phone c) DateTimeStart d) DateTimeEnd
Q: Which of the following would be true of the new table with phone client's phone numbers? a) ClientID would be the primary key and Phone the foreign key. b) Phone would be the primary key and ClientID the foreign key. c) ClientID and Phone would combine to form a primary key. d) ClientID and Phone would combine to form a foreign key.
Q: Normalized design would do which of the following with the client's work, home, and cell phone numbers? a) Place them in another database on the database server. b) Place them in a separate table in the same database. c) Place them in separate fields in the same table. d) Keep all the phone numbers in a single field.
Q: Removing a record for a particular job in a normalized design would result in which of the following? a) Loss of the job information b) Loss of the client information c) Loss of both job and client information d) Loss of employee information
Q: Deleting the record with JobID 7 in the JobClient table would result in which of the following? a) Loss of the job information b) Loss of the client information c) Loss of the job and client information d) Loss of the employee information
Q: Inserting new client information into the JobClient table is not possible without specifying which of the following? a) JobID b) ClientID c) DateTimeStart d) DateTimeEnd
Q: When updating JobClient table, which of the following would not present a problem due to denormalized design? a) Updating ClientID field b) Updating Name field c) Updating Phone field d) Updating DateTimeStart field
Q: In normalized design of QuickTax database, changing Mountain Coffee's phone number would have to be done how many times exactly?a) Only onceb) Two timesc) As many times as there are old Mountain Coffee phone numbersd) The change would not be possible to make.
Q: Changing Mountain Coffee's phone number in the first record and failing to do the same in the ninth record is an example of which of the following? a) Insert problem b) Update problem c) Delete problem d) Typing problem
Q: Which of the following fields in JobClient table would most likely be split into two fields? a) ClientID b) Name c) Phone d) DateTimeStart
Q: Which of the following statements about foreign key in JobClient table is true? a) JobID is the foreign key. b) ClientID is the foreign key. c) Phone number is the foreign key. d) There is no foreign key.
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 which of the following?a) Normalizedb) Denormalizedc) Centralizedd) Decentralized
Q: First normal form (4NF) states which of the following?a) All fields must contain single values only.b) Part of the primary key may not determine a non-key field.c) A non-key field may not determine a non-key field.d) In an all-key table, part of the key can determine multiple values of, at most, one other field.
Q: First normal form (3NF) states which of the following? a) All fields must contain single values only. b) Part of the primary key may not determine a non-key field. c) A non-key field may not determine a non-key field. d) In an all-key table, part of the key can determine multiple values of, at most, one other field.
Q: First normal form (2NF) states which of the following? a) All fields must contain single values only. b) Part of the primary key may not determine a non-key field. c) A non-key field may not determine a non-key field. d) In an all-key table, part of the key can determine multiple values of, at most, one other field.
Q: First normal form (1NF) states which of the following? a) All fields must contain single values only. b) Part of the primary key may not determine a non-key field. c) A non-key field may not determine a non-key field. d) In an all-key table, part of the key can determine multiple values of, at most, one other field.
Q: Which of the following is true for duplicate data in the database? a) Errors occur when records are inserted. b) Errors occur when records are updated. c) Errors occur when records are deleted. d) All of the above.
Q: A multivalued determinant is a field or group of fields that determines multiple values of another field.
Q: 4NF applies to any database table.
Q: Boyce-Codd normal form (BCNF) a non-key field cannot determine a part of the primary key.
Q: 3NF violation can never present a problem when updating a record.
Q: 3NF states that none of the non-key fields can determine another non-key field.
Q: 2NF states that each non-key field must be determined by the whole primary key.
Q: 2NF violation can only occur on tables that have primary keys defined using a single field.
Q: In JobClient table, JobID-ClientID is a determinant.
1 2 3 … 391

Subjects

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