Databases

Which of the following is an appropriate effect obtained through the normalization of data in a relational database?

Which of the following is an appropriate description concerning foreign keys in a relational database?

When conditions (i) through (iv) are all fulfilled, which of the following is the E-R diagram that indicates the relationship between publishing companies, authors, and books? Here, the notation for the E-R diagram is as below.

[Notation]

Which of the following is the appropriate explanation of commit in transaction processing?

By joining tables “Employees in charge”, “Regions”, and “Customers” that are managed in a relational database, the table A that is shown below is obtained. Which of the following is the table “Customers” that is used for the joining? Here, a solid underline indicates a primary key and a dotted underline indicates a foreign key.

Which of the following is an appropriate purpose of conducting data normalization when a relational database is constructed?

An “Employee” table and a “Department” table that are to be managed with a relational database were created on the basis of the conditions (i) through (v). Which of the following is the most appropriate primary key for the “Employee” table?

Which of the following is the appropriate description concerning transaction processing?

When an activity for building a relational database is divided into steps A through C below, which of the following is the appropriate order of the steps?

The “Purchase_list” table in a relational database manages the purchases of products. This table should be normalized and divided into a “Purchase” table and a “Product” table. Which of the following is the most appropriate field that should be contained in common in the two divided tables? Here, each purchase includes only one product, and can be uniquely identified by Purchase_number. Also, each product can be uniquely identified by Product_number.

Which of the following is the appropriate description of a rollback in transaction processing?

Which of the following is the appropriate purpose of exclusive control in a database management system?

There are “Sales”, “Customer” and “Product” tables in a relational database. Among lists A through C, which of the following contains all and only the lists that can be created from the data in these tables? Here, a solid underlined part represents a primary key, and a dashed underlined column represents a foreign key.

In the description below concerning the design process of a relational database, which of the following is an appropriate combination of terms to be inserted into blanks A through C?

Analyze the target business operations, identify the data which is used there, and create B, consisting of entities and A. On the basis of the B created, design C.

Which of the following is an appropriate combination of relational database manipulations I through III and relational operations?

From a “Product” table and “Sales” table that are managed with a relational database, which of the following contains all and only the products where the total sales for each product in May is at least 20,000 yen?

Which of the following is a language used for the operation of a relational database?

When designing a database, which of the following is used for the purpose of organizing and representing the relation of data?

Which of the following is the most appropriate method for limiting the content of database to be displayed in accordance with its confidentiality and each user’s business needs?

Which of the following is an appropriate purpose of normalizing the data of a relational database?

Which of the following is a term for an operation that extracts only the rows (records) with a price of 100 yen or more, from the “Product” table of a relational database?

When the “Department,” “Location,” and “Employee” tables are joined to create Table A, which of the following is the “Employee” table that is to be joined? Here, an underline indicates a primary key, and a dotted underline indicates a foreign key.

From the “Product” table below, products whose supplier is “Company A” and the price is 1.40 dollars or more, and products whose supplier is “Company B” and the price is 1.70 dollars or less are extracted. Which of the following is a list of all of the obtained product names?

Which of the following is a database model that represents data in a table that is composed of rows and columns?

There is the “Employee” table and the “Department” table in a relational database. The “Employee” table and the “Department” table are joined, and employees who live in prefectures different from the prefectures that their departments are located in are extracted. How many employees are extracted?

In a relational database, which of the following is the reason for a primary key being specified?

In DBMS, which of the following is a function for maintaining consistency of data by preventing the occurrence of conflicts due to simultaneous access to the data ?

A customer name and his or her address, a product name and its unit price, the products and quantities ordered by the customer, and the date of order are managed by using a relational database. Which of the following is an appropriate table after normalization? Here, the underline represents primary keys, and there are same customer names and product names.

The result of the Information-Technology Engineers Examination by some of the employees of a company is shown below. In order to manage this table with a relational database, which of the following is an appropriate method to partition the table into two (2) tables? Here, this company has employees with the same name.

In a relational database, when (A∪B) and (A∩B) are performed on table A and table B shown below, which of the following is an appropriate combination of the resulting two tables among the three tables P, Q, and R? Here, (A∪B) shows the union of A and B, and (A∩B) shows the intersection of A and B.

In a system environment where several users have access to a database simultaneously, a new user tries to view a data record while another user is updating the same record. In order to assure data integrity in such circumstances, which of the following is an appropriate control method that should be used in the DBMS?

Sales data is to be managed with tables in a relational database. When the tables for sales data are designed, which of the following activities analyzes the relationship between the fields of the tables and decompose the tables so that there are no duplications or inconsistencies in the data?

Which of the following is an appropriate description about association of records for a relational database?

A “Sales Details” table and a “Products” table are managed in a relational database. What is the total number of notebooks sold?

Among the processes where multiple users simultaneously access the same database, which of the following is a process that does not need a countermeasure for securing transaction consistency?

Which of the following is an appropriate description of a rollback in transaction processing?

Which of the following effect is obtained by normalizing the tables of a relational database?

Which of the following is an appropriate effect obtained through the normalization of data in a relational database?