SQL Programming for Research Projects
Translated by
ScribdTranslationsSQL Programming for Research Projects
Translated by
ScribdTranslationsSQL PROGRAMMING
VII SEMESTER
UNIVERSITY OF CARTAGENA
LORICA TUTORIAL CENTER
PRACTICAL EXERCISES.
21 DE ABRIL 2018
1. The OCIT of the UJI has a file system in which it stores the
information about the funded projects carried out by the groups of
university research. The information that follows is described
they contain the files that have to do only with the calls for aid
public.
The file of announcements contains information about the aid calls.
for the realization of research projects. Of these, it is kept
the publication date,
the organization that promotes it,
the program in which the project is framed,
the deadline for submitting applications,
the number of the call (it is unique within each program),
the website address where to get information about it
and the number of the BOE or DOGV where it has been published.
The resolution date is also recorded,
What is the day when the list of approved applications has been published.
each organism is stored,
in another file,
the name
the address
the population,
the postal code
and the phone.
The file of applications
stores the data of the requests that the research groups submit for the
different calls for aid for projects.
For each request, information about the call to which it corresponds is stored:
organism
program
number
date. In addition, it is saved the
date on which this application has been submitted,
the title of the project (which will be unique)
the name of the principal investigator and
his apartment.
When the resolution is published, it is also saved.
the date of this
and, in the event that the request is approved, it is noted.
Other data that appears in this file are:
the economic amount that is requested to carry out the project,
the names of the group members
of research that will participate in the project and
the hours per week that each one will dedicate to it, which can be different for
each researcher as they may be participating at the same time in other projects.
In addition,
the scheduled start and completion dates of the project are kept,
its duration in months and finally,
the entry number that the general registry has given to the application.
In the future database
It is also desired to reflect the research groups of the university.
with their name, the responsible researcher and
the researchers that comprise it.
Of these, it is known
the name
department and
area of knowledge
within the department. It is considered that a research group belongs to the
department of your responsible researcher, although some of its members may
belong to another department.
The names of the directors of the departments are also desired.
The file of calls contains information about the aid calls.
for the implementation of research projects. These are kept
the publication date, DATE
the organism that promotes it, VARCHAR
the program in which the project is framed, VARCHAR
the deadline for submitting applications, DATE
the call number (is unique within each program),VARCHAR
the website address where to obtain information about it VARCHAR
and the number of the BOE or DOGV where it has been published. VARCHAR
The resolution date is also stored, DATE
what is the day when the list of approved applications has been published. From
each organism is stored,
in another file,
The file of requests
stores the data of the requests that the research groups submit for the
different calls for project funding.
For each request, information about the call it corresponds to is stored:
the name
the address,
the population
the postal code
and the phone.
organism
program
number
date. Additionally, it is saved the
date on which this application has been submitted,
the title of the project (which will be unique)
the name of the principal investigator and
his department.
When the resolution is published, it is also saved.
the date of this
and, in case the application is approved, it is noted.
Other data that appears in this file are:
the financial amount requested to carry out the project,
the names of the group members
of research that will participate in the project and
the hours per week that each one will dedicate to it, which may be different for
each researcher as they may be participating at the same time in other projects.
Furthermore,
the scheduled start and end dates of the project are kept,
its duration in months and finally,
the entry number that the general registry has given to the application.
In the future database
It is also desired to reflect the research groups of the university.
with its name, the responsible researcher and
the researchers that make it up.
These are known
the name
department and
area of knowledge
within the department. It is considered that a research group belongs to
department of its responsible researcher, although some of its members may
belong to another department.
The name of the director of the departments is also wanted.
The file of calls maintains information about the aid calls.
for the execution of research projects. Of these, it is kept
the publication date, DATE
the organization that promotes it, VARCHAR
el programa en que se enmarca el proyecto, VARCHAR
the deadline for submission of applications, DATE
the call number (it is unique within each program), VARCHAR
the website address where to get information about it VARCHAR
and the number of the BOE or DOGV where it has been published. VARCHAR
The resolution date is also saved, DATE
What is the day on which the list of approved applications has been published.
each organism is stored,
in another file,
The file of requests
stores the data of the requests that the research groups submit for the
different calls for funding for projects.
Information about the call to which each application corresponds is saved.
the name
the address,
the population,
the postal code
and the phone.
organism
program
number
date. Additionally, it is saved the
date on which this application has been submitted,
the title of the project (which will be unique)
the name of the principal investigator and
his apartment.
When the resolution is published, it is also saved.
the date of this
and, in case the request is approved, it is noted.
Other data that appears in this file are:
the economic amount requested to carry out the project,
the names of the group members
of research that will participate in the project and
the hours per week that each one will dedicate to it, which may be different for
each researcher since they may be participating at the same time in other projects.
In addition,
the anticipated start and end dates of the project are kept.
its duration in months and finally,
the entry number that the general registry has given to the application.
In the future database
It is also desired to reflect the university's research groups.
with their name, the responsible researcher and
the researchers that make it up.
It is known of these
the name
department and
area of knowledge
within the department. It is considered that a research group belongs to the
department of your responsible researcher, although some of its members may
to belong to another department.