Q&A Hero

Humanities

Q: Normalized design would place client's work, home, and cell phone numbers in a separate table together with the ClientID.
Q: More than one phone number in the Phone field of the JobClient table would violate 1NF.
Q: If a field contains more than one single value, the design is in violation of 2NF.
Q: Normal forms allow us to systematically detect duplicate data.
Q: Inserting new client information without an actual job assignment is possible in the normalized design.
Q: Inserting new client information without an actual job assignment is possible in the denormalized design.
Q: Inserting new client information into the JobClient table is possible without an actual job assignment.
Q: Updating DateStartTime field in JobClient table could cause the problem due to denormalized design.
Q: With normalized design, updating records is not a problem.
Q: Updating records could be a problem caused by denormalized design.
Q: Name field in JobClient table could be split into two single value fields.
Q: DateTimeStart field in JobClient table could be split into two single value fields.
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 TableThe JobClient table shown above is normalized.
Q: First normal form (1NF) states that fields must contain multiple values.
Q: There are six normal forms, with each of the lower normal forms encompassing the higher normal forms.
Q: Denormalized table designs contain duplicate data.
Q: Tables designed to be free of duplicate data are called association tables.
Q: Database normalization is about checking the accuracy of database design.
Q: In an ER diagram, two tables are connected by a __.
Q: More than one instance of an entity warrants a __ table.
Q: Tables are graphically represented as __ in an ER diagram.
Q: In a relational database, entities are represented as __.
Q: Which of the following is the foreign key in job table in a relationship with client table?a) Employee social security numberb) Job unique IDc) Client unique IDd) Client phone number
Q: Field value 5/23/2005 most likely belongs to which of the following? a) Employee birth date b) Job unique ID c) Job date d) Client unique ID
Q: Which of the following is an associative table? a) Client b) Employee c) Job d) QuickTax
Q: Which of the following is the most appropriate candidate for primary key in job table? a) Job unique ID b) Job date c) Job description d) Employee social security number
Q: Most appropriate data type for a client's phone number would be which of the following? a) CHAR(7) b) CHAR(13) c) NUMBER d) DATE
Q: Most appropriate data type for an employee's social security number would be which of the following? a) CHAR(5) b) NUMBER c) CHAR(11) d) DATE
Q: Which of the following is the most appropriate candidate for primary key in client table? a) Client unique ID b) Client phone number c) Client address d) Client email address
Q: Which of the following is the foreign key in job table in a relationship with employee table? a) Employee social security number b) Job unique ID c) Client unique ID d) Employee birth date
Q: The relationship between employees and clients is which of the following? a) One-to-one b) One-to-many c) Many-to-many d) Many-to-one
Q: The relationship between clients and jobs is which of the following? a) One-to-one b) One-to-many c) Many-to-many d) Many-to-one
Q: The relationship between employees and jobs is which of the following? a) One-to-one b) One-to-many c) Many-to-many d) Many-to-one
Q: Which of the following are employees attributes? a) Social security number b) Name c) Birth date d) All of the above
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.For questions 44 - 56, please refer to the preceding paragraph.Which of the following is an entity that belongs to this database?a) Client addressb) Job performedc) Employee named) QuickTax business
Q: Each field in a table takes values from a certain permissible set of values. This set is often referred to asa) data type.b) cardinality.c) foreign key.d) domain.
Q: Social security number is an example of a) char/text data type. b) number data type. c) date/time data type. d) primary key data type.
Q: The size of character (text) data type is measured in a) number of significant digits. b) number of decimal places. c) number of characters. d) number of words.
Q: Data type describes which of the following? a) The kind of information stored in a table b) The kind of information stored in a record c) The kind of information stored in a field d) The kind of information stored in a file
Q: Which of the following is an example of a primary key? a) Customer's last name b) Vehicle identification number c) Vendor's zip code d) Product's inventory level
Q: Child table must have a) its own primary key. b) a foreign key connecting it to the parent table. c) a common field with the parent table. d) all of the above.
Q: Each table must have a a) primary key. b) foreign key. c) parent key. d) child key.
Q: In a business, which one of the following is an example of an attribute? a) John's employment record b) All the employees c) Employee's addresses d) This week's orders
Q: In a relational database, entity attributes are represented as a) records. b) fields. c) tables. d) files.
Q: In a many-to-many relationship between two tables, a new table that must be placed in between them is called a(n) a) cardinality. b) relationship. c) association. d) link.
Q: Employees and their addresses is an example of a) one-to-one relationship. b) one-to-many relationship. c) many-to-many relationship. d) many-to-one relationship.
Q: Students registering for courses is an example of a) one-to-one relationship. b) one-to-many relationship. c) many-to-many relationship. d) many-to-one relationship.
Q: A customer placing orders is an example of a) one-to-one relationship. b) one-to-many relationship. c) many-to-many relationship. d) many-to-one relationship.
Q: In a relational database, each table has to connect to a) no other tables. b) at least one other table. c) at least two other tables. d) as many tables as possible.
Q: In a business, which one of the following is an example of an entity? a) Employees b) A company c) Business owner d) A CEO
Q: A table can represent which of the following? a) Persons b) Things c) Events d) All of the above
Q: In a relational database, entities are stored in a) files. b) tables. c) relationships. d) attributes.
Q: Social security number is the foreign key in job table for employee table.
Q: Job date is the primary key for job table.
Q: Employee names data type is CHAR(2).
Q: Phone number date type is NUMBER.
Q: Birth date data type is DATE.
Q: Social security number is the primary key for employee table.
Q: There is one-to-many relationship between employees and jobs.
Q: There is a one-to-many relationship between employees and clients.
Q: There are four entities that should be modeled in the ER diagram.
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.For questions 17 - 26, please refer to the preceding paragraph.Employee is an entity that should be included in the database.
Q: Primary key from parent table and foreign key from child table do not have to have the same data type.
Q: All values in a column must be of the same data type.
Q: Data type describes the kind of information stored in an attribute.
Q: Foreign key in a child table must be defined before the primary key in a parent table.
Q: Each child table must be connected to its parent table through a foreign key.
Q: Primary key can be duplicated in as many rows of a table as necessary.
Q: Each table must have an attribute that uniquely identifies each instance of the entity.
Q: Entity with a single attribute should be kept in a separate table.
Q: Each column in the table must have a unique name.
Q: The attributes of an entity become columns or fields in the table.
Q: Relationship between customer and product tables is typically one-to-many.
Q: One-to-many relationship between two tables is the most common type of relationship.
Q: A table can have no relationships with other tables in a multi-table database.
Q: Each entity is represented in an ER diagram as a box with a unique name.
Q: There can be only one instance of an entity in a table.
Q: A relational database handles entities such as persons, places or things by storing each entity in its own table.
Q: Draw all tables with the relationships and fields, primary and foreign keys (when necessary), and data types for each field.
Q: Draw all tables with the relationships and fields, indicating primary and foreign keys (when necessary) for each table.
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