Q&A Hero

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.

Q: Draw all tables with the relationships and field lists in each of the tables.

Q: Draw tables together with the relationships between them.

Q: Draw each of the tables with the appropriate table name.

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.

Q: Draw all tables with the relationships and field lists in each of the tables.

Q: Draw tables together with the relationships between them.

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.For questions 87-91, please refer to the preceding paragraph.Draw each of the tables with the appropriate table name.

Q: Draw all tables with the relationships, fields, primary and foreign keys, as well as the appropriate data type for all fields.

Q: Draw all tables with the relationships and fields, indicating primary and foreign keys (when necessary) for each table.

Q: Draw all tables with the relationships and field lists in each of the tables.

Q: Draw each of the tables with the appropriate table name.

Q: Plymouth Car Rental started 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 A.M. 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.For questions 82 - 86, please refer to the preceding paragraph.Draw each of the tables with the appropriate table name.

Q: The relationship between employee and client tables is __.

Q: The relationship between client and job tables is __.

Q: The relationship between employee and job tables is __.

Q: The foreign key in jobs table in relation to client table should be __.

Q: The most appropriate data type for employee's social security number would be _.

Q: The most appropriate data type for employee's birth date would be __.

Q: The foreign key in jobs table in relation to employee table should be_.

Q: The primary key for employee table should be __.

Q: Employee table is a __ table and job table is a __ table.

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 72 - 81, please refer to the preceding paragraph.Table representing jobs is an example of a(n) __ table.

Q: The maximum amount of information that can be stored in a field of particular data type is called its __.

Q: Data types of primary and foreign keys must be __.

Q: The type of information that can be stored in an attribute is specified by its _.

Q: The primary key of the parent table must be defined __ the foreign key in a child table.

Q: Each child table must have a __ that relates it to its parent table.

Q: Each record in a table is uniquely identified by a __.

Q: Entity attributes in table are represented as __.

Q: In a many-to-many relationship, a new __ table is created between the two tables.

Q: A relationship where one record in a primary table corresponds to one record in another table is called __ relationship.

Q: A relationship where several records in a primary table correspond to several records in another table is called __ relationship.

Q: A relationship where one record in a primary table corresponds to several records in another table is called __ relationship.

Q: List all foreign keys in appropriate tables.

Q: TimeCheckedOutOrderPlaced?List and/or construct primary keys for each of the tables.

Q: List all the attributes in shopping cart table.

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, go through each of the five ER design steps.List all the entities in Exposures database and describe their relationships with other entities.