Design

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 _.

Q: Hardware components of a network include __.

Q: The Internet uses a set of protocols called __.

Q: Large organizations use private networks to engage in __.

Q: The network, hardware, software and __ are four typical organizational system components.

Q: Organizational system components __ to make the business processes work properly.

Q: Organizational systems use __ to help the organization with its processes.

Q: A company's _ technology is at the core of its organizational system.

Q: A set of different information technologies comprises a company's _.

Q: Today's organizations are heavily dependent on __.

Q: Which one of the following is not likely to appear on Amazon's order screen.a) Customer nameb) Order detailc) Credit card infod) Item inventory

Q: Amazon's database probably has a) only few entities with few data items. b) only few entities with lots of data items. c) lots of entities with few data items. d) lots of entities with lots of data items.

Q: Storing one client phone number in a client table and the same phone number in an employee table will cause a) data redundancy. b) data inconsistency. c) data consistency. d) data integrity.

Q: Storing one client address in a client table and another in a job table will cause a) data redundancy. b) data inconsistency. c) data consistency. d) data integrity.

Q: Employee table in a QuickTax database will also include a) client's phone numbers. b) dates of various jobs. c) total billable hours. d) none of the above.

Q: All the information we want to store about QuickTax clients will become a a) record in a database. b) field in a database. c) table in a database. d) primary key in a database.

Q: Clients, employees, and jobs are all examples of a) people. b) records. c) entities. d) fields.

Q: In a QuickTax database, there are how many categories of data items? a) One b) Three c) Four d) Nine

Q: Employee name John Taylor would be an example of a a) field. b) record. c) table. d) data item.

Q: A list of QuickTax employee birth dates would be an example of a a) record. b) primary key. c) field. d) table.

Q: A list of QuickTax employee social security numbers would be an example of a a) record. b) primary key. c) file. d) table.

Q: Data on a particular QuickTax employee with social security number 123-45-6789, named John Taylor, and birth date 6/17/1983 would be an example of a a) record. b) primary key. c) field. d) table.

Q: For years, QuickTax, Inc. has helped small businesses 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 44 - 56, please refer to the preceding paragraph.In a relational database for QuickTax, data on all the clients would be stored in aa) record.b) field.c) table.d) primary key.

Q: Most of the e-business Web site content is stored on a(n)a) client computer.b) Web server.c) email server.d) database server.

Q: A database server can be best described with which of the following? a) Provides data to software that resides on application servers b) Requests data from programs that reside on application servers c) Sends data to network printers d) Receives and sends email messages to and from client computers

Q: Software implementing a set of business rules resides on the a) client computer. b) application server. c) database server. d) email server.

Q: An email program is an example of a software that does which of the following? a) Initiates request for incoming email b) Sends your email to appropriate address c) Stores all your deleted emails d) Sends emails to your inbox

Q: Client/system architecture is also known as which of the following? a) Two-tier architecture b) Three-tier architecture c) Computer architecture d) Network architecture

Q: In a client/server architecture, server is a computer that a) initiates requests for printing of a document. b) presents the content of a shopping cart. c) returns the data needed to display a Web page. d) performs the search of a local hard drive.

Q: In a client/server architecture, client is a computer that a) initiates requests and presents the results. b) processes requests and returns the results. c) retrieves the data needed to process the request. d) sends appropriate Web pages for display in the browser.

Q: Google uses which of the following type of computer to process a search? a) Client computer b) Web server c) Email server d) Database server

Q: The Internet uses which of the following communication protocols? a) HTTP (Hypertext Transfer Protocol) b) TCP/IP (Transmission Control Protocol /Internet Protocol) c) SMTP/POP (Simple Mail Transfer Protocol / Post Office Protocol) d) DBMS (Database Management System)

Q: Which of the following is an essential component of a communications network? a) WindowsNT operating system b) Dell's Power Edge server c) Fiber-optic cables d) Communications protocol

Q: Large organizations use private networks to engage in EDI, that stands for which of the following? a) Electronic Data Interchange b) Electric Data Insulation c) Electronic Data Information d) Easy Dynamic Interface

Q: Computer applications enable organizations to achieve which of the following? a) Hit required profit margins b) Replace workers with computers c) Streamline business processes d) Eliminate operational expenses

Q: A loan application process could be best described as which one of the following? a) Completely automated b) Partially computerized c) Entirely face-to-face d) Mostly arbitrary

Q: An online catalog merchant uses which of the following with its order process? a) Communications network b) Hardware and software c) Product list and pricing d) All of the above

Q: A company's organizational system core technology is(are) its a) Web pages. b) database system. c) fax machine. d) personal computer.

Q: Today's computer systems do which of the following? a) Produce all products and services b) Operate without human interference c) Enable companies to operate more efficiently d) Perform only routine and repetitive functions

1 2 3 … 68 Next »

Subjects