CICS 67518 | Course Paper

Unlock access to all the studying documents.

View Full Document

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 addition, each of the consultants

(employees) has a senior consultant as a mentor to help with some of the more

challenging jobs and to evaluate employee’s performance. In turn, a particular employee

(consultant) that has a senior employee as a mentor, can be a mentor himself to a more

junior employee. Further, each of the jobs the company deals with has some things that

are in common, starting with ID, date/time started/ended, and so forth. Also, there are

some tax forms that must be filed with every client, regardless of specifics of a business

situation. On the other hand, there are some specific forms that apply to certain types of

business situations, but are different or simply not required for other clients.

For questions 17-26, please refer to the preceding paragraph.

The relationship between consultant mentors and mentored is many-to-many.

DetailsView control property AutoGenerateEditButton should be set to __ in order to be

able to edit records into the data source.

Microsoft Access is an example of a large-scale database management system.

In Oracle, an extra comma at the end of a value list in an Insert statement will generate

a Missing Expression error.

In Microsoft SQL Server, the relationship between two tables is established by

right-clicking the primary key in the parent table, and under Relationships tab of

Properties window, associating it with the foreign key in the child table.

The result of two conditions with Or operator in between will be true if either of the

conditions are true.

Using a reserved word “level” as a column name is not allowed.

Selection operation retrieves a subset of columns.

Instead of using where clause to perform a join, Microsoft Access uses Inner Join

keywords.

Text data type cannot contain numerical digits.

In Oracle, inserting a child record that does not have a matching parent record will

generate an Orphan Cannot Exist error.

In a query with a subquery, outer subquery always executes first.

If a field contains more than one single value, the design is in violation of 2NF.

An example of a multiple sort is ordering all the employees first by their social security

numbers and then by their names.

Inserting new client information into the JobClient table is possible without an actual

job assignment.

In Oracle, errors are always traced to the line that generated them.

The data source will be altered by writing an appropriate SQL statement under Select

tab.

Subtype tables do not need copies of the primary key.

Combining data from different tables into a single result set is called performing a join.

Storing connection strings simplies database maintenance.

Combining data from different tables into a single result set is called performing a join.

Entity and table are typically used interchangeably.

In Microsoft SQL Server Relationships window, there is a direct association between

Client and Employee tables.

All the fields in the Create Table statement are separated by commas, except for the last

field.

The Internet uses the Hypertext Transmission Protocol (HTTP) to exchange messages

between its computers.

Selection, projection, and joining are the three core data retrieval operations for

relational databases.

In Microsoft SQL Server, if State field was defined using Nvarchar(2) data type, the

most appropriate Default Value for the client table would be NH.

Phone number would be stored in Number data type.

All values in a column must be of the same data type.

In Oracle’s iSQL Plus interface, SQL commands are typed into the window and then run

using the Execute button.

Relationships in today’s ER diagrams are modeled as lines.

Updating DateStartTime field in JobClient table could cause the problem due to

denormalized design.

Entities (persons, places, things) are like

a) nouns.

b) verbs.

c) adjectives.

d) sentences.

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

In Microsoft Access, the statement used to retrieve all the jobs with JobID greater than

5 and less than 8, displaying only JobIDs and associated dates, would be which of the

following?

a) Select JobID, Date From Job Where JobID between 5 and 8

b) Select JobID, Date From Job Where JobID >5 And <8

c) Select JobID, Date From Job Where JobID >=5 and <=8

d) Select JobID, Date From Job Where JobID 5 and 8

In Microsoft SQL Server, after adding all three tables to the Edit Diagram 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

In Microsoft Access, the most appropriate data type and size for State field would be

which of the following?

a) Text(2)

b) Text(20)

c) Text(30)

d) Memo

Which of the following is the reason(s) ClientID field in the JobClient table violates

3NF?

a) ClientID determines Name field.

b) ClientID determines Phone field.

c) ClientID determines both Name and Phone field.

d) ClientID does not violate 3NF.

Which of the following is the foreign key in job table in a relationship with employee

table?

a) Employee social security number

b) Job unique ID

c) Client unique ID

d) Employee birth date

The advantage(s) of a well-designed script file is(are) which of the following?

a) Errors can be quickly located and corrected.

b) A corrupt database can be easily recreated.

c) A script file documents the creation process.

d) All of the above

In an order table, foreign key for a customer table would be named as which of the

following?

a) Customer$name

b) Order$date

c) Customer$email

d) OrderID

Assuming the JobID is the primary key in JobClient table, which of the following

normal forms is violated with respect to Name field.

a) 1NF

b) 2NF

c) 3NF

d) BCNF

Which one of the following are referred to as conditional operators?

a) +, -, *, /

b) =, >, <, >=, <=, !=

c) %, &, @, #

d) (, [, {, ), ], }

Which of the following are referred to as conditional operators?

a) +, -, *, /

b) =, >, <, >=, <=, !=

c) %, &, @, #

d) (, [, {, ), ], }

The relationship between tax returns and tax forms used to build it can be viewed as

which of the following?

a) One-to-many retroactive relationship

b) One-to-many recursive relationship

c) Many-to-many retroactive relationship

d) Many-to-many recursive relationship

BCNF violations can occur in only in tables with a __key.

The concept of inheritance means which of the following?

a) Any instance of a supertype inherits all the properties of the subtype.

b) Any instance of a supertype inherits some of the properties of the subtype.

c) Any instance of a subtype inherits all the properties of the supertype.

d) Any instance of a subtype inherits some of the properties of the supertype.

The SQL statement used to build a table is which of the following?

a) Build Table

b) Create Table

c) Set up Table

d) Construct Table

Employee name John Taylor would be an example of a

a) field.

b) record.

c) table.

d) data item.

In Microsoft SQL Server, data is entered into a table using which of the following?

a) Design view

b) Datasheet view

c) Database diagram

d) Open view

Normalized design would do which of the following with the client’s work, home, and

cell phone numbers?

a) Place them in another database on the database server.

b) Place them in a separate table in the same database.

c) Place them in separate fields in the same table.

d) Keep all the phone numbers in a single field.

In Microsoft Access, Expression Builder uses which of the following to help build

correct expressions?

a) Functions

b) Constants

c) Operators

d) All of the above

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

Which one of the following is(are) the core retrieval operation(s) for relational

databases?

a) Selection

b) Projection

c) Joining