Database Task (UAPA)
Uploaded by
ScribdTranslationsDatabase Task (UAPA)
Uploaded by
ScribdTranslationsdatabase task
1. In a Word document, define the following concepts and give
example of each of them
a. Date
You give a representationsymbolicnumerical, alphabetical, algorithmic, spatial, etc. of a
attribute or quantitative or qualitative variable. The data describe empirical facts, events and
entities. It is a value or reference that the computer receives through different means, the data
they represent the information that the programmer manipulates in the construction of a solution or
in the development of an algorithm.
b. Registration
Oncomputer science, or specifically in the context of arelational database,
an unregistered (also called filao)tuple) represents aobjectunique ofdataimplicitly
structured in atableIn simple terms, a table in a database can
to imagine being formed into columnsfieldsthe attributes). Each row of a table represents
a set of related data, and all rows of the same table have the same
structure.
c. File
A computer file is a set ofbytesthat are stored in a
device. A file is identified by a name and the description of thefolder or
directorythat contains it. Computer files are called that because they are the
equivalents digital de the files writings in files, cards
notebookspapero microfichefrom the traditional office environment.
d. Database
A database is a set of data belonging to the same context and
systematically stored for later use. In this sense; a library can
to be considered a database primarily composed of documents and printed texts in
papers are indexed for your consultation. Currently, and due to the technological development of fields
like thecomputer scienceand theelectronics, most databases are in digital format,
being this an electronic component, it has therefore been developed and a wide range is offered
range of solutions to the problem of thedata storage.
e. Field
Incomputer sciencea field, a storage space for adatein particular.
In thedatabasesa field is the smallest unit of information that can be
access; a field or a set of them forms aregistration, where fields may exist in
white, this being an error of theoperating systemThat field that has a unique data for
A repetition of an entity can serve for the search of a specific entity.
f. Data type
A data type or simply type, is an attribute of the data that indicates to
computer (and/or to theprogrammerabout the type of data that will be handled. This
includes imposing restrictions on the data, such as what values they can take and what operations
they can be done.
The types ofdatamost common are:integers, signed numbers (negative),
numbers offloating coma(decimals), alphanumeric strings (andunicodes), states, etc.
g. Width of a field
In thedatabasesa field is the smallest unit of information that can be
access; a field or a set of them form aregistration, where fields may exist in
blank, being this a mistake of theoperating system
h. Description of a field
In thedatabases, a field is the minimum unit of information that can be
access; a field or a set of them form arecord, where fields can exist in
blank, this being an error of theoperating system.
i. Table or entities
Table: Organization of data in the form of rows and columns. Each row represents
call tuple, and each column within a tuple corresponds to the value of a
attribute for that tuple.
Relationship: Association between entities. For example, a "student" "has" a
subject
j. Primary or main key
a primary key or a main key is a field or a combination of fields that
uniquely identifies eachrowof atableA primary key consists of this way
acolumnthe set of columns. There cannot be two rows in a table that have the
same primary key.
k. Foreign or secondary key
A foreign key (or FK) is a referential constraint between two
tables. The foreign key identifies acolumnthe group of columns in atable(child table or
referendum) that refers to a column or group of columns in another table (master table or
referenced). The columns in the referendum table must be theprimary key or another key
candidate in the referenced table.
What is the difference between a primary key and a secondary key?
A primary key fits the definition of an identifier, in that it determines in a way
only one instance of an entity
A secondary key fits the definition of a descriptor, in that it is not
necessarily unique for each instance of an entity
m. Relationships
To create related tables, you can define arelationshipbetween twotablesA relationship is established
when the value of afield, calledmatch field(sometimes it is called
in a key field) on one side of the relationship is successfully compared with a value in the field of
coincidence on the other side of the relationship according to the criteria specified in the relationship.
For example, you can create a relationship such that when the value in the student ID field of a
table Students is equal to the value of the student ID field from a Classes table, therecordsof the
two tables are related.
n. One-to-one relationships
In a one-to-one relationship, a recordfrom atableis associated with one and only one record of another
table. For example, in a database of an educational center, each student has only an ID
As a student, each student ID is assigned to only one person.
A one-to-one relationship has the following aspect in therelationship graph:
One-to-many relationships
In a one-to-many relationship, a registrationof onetableit can be associated with one or more records
from another table.. For example, each customer can have several sales orders.
A one-to-many relationship has the following aspect in therelationship chart:
p. Many-to-many relationships
A many-to-many relationship occurs when severalrecordsfrom onetableare associated with
various records from another table. For example, there is a many-to-many relationship between customers.
and the products: customers can buy several products and the products can be purchased
by many customers.
2. Go to a company, interview the person in charge of IT, and question them.
following the criteria below:
a. What type of database do you use?
Microsoft SQL Server Enterprise 2017
b. What is the database used for?
It allows us to store a large volume of data in an organized and secure way for the future.
consultation and maintenance. This allows us to perform parameterized inquiries and reports of a
efficient and effective way for decision-making in each of the departments.
c. Create a schema with the components that integrate into the database of the
company.
d. How is the database organized and can you present some fields as examples?
e. What information is stored in the company's database?
Customer information, Employees, Suppliers, billing, production, cost, accounting,
planning, market analysis, and procurement management.
f. What database management system do they use in the company?
Microsoft SQL Server Management Studio v.18.6
g. Which departments of the company use the database?
Manufacturing.
Logistics
Purchases
Human Resources
Planning
Innovation and Development
Industrial Maintenance
Engineering and projects
Quality Assurance (Inspection, audit, laboratory, sensory analysis)
Billing
Cost
Accounting
Finance
Sales
Marketing
Transportation and Fleet
Supply
h. Design a flowchart with the structure of the company's database.
i. 9- What are some advantages and disadvantages that the database offers to the company?
Refer to the following table.
Advantages Disadvantages
