Q&A Hero

Q: Customer/order relationship is an example of a) one-to-one relationship. b) one-to-many relationship. c) many-to-many relationship. d) difficult relationship.

Q: In a one-to-many relationship, the crow's foot always points to the a) child table. b) parent table. c) sibling table. d) grandparents table.

Q: Crow's feet at both ends of the line represent which of the following? a) One-to-one relationship b) One-to-many relationship c) Many-to-many relationship d) Not a proper relationship representation

Q: A crow's foot at the single end of the line represents which of the following? a) One-to-one relationship b) One-to-many relationship c) Many-to-many relationship d) No relationship

Q: ER diagrams use which of the following as a symbol for a relationship? a) Diamond b) Triangle c) Box d) Line

Q: ER diagrams use which of the following as a symbol for an entity? a) Diamond b) Triangle c) Box d) Line

Q: Attributes (names, phone numbers, addresses) are like a) nouns. b) verbs. c) adjectives. d) sentences.

Q: Relationships (possessions) are like a) nouns. b) verbs. c) adjectives. d) sentences.

Q: Entities (persons, places, things) are like a) nouns. b) verbs. c) adjectives. d) sentences.

Q: Databases are designed as a group of related a) entities. b) attributes. c) relationships. d) fields.

Q: DBA is the person who a) runs the RDBMS. b) grants database access to end users. c) maintains the database using RDBMS. d) All of the above.

Q: SQL would be best described as doing which of the following? a) Allowing the end user to communicate with RDBMS b) Enabling the database to communicate with RDBMS c) Allowing RDBMS to communicate with the database administrator. d) Allowing the RDBMS to communicate with database server hardware.

Q: SQL stands for which of the following? a) Structured query language b) Simple query language c) Structured queuing language d) Simple query list

Q: RDBMS can be described as doing which of the following? a) Provides end user with unrestricted access to data and procedures b) Prevents authorized end users from accessing data and procedures c) Provides authorized end users with restricted access to data and procedures d) Provides unauthorized users with restricted access to data and procedures

Q: RDBMS stands for which of the following? a) Rational database management software b) Relational database management system c) Rapid database maintenance system d) Relational database management structure

Q: RDBMS can be best defined using which of the following? a) A software that runs on the Web server b) A software that runs on the mail server c) A software that runs on the database server d) A hardware on which the database resides

Q: In relational database, rows in a table are called a) tuples. b) fields. c) attributes. d) relations.

Q: In relational database, columns in a table are called a) tuples. b) fields. c) records. d) relations.

Q: In a relational database, tables are called a) tuples. b) fields. c) attributes. d) relations.

Q: Reports, such as order summary, are used for a) data input. b) result output. c) data formatting. d) data storage.

Q: Forms in Web pages, such as order forms, are used for a) data input. b) result output. c) data formatting. d) data storage.

Q: Which of the following describes the relationship between an end user and a database? a) End user has a direct access to a database. b) End user can never access a database. c) End user interacts with a database front-end program. d) End user can only interact with the database through a database administrator.

Q: Relational database is a part of a(n) a) relational system. b) information system. c) physical system. d) storage system.

Q: Object-oriented databases are easier to use than relational databases.

Q: Network database has physical pointers to connect related tables.

Q: Foreign key in the child table is defined over the same set of values as the primary key in the parent table.

Q: Foreign keys link the related records between parent and child tables.

Q: Email address satisfies all of the desired primary key properties.

Q: Two fields, longitude and latitude, together form a primary key for a location table.

Q: A primary key uniquely identifies each field in a table.

Q: Attribute and record are typically used interchangeably.

Q: Entity and table are typically used interchangeably.

Q: Crow's feet at the both ends of a line represent a many-to-many relationship.

Q: A crow's foot at the single end of a line represents a one-to-many relationship.

Q: Relationships in today's ER diagrams are modeled as lines.

Q: Entities in today's ER diagrams are modeled as diamonds.

Q: Relationships are verbs (possessions) such as customer places an order.

Q: Attributes are nouns (people, places, things) such as orders and customers.

Q: Entities are adjectives (name, address, phone number) that describe an attribute such as a customer.

Q: Database design is visually presented in the form of an entity-relationship diagram.

Q: A conceptual database model is a description of data that depends on the type of database software product.

Q: Database design is a model of the data items and their interrelationships.

Q: DBA stands for database authorization.

Q: Structured query language (SQL) is the command language used to communicate with the RDBMS.

Q: Relational database management system (RDBMS) is the software that runs on the Web server.

Q: In relational databases tables are called tuples.

Q: End users typically have a direct access to a database.

Q: Relational database is not a part of an information system.

Q: Information systems include people, policies, computers, and application software.

Q: Describe how shopping cart table is related to all the other tables in the database.

Q: Using the above Web screens, list all the fields in shopping cart table. Make sure to correctly identify the primary key.

Q: Using the above Web screens, list all the fields in the customer table. Make sure to correctly identify the primary key.

Q: According to the Web screens provided, describe how a typical transaction might occur.

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.Discuss why a database is important for Exposures retailer.

Q: Describe how the order table is related to all the other tables in the database.

Q: Using the above paragraph, list all the fields in the order table. Make sure to correctly identify the primary key.

Q: Using the above paragraph, list all the fields in the flower table. What would you use for the primary key?

Q: According to the above paragraph, describe how a typical transaction might occur.

Q: Jerry, the owner of Exotic Flower, 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.Discuss why a database is important for the Exotic Flower business.

Q: Describe how the bookings table is related to all the other tables in the database.

Q: Using the above paragraph, list all the fields in the customer table. What would you use for a primary key?

Q: Using the above paragraph, list all the fields in the vehicle table. What would you use for a primary key?

Q: According to the above paragraph, describe how a typical transaction might occur.

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 customers' 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.Discuss why a database is important for Plymouth Car Rental.

Q: Storing one client phone number in a client table and the same phone number in an employee table will cause ___.

Q: Storing one client address in a client table and another in a job table will cause _.

Q: Jobs table will probably have the following data items: __.

Q: According to the paragraph, employee table will have the following data items: _.

Q: According to the paragraph, client table will have the following data items: _.

Q: Clients, employees, and jobs are all examples of __, which will eventually become __ in QuickTax database.

Q: A unique JobID assigned to a particular job, would be designated as the job table __.

Q: Data on a date for a particular job, that was performed for a particular client by an employee would be stored in a __.

Q: Data on a particular job, performed for a particular client by an employee would be stored in a __.

Q: For years, QuickTax, Inc has helped small business manage their taxes. The management has 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 employees' 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.In a QuickTax database, all the information related to jobs would be stored in a _.

Q: _ servers provide data to the software that resides on __ servers.

Q: Applications servers hold application software that implements the __ of an organization.

Q: Web browser is an example of a software that performs __ processes.

Q: Multitier architecture that uses clients and servers for initiating requests and producing responses is also called a __ -tier architecture.

Q: Specialized type of computers processing requests and returning results are called __.

Q: Specialized type of computers that initiate requests and present results are called _.