Crowdly

Use the following relations R and S to answer the question:

Compute π_{B, C}(R ⋈ S). Which of the following records will be in the result?

6, 4

5, 3

4, 3

5, 6

Use the following relations R and S to answer the question:

Compute R ⋈ S. Which of the following records will be in the result?

6, 4, 4, 1

2, 3, 3, 5

3, 3, 1, 6

3, 5, 3, 1

Which of the following are examples of documentation that describes the current system?

Employee and customer complaints

Data dictionary and program documentation

Organizational chart, mission statement, and strategic plan

Internal memos, e-mails, and minutes of meetings

During the implementation stage, the Data Definition Language (DDL) is used to:

Create database schemas and empty database files

Monitor the performance of the database system

Transfer existing data into the new database

Test the usability of the system

In the view integration approach, a local data model is:

The physical database design for one branch office

A data model representing a single user view (or a subset of all user views)

A model of the data stored at one physical site

A data model representing all user views of the database

Which fact-finding technique is described by the following?

This technique uses computer trade journals, reference books, and the Internet (including user groups and bulletin boards). This provides information on how others have solved similar problems, plus whether or not software packages exist to solve or even partially solve the problem.

Interviewing

Questionnaires

Research

Observing the organization in operation

Examining documentation

Database administration is the management of the physical realization of a database system, including:

Physical database design and implementation, setting security and integrity controls, and monitoring system performance

Writing the mission statement and mission objectives for the database project

Designing the user interfaces of the application programs

Database planning and the development of standards, policies, and procedures

Which database design approach first identifies a set of major entities and then spreads out to consider other entities, relationships, and attributes associated with those first identified?

Inside-out

Top-down

Bottom-up

Mixed

Observation of the organization in operation is particularly useful when:

A solution to the problem may already exist in the literature