Archives

There is a one-to-many relationship between employees and clients. 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 […]

In Microsoft SQL Server, __ are constraints that can be applied to restrict values in a column. In Oracle, the statement used to retrieve all of the client’s contacts and emails would be __. Answer: Select_contact, email From_client In Oracle, […]

Correcting 2NF violation would remove ambiguity regarding clients __. Organizational system components __ to make the business processes work properly. Answer: must work together Third normal form (3NF) states that a __ field may not determine another __ field. Answer: […]

All of the table maintenance activities performed with DetailsView control can be accomplished with GridView control except __ records. Using the above Web screens, list all the fields in shopping cart table. Make sure to correctly identify the primary key. […]

Selection, projection, and joining are the three core data retrieval operations for relational databases. Database design is visually presented in the form of an entity-relationship diagram. Answer: True For years, QuickTax, Inc. has helped small businesses manage their taxes. The […]

3NF states that none of the non-key fields can determine another non-key field. Web browser is an example of a software that performs server processes. Answer: False GridView server control is used to display data in the form of a […]

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. […]

In Oracle, the statement used to display client emails and contacts, together with job dates and times, for the jobs that start at either 8 A.M. or 10 A.M., would be _. Storing one client phone number in a client […]

In Oracle, saved scripts are retrieved using __ button. Supertype/subtype hierarchies are also called __ hierarchies. Answer: generalization/ specialization Organizational systems use __ to help the organization with its processes. Answer: computer applications The server control used to access an […]

Describe how shopping cart table is related to all the other tables in the database. In Microsoft Access, the relationship between two tables is established by dragging the __ from the __ table onto the __ in the __ table. […]

Discuss how the violation of BCNF might potentially occur in this example. Using the above paragraph, list all the fields in the order table. Make sure to correctly identify the primary key. Answer: Order table fields: OrderID (primary key), FlowerID, […]

Network database has physical pointers to connect related tables. In relational databases tables are called tuples. Answer: False A relational database handles entities such as persons, places or things by storing each entity in its own table. Answer: True DateTimeStart […]

Complex Where clauses typically involve several conditions and use which of the following logical operators? a) +, -, *, / b) =, <, >, <=, >=, != c) And, Or d) Like, Unlike Query Builder helps us delete an existing […]

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. […]

In a relational database, tables are called __. In Microsoft Access, a long distance phone number field stored in __ data type would need at least __ characters. Answer: Text,10 Tables that are designed to contain duplicate data are called […]

The command used to verify that all the data was properly inserted is which of the following? a) Insert b) Describe c) Select d) Commit Which of the following best describes the process of creating a database In Microsoft SQL […]

Draw tables together with the relationships between them. 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 […]

In Oracle, after all the data has been inserted into the client table, the script line used to check that the correct data was entered, would be: __. Recursive relationship is a relationship between an __ of an entity and […]

Combining data from different tables into a single result set is called performing a join. Updating records could be a problem caused by denormalized design. Answer: True Today’s organizations are heavily dependent on computer systems. Answer: True The Like operator […]

Attribute and record are typically used interchangeably. The types of joins most widely used are the so-called outer joins. Answer: False Social security number is stored in Text data type. Answer: True A database table is organized in rows (known […]

In Oracle, an extra comma at the end of the column list in the Insert statement will generate an __ error. In Oracle, omitting a comma between fields in the Create Table statement will generate a __ error message. Answer: […]

As the table columns are checked off, they appear in the query grid with New Value cells associated with them. The advantages of saving connection to Web.cong le include easier deployment and portability. Answer: True Information systems include people, policies, […]

A primary key __ identifies each record in a table. A set of different information technologies comprises a company’s _. Answer: organizational system_ If client’s type (based on ownership, for example) was determining the type of specialized portion of tax […]

The lack of foreign keys is seen as an __ of normalized designs. ASP.NET application is tested by viewing it in a __. Answer: browser The first step in configuring the GridView control is to __. Answer: choose data source […]

The relationship between employee and job tables is __. 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 […]

__ field in the client table would most likely be the largest field in terms of size. For years, QuickTax, Inc has helped small business manage their taxes. The management has a database to keep track of clients, employees, and […]

Multitier architecture that uses clients and servers for initiating requests and producing responses is also called a __ -tier architecture. TimeCheckedOut OrderPlaced? List and/or construct primary keys for each of the tables. Answer: Each of the tables probably has computer-generated […]

Selection operation retrieves a subset of columns. Relational database is not a part of an information system. Answer: False Client/server architecture is also known as three-tier architecture. Answer: False Birth date data type is DATE. Answer: Answer: False Server control […]