Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART 1 Research (in textbooks, internet references, etc.), observe examples and understand about international standards to name and define the basic characteristics of a TABLE

PART 1
Research (in textbooks, internet references, etc.), observe examples and understand about international standards to name and define the basic characteristics of a TABLE and its respective FIELDS; this, when you are "mapped" = (creating the Table Structure of a BD)
As we will learn later and you will be using the SQL Language (to create Databases) ... focus your research on this language.
(It is recommended to document it for easy and quick access)
The goal is that with your research you can solve technical aspects, for example:
How to name a TABLE?
How to name a FIELD?
How do you indicate that a FIELD is the PRIMARY KEY?
How do you indicate that a FIELD is the FOREIGN KEY?
What TYPE OF DATA is the most "adequate" to assign to each FIELD?
what LENGTH?
is the most suitable to assign to the FIELDS that
Do you require?
For example: to a registration, to a surname, etc.
what type of "connector" is used at the ends of the line that connects two
BOARDS?
In relation to the connector that represents the TYPE OF RELATIONSHIP between the TABLES
For example, relationship ..
Tin n'm etc)
image text in transcribed
Esta Actividad se reatiza en 4 partes: PARTE 1 Investiga (en libros de texto, referencias por internet, etc), observa ejemplos y comprende sobre los estndares internacionales para nombrar y definir las caracteristicas bsicas de una TABLA y sus respectivos CAMPOS; esto, cuando se est "mapeado" = (creando la Estructura de Tablas de una BD) Como ms adelante aprenderemos y estars usando el Lenguaje SQL (para crear Bases de Datos) ... enfoca tu investigacin en relacin a este lenguaje. (se recomienda documentario para su facil y rapido acceso) El objetivo, es que con tu investigacion puedas resolver aspectos tcnicos, por ejemplo: - como nombrar una TABLA ? - como nombrar un CAMPO? - como indicar que un CAMPO, es la LLAVE PRIMARIA ? - como indicar que un CAMPO, es la LLAVE FORANEA ? - que TIPO DE DATO es el ms "adecuado" de asignar a cada CAMPO? - qu LONGITUD 1,2,3, .. etc es la ms adecuada para asigna a los CAMPOS que to requieran? por ejemplo: a una matricula, a un apellido, etc> - que tipo de "conector" 1:11:nn:m etc)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions