Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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 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.
Client
Email Name Contact Address City State Zip Code Phone
dentpro@comcast.net Dentist Pros James Tucker 63 Elm Street Manchester NH 03308
(603)774-6698
dstewart54@aol.com Danny's Hardware Danny Stewart 5 Main Street Campton NH
03223 (603)536-9234
josfurniture21@aol.com Jo's Furniture Jo Collins 54 High Street Brattleboro VT 05301
(802)873-4456
johnyspizza@verizon.net Johny's Pizza Anthony Vicente 54 Main Street Campton NH
03223 (603)536-1988
maggiej@att.net Plymouth Professionals Margaret Jones 84 Highland Street Plymouth
NH 03264 (603)536-2388
thecornergrocery@att.net The Corner Grocery Joan Jenkins 34 State Street Concord
NH 03301 (603)254-5498
tmcdougal@comcast.net Mountain Coffee Terry McDougal 23 Main Street Plymouth
NH 03264 (603)536-1288
For questions 14-26, please refer to the preceding paragraph and table.
In Oracle, the data type of Email field would be Char(10).
Email address satisfies all of the desired primary key properties.
Data type describes the kind of information stored in an attribute.
Database normalization is about checking the accuracy of database design.
End users typically have a direct access to a database.
Relational database management system (RDBMS) is the software that runs on the Web
server.
Setting AutoGenerateEditButton property to True will place New link into DetailsView
control.
The general portion of the tax return inherits all the attributes of the specialized portion.
Consecutive numbers at the bottom of DetailsView control allow us to browse through
the records in associated table.
Distinct keyword would be used to find out how many different values there are in a
particular field.
Specialized type of computers initiating requests and presenting results are called
clients.
In Microsoft Access, creating a blank database file for the above case involves starting
Access and selecting File -> Open and choosing quick_tax.mdb file.
When the New link in DesignView is tested, a list of empty text boxes will allow us to
enter the new record into the corresponding table.
Database servers requests data residing on application servers for processing.
All the data for a table can be entered with a single Insert statement.
The relationship between consultant mentors and mentored is an example of a recursive
relationship.
One-to-many relationship between two tables is the most common type of relationship.
In order to perform a multiple join, the Where clause is used together with Or operator.
In Oracle, using level as a field name would generate Invalid Identifier error.
Count(*) function returns a count of records including those with nulls.
Test Connection button makes sure that the Web Developer can
connect to qtax SQL Server database.
In Microsoft Access, main database window contains a list of object tabs, starting with
Tables used to design, populate and manage database tables.
Instead of using where clause to perform a join, Oracle uses the inner join keyword.
SQL implements selection, projection, and joining operations through a single
statement called the Select statement.
ASP.NET Web Form is built using standard HTML tags.
Equal to (=), greater than (>), and less than (<) are all examples of conditional
operators.
Con&gure data source wizard is used to establish new connection with
qtax SQL server database.
Two fields, longitude and latitude, together form a primary key for a location table.
Each table must have an attribute that uniquely identifies each instance of the entity.
A table can have no relationships with other tables in a multi-table database.
The result of two conditions with And operator in between will be true only if both of
the conditions are true.
Organizational systems components are the people, products, and services.
Structured query language (SQL) is the command language used to communicate with
the RDBMS.
Email would be set as the primary key for the client table.
A series of SQL commands saved in a file is called a script.
The result of two conditions with Or operator in between will be true if either of the
conditions are true.
Each entity is represented in an ER diagram as a box with a unique name.
Client, application server, and data server form a three-tier architecture.
Having a part of CustomerID primary key come from customer's email address, violates
which of the following normal forms?
a) 1NF
b) 2NF
c) 3NF
d) BCNF
First normal form (4NF) states which of the following?
a) All fields must contain single values only.
b) Part of the primary key may not determine a non-key field.
c) A non-key field may not determine a non-key field.
d) In an all-key table, part of the key can determine multiple values of, at most, one
other field.
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
In SQL Query Analyzer, which of the following statements would result in contacts,
emails, and zip codes for the clients whose emails end in "net", and who live in 03264
zip code?
a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode!
= "03264"
b) Select contact, email, zipcode From client Where email Like "*net" Or zipcode =
"03264"
c) Select contact, email, zipcode From client Where email Like "net" Or zipcode =
"03264"
d) Select contact, email, zipcode From client Where email Like "*net" And zipcode =
"03264"
Specialized portions of the tax return that are different for different types of clients
would be called which of the following?
a) General entity
b) Subtype entity
c) Supertype entity
d) Sublime entity
In Microsoft SQL Server, the most appropriate data type for a field indicating whether
the order has been shipped or not would be which of the following?
a) Tinyint
b) Bit
c) Numeric
d) Decimal
In an example of students and course prerequisites, the recursive relationship lies in
which of the following?
a) Relationship between a particular course and a particular student
b) Relationship between a particular student and a particular course
c) Relationship between a particular course and another course
d) Relationship between a particular student and another student
Which of the following would be used in order to create Select * From client code in
SQL Query Analyzer?
a) Execute button
b) Object browser
c) Query pane
d) Results pane
Joining operation does which of the following?
a) Retrieves a subset of rows
b) Retrieves a subset of columns
c) Combines data from two tables
d) Makes a link between two tables
The second step in the basic ASP model is which of the following?
a) Server sends Web Form from the Web server.
b) User requests Web Form from the user's browser.
c) Web server processes data and returns form to the user's browser.
d) User enters data and returns form to the Web server.
Representing a one-to-many recursive relationship requires which of the following?
a) Additional table with a composite primary key that acts as a foreign key
b) Additional foreign key that is also a primary key in the same table
c) Additional table with a primary key, but without a foreign key
d) No additional table modification
In Microsoft Access, after adding all three tables to the Relationships window, the link
between Client and Employee tables is established by doing which of the following?
a) Dragging SSN field from Employee table onto Name field in Client table
b) Dragging SSN field from Employee table onto SSN field in Job table and dragging
Email field from Client table onto Email field in Job table
c) Dragging SSN field from Employee table onto Email field in Client table
d) Nothing, there is no relationship between Client and Employee tables
After the GridView control has been associated with a particular data
source control, which of the following changes take place?
a) Grid remains unchanged until viewed in the browser, at which point
it displays the corresponding data source.
b) Grid changes to reflect the columns in the data source, and when
viewed in the browser, it displays the corresponding records.
c) Grid changes to reflect the columns and records in the data source,
which can then be view in the browser as well.
d) Grid changes to reflect the records in the data source, and when
viewed in the browser, it displays the corresponding columns.
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
In Microsoft SQL Server, inserting links between Client and Job tables, as well as
Employee and Job table, establishes which other relationship?
a) One-to-one Client-Employee relationship
b) One-to-many Client-Employee relationship
c) Many-to-many Client-Employee relationship
d) No additional relationship is established
In Microsoft SQL Server, which of the following is used to create interactive screens
that allow end user to work with database data?
a) Views
b) User forms
c) Stored procedures
d) User defined functions
Equipment supertype and its computer and printer subtypes are examples of which of
the following?
a) Partial specialization only
b) Partial specialization and disjoint rule
c) Total specialization and disjoint rule
d) Partial specialization and overlap rule
In Microsoft SQL Server, a check constraint for State field with Nvarchar(2) data type
in the client table, would most likely be which of the following?
a) "states'
b) state "NH"
c) state in ("NH", "VT")
d) state not in ("VT")
In Oracle, which of the following environments allows you to create and execute SQL
statements?
a) iSQL*Plus workspace
b) SQL*Plus workspace
c) SQL workspace
d) Web workspace
Boyce-Codd Normal Form (BCNF) states which of the following?
a) A part of the primary key may not determine a non-key field.
b) A non-key field may not determine another non-key field.
c) A part of a non-key field may not determine the primary key field.
d) The primary key may not determine a non-key field.
First normal form (2NF) states which of the following?
a) All fields must contain single values only.
b) Part of the primary key may not determine a non-key field.
c) A non-key field may not determine a non-key field.
d) In an all-key table, part of the key can determine multiple values of, at most, one
other field.
In the JobClient table, the presence of ClientID violates which of the following normal
forms?
a) 1NF
b) 2NF
c) 3NF
d) 4NF
In Microsoft Access, validation rule for State field with Text(2) data type in the client
table, would most likely be which of the following?
a) "states"
b) "NH"
c) "NH" Or "VT"
d) "NH" And "VT"
In a recursive relationship, which of the following is true of the entity involved?
a) The entity is the parent, but not the child.
b) The entity is the child, but not the parent.
c) The entity is both the parent and the child.
d) The entity is neither the parent nor the child.
Count function does which of the following?
a) Returns the total of the values in the column for the selected rows
b) Returns the average of the values in the column for the selected rows
c) Returns the number of values in the column for the selected rows
d) Returns the highest value in the column for the selected rows
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 33-56, please refer to the preceding paragraph.
In SQL Query Analyzer, the statement used to retrieve all the data from the job table,
would be which of the following?
a) Select job From *
b) Select * From job
c) From job Select *
d) From * Select job
In Microsoft Access main database window, which of the following objects allows you
to create and execute SQL statements?
a) Tables
b) Queries
c) Forms
d) Reports
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.
The SQL statement used to enter the data into a table is which of the following?
a) Enter
b) Data
c) Insert
d) Input
Having some client's tax return that do not contain specialized attributes would be an
example of which of the following?
a) Partial specialization
b) Total specialization
c) Disjoint rule
d) Overlap rule
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.
Client
In Oracle, the script line setting up the primary key, would be which of the following?
a) Primary key email char(30)
b) Email char(20) as primary key
c) Email char(10) primary key
d) Email char (30) primary key
Each table must have a
a) primary key.
b) foreign key.
c) parent key.
d) child key.
Businesses have __ that allow end user to interact with a database.
Microsoft SQL Server's uses _ to create temporary tables.
In Oracle, the script line used to describe the fields in the client table that was just
created, would be: __.
In SQL Query Analyzer, the statement used to display employee and client names
together with all of the jobs for 3/14/06, sorted alphabetically by client name, would be
__.
_ integrity requires that the designer specify a primary key at the time the table is
created.
In Oracle, the statement used to retrieve client's contacts with emails ending in "net",
and from area code 603, would be __.
ASP Web page is built using a mixture of HTML tags and __.
In Microsoft SQL Server, right-clicking on the Employee table and choosing _ will
open the Employee table in __ view.
Data types of primary and foreign keys must be __.
A set of words that cannot be used as names of columns or tables are known as __
words.
DetailsView control property that allows us to browse through the records of the data
source is called __.
According to the above paragraph, describe how a typical transaction might occur.
__ field in the client table would most likely be the largest field in terms of size.
According to the paragraph, employee table will have the following data items: _.
In Microsoft SQL Server, from the standpoint of a user entering data into the client
table, the most efficient way of implementing State field would be using __.
In SQL Query Analyzer, the statement used to retrieve all the jobs with jobid over 5,
displaying only jobids and associated dates, would be __.
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.
In Oracle, the script line setting Email as the primary key, would be: __.
