Question 1: How to fill in the names of related parties in Table 1 "Association Table" in the annual report of related business transactions of enterprises? Enterprises basically have no affiliated units, and association refers to investments made in the name of enterprises.

Question 2: How to fill in the relationship table:

According to your above content, it is not the category of affiliated enterprises in legal form. The above-mentioned A\B\C, a joint venture, is a shareholder of the company.

The so-called affiliated enterprises refer to enterprises that have direct or indirect control relations or significant influence relations with other enterprises. Enterprises that are connected with each other are affiliated enterprises. Affiliate enterprises can be represented by controlling companies and subordinate companies in law. The formation of controlling company and subordinate company mainly lies in the existence of unified management relationship between dry affiliated companies. This relationship is often formed with the help of the controlling company's substantial control over the subordinate company.

Question 3: Which [Edit this paragraph] should I choose for the code of the association table (Table 1)? There must be a reference table for the association table. For example, there is an employee file management system project, which should include the following data tables: basic information table, employee file table, department table, project group table and bank card table (used to record employee bank card information). There is a certain relationship between these data tables. We analyze the relationship with other tables by referring to the employee basic information table: every employee must have the corresponding employee file information, so it belongs to the HAS_ONE relationship; Every employee must belong to a certain department, so it belongs to the BELONGS_TO association; Each employee can have multiple bank cards, but each bank card can only belong to one employee, so it belongs to HAS_MANY association; Each employee can be in multiple project teams at the same time, and each project team has multiple employees at the same time, so it belongs to MANY_TO_MANY association; After analyzing the relationship before the data table, we can define and operate the relationship. [Edit this paragraph] The relationship on the database The interdependence and influence of data between two databases and their (data) tables. For example, there are three data tables in a school: student (student number, name), course (course name, course number) and course selection (student number, course number, grade). The "student number" and "course number" in the course selection table must be the data in the other two tables to be meaningful; And once a student or course in the other two tables is deleted, the corresponding student number or course number in the course selection table must be automatically deleted. This is a relationship. It is actually a way to ensure data integrity. [Edit this paragraph] The information to be filled in the tax related relationship table includes: related party name, taxpayer identification number, country (region), address, relationship with the enterprise, legal representative and related relationship type. The specific reporting requirements are as follows: 1. "Taxpayer identification number": reporting the taxpayer number used for tax declaration in the country or region where the related party is located. Ii. "country (region)": fill in the name of the country or region where the related party is located. 3. "Address": fill in the registered address of the affiliated enterprise and the address of the actual management organization or the domicile of the affiliated individual. Iv. "Relationship Type": Codes A, B, C, etc. shall be filled in according to the following relationship standards. If there are multiple relationship types, multiple codes shall be filled in: a. One party directly or indirectly holds 25% or more of the shares of the other party; Or both parties directly or indirectly hold 25% or more shares as a third party. If one party holds shares indirectly to the other party through the intermediary, as long as one party holds 25% or more shares to the intermediary, the shareholding ratio of one party to the other party shall be calculated according to the shareholding ratio of the intermediary to the other party; B. The loan funds between one party and the other party (except independent financial institutions) account for 50% or more of the paid-in capital of one party, or 10% or more of the total loan funds of one party is guaranteed by the other party (except independent financial institutions); C more than half of one party's senior managers (including board members and managers) or at least one senior board member who can control the board of directors are appointed by the other party, or more than half of both parties' senior managers (including board members and managers) or at least one senior board member who can control the board of directors are appointed by a third party; D more than half of one party's senior management personnel (including board members and managers) serve as senior management personnel (including board members and managers) of the other party at the same time, or at least one senior board member of one party who can control the board of directors serves as a senior board member of the other party at the same time; E. One party's production and business operation activities can only be carried out normally with industrial property rights, proprietary technology and other concessions provided by the other party; F one party's purchase or sales activities are mainly controlled by the other party; G the acceptance or provision of labor services by one party is mainly controlled by the other party; H. One party has substantial control over the production, operation and transaction of the other party, or the two parties have other related relationships in interests, including that although the shareholding ratio in Item A is not reached, one party enjoys basically the same economic interests as the main shareholder of the other party, as well as family and kinship relations.

Question 4: How to fill in the relationship table? Q: A: Weifang State Taxation Bureau (Weifang State Taxation Bureau Memorandum [2012] No.4) put forward specific requirements for related declaration. The contents are as follows: "The cover and related relationship table (Table 1) of the annual related business transaction report form of an enterprise must be filled in with relevant contents, and cannot be blank; Summary table of related party transactions (Table 2), purchase and sale table (Table 3), labor service table (Table 4), intangible assets table (Table 5), fixed assets table (Table 6) and financing fund table (Table 7). If there are related party transactions, non-related party transactions or only one of them, the corresponding data and related totals should be filled in (especially if there are only non-related party transactions). The form of foreign investment (Table 8) and the form of foreign payment (Table 9) are filled in according to the actual situation of the enterprise. "

Question 5: How to fill in the last related relationship table in the annual reporting related relationship transaction table, the starting date and the explanation in Article 6.

Question 6: The main customers and suppliers of the enterprise are not affiliated enterprises.

The so-called affiliated enterprises refer to enterprises that have direct or indirect control relations or significant influence relations with other enterprises. Enterprises that are connected with each other are affiliated enterprises.

Enterprise relationship:

1, and the total amount of shares held by each other directly or indirectly reaches 25% or more;

2. The shares directly or indirectly owned or controlled by a third party reach 25% or more;

3. The loan funds between an enterprise and another enterprise (except independent financial institutions) account for 50% or more of the paid-in capital of the enterprise, or 10% of the total loan funds of the enterprise is guaranteed by an independent financial institution of another enterprise;

4. More than half of the directors, managers and other senior managers of the enterprise or one managing director is appointed by another enterprise; 5, the production and business activities of enterprises must be provided by another enterprise's franchise rights (including industrial property rights, proprietary technology, etc.) can be carried out normally;

6. Raw materials, spare parts, etc. (including prices and trading conditions) purchased by an enterprise for production and operation are controlled or supplied by another enterprise;

7. The sales of products or commodities produced by an enterprise (including prices and trading conditions, etc.) are controlled by another enterprise;

8. Other related interests that have actual control over the production, operation and transaction of the enterprise, including family and kinship.

Question 7: How to fill in the related relationship table of the annual enterprise income tax declaration system? If there is no related company, fill in the legal person, and then the transaction information in the table will be empty or filled with zeros.

Question 8: How does Oracle create a relational table to associate with another table, such as the basic information of employees and the department information of the company stored in the following two tables respectively? We are working for

create table dept

(deptno number( 10) not null,

Deptn top me varchar2(30) not null,

constraint pk_dept primary key(deptno));

and

create table emp

( empno number( 10) not null,

fname varchar2(20) ,

lname varchar2(20) ,

dept number( 10) ,

constraint pk_emp primary key(empno));

Then we now add foreign keys and try on delete cascade.

alter table emp

add constraint fk_emp_dept foreign key(dept) references dept(deptno) on delete cascade;

Add foreign keys first. Then insert the data.

Insert into dept values (1,'sales department');

Insert into dept values(2,' finance department');

insert into emp values (2,’Mary’,'Song’, 1);

insert into emp values (3,’Linda’,'Liu’,2);

insert into emp values (4,’Linlin’,'Zhang’, 1);

Then now I want to delete the sales department, what will happen?

delete from dept where deptno = 1;

We found that except one data in dept was deleted, two data in emp were also deleted, and two data in emp refer to this data in the sales department, which makes it easy to understand on delete cascade.

Question 9: How to fill in the annual report form of related business transactions of enterprises of the People's Republic of China 1. This report form is formulated in accordance with the provisions of Article 43 of the Enterprise Income Tax Law of the People's Republic of China. II. This report table includes: related relationship table (Table 1), related transaction summary table (Table 2), purchase and sale table (Table 3), labor service table (Table 4), intangible assets table (Table 5), fixed assets table (Table 6) and financing fund table (Table 7). Three, this report is applicable to the resident enterprises that implement audit collection and non-resident enterprises that set up institutions and places in China and truthfully declare and pay enterprise income tax. Four, enterprises to the tax authorities to submit the annual enterprise income tax returns, should be attached to this report. 5. "Taxpayer's name": Fill in the full name of the taxpayer in the tax registration certificate. 6. "Taxpayer identification number": fill in the number code of the tax registration certificate uniformly issued by the tax authorities. Relationship table (Table 1): 1. "Taxpayer identification number": fill in the taxpayer number used for tax declaration in the country or region where the related party is located. Ii. "country (region)": fill in the name of the country or region where the related party is located. 3. "Address": fill in the registered address of the affiliated enterprise and the address of the actual management organization or the domicile of the affiliated individual. Iv. "types of relationship":

Question 10: SQL tables are related to two tables that are not directly related in a diagram. How to query their data? The join of sql is independent of foreign keys.