and that's what you are then we are
here again coming back with video for
keep talking about database
So, call it then, before it's
talking relational database I
I talked about pmac and I talked about how it works
the question because it has a database
centralized in a machine that
primark that the relationship between
standardization records continue here
I'm sorry, I'm not talking about the foreign key.
I spoke of the compound key what key
composed the composite sheet when
you say that that record is unique is
information that depends on two
or more fields so let's go
example on the assumption that in my
I'll also be able to have a database
register persons under the age of 12 or
Who does not have cpf you because I
I'm talking about financing tends only
thinking table training
users of my clients I have
my financing table a lipstick
financing I've created a contract now
I believe in the contact table that in
contract now so many parcels of both
interest rates and assuming that there were
the breach of contract and I will renew
I'll save the contract again on that contract.
table of contract and the new
who sees and I do not want to create a
new contract number wants to ensure
that you hire if you keep the same
previous contract name
only when it comes to the type
renegotiating what I'm going to do
in this table have two keys one that is the
contract number and another that is the type
of the contract if it is a zero-type contract
a new contract if it is contract type 2
renegotiation even allows one more
renegotiation of that contract may
create a contract string field
from 1 until when contracts allow
hence it will load the primary key
composed of the contract number and
sequence is a composite key
I have two fields already exist several
business leagues to be several
the cities that can contemplate this a
another case is relationship table
It got complicated there.
focus on types of relationships
which is a relationship table that
I would need the composite plate I have
my table let's suppose that I have
my user work and has a
table of subjects and I will save
in the system ends up in the subjects that
user has interests in a magazine for
know what the subjects are
user has to have this time he goes
in the site fill out the registration form
it will select things that
he likes to be able to appear more
magazines more products for him both the
select there culinary taste and like
also arts business cut sewing taste
technology and selects with the
which would create the next table next
file that will save information from the
and the subject exactly what it is
a table that will only have the ipad of the
user and haidê the subject
a relationship table then
You told them the whole table
have to have a xavi field if I create it
a xavi field there is to allow a key
primary that I was right
Increasing here I said in the video
awareness
will put one would be another record goes to
last was now 20 increasing
alone without needing you are
reporting thrombosis by going back there
composite plate by placing a key
primary than those two registers
that you user 10 subject 3
I recorded the key with a user
of these new 13 recorded it will allow
If you record the lesson, this
information is duplicated then as I
I said to make sure that the sun exists
a relationship of that user to
that subject my primary key
from that my compound table that
only exists in function of social only has
two fields that is user day and day
subject said she thought it was
both an associative table and
has a real clean compound key two
foreign keys that belong to two
different subject tables
So I assure you, we have to
try to re-enter that user and
that subject in that table
He'll make me one of those clothes.
records already exist
you're breaking a stick a rule
here is a bank rule of
data can not then break in the bank
in relation to people we have these
has already been a primary key
composite table key is the selective
key in that key type cpf and
which you have already registered is already
one of ensuring the
and if we talk about segregating information
but could leave normative of the data in the
shock it table I said because the
bank is generally remote database
so now I just have to talk now to
I also leave this video too long
anyway anyone who finally accesses
this information with whom chin inserts
deletes remove register changes deletes
this process is known as
crude freite media update an offense that
is the basic ion process of one of a
information that would be
disk now in the database the people
has any concept of crude oil as the
people would make this default language theme
of communication with a database that
is known as sql to use the
walls would require an interpreter
the customer in the event that the
People talk about her at work on her
browser
a machine in your machine to protest the
commands you will send via application
because neither the application only drives you a
and a library that will put a
database and needed these
instructions are to test your boss
client on your machine and run those
kermes these sql commands that one can
call also wants this is here is if
those basically this will control
select to share the record in
lucky that from creating update
upgrades and removing elite exist
adaptations since for example organs have
sql skin and so on
but if you already knew stander you will
able to do enough besides
consult the information also
has other commands that it is to create
tables a database to create a
electrical system database data
scratch table is indexing if the
ordering the key the rules everything and if
has this cetac command that you can
do this bench bench has only one follow
for example, like I said I will
Win spoke more ahead.
transmission of the body which is one of the
Which I particularly like
the organ has a peculiarity in
coins and objects therein and beyond
something that affects a lot
development his key
to sharp but not she has to increase
Do you have an object called Teaching Cycle?
database if question asked
he any next key he will te
give and you will never insert it ever
will automatically increment you already
has the eg microsoft sql that it
has high implementation implement of it
only that it only allows an auto unfortunately
per table and so goes
Good, I'll leave my video here over here.
the next video give some examples of
how to use the database no longer
development
probably there will be some
videos also speaking a language
we try to make the
two men already using a language if
communicating with a bank language
and a programming language has the
guys
What do you think, enjoy the video?
here below the doubts they have
different databases do not forget
of jewelry if you liked it 2
jewelry is sign up for the channel and click on
afterwards to receive notifications
of the next videos and I know many thanks
For more infomation >> Nuevo look de Karol Dance se convierte en el blanco de burlas en la web - Duration: 4:04. 
For more infomation >> Guild Wars 2: Objetos Gratuitos y Diseño de Armas Equinocciales - Duration: 3:14. 
For more infomation >> 10 Remèdes naturels qui peuvent aider à arrêter de ronfler toi ou ton partenaire - Duration: 10:36. 
For more infomation >> Meghan Markle luce hermosa en esmoquin de muslo para bailar 'Gala' para el príncipe Harry - Duration: 2:40. 
For more infomation >> Rutina de ejercicios para mantener a los niños activos | Un Nuevo Día | Telemundo - Duration: 5:13. 
For more infomation >> Fluminense recusa nova proposta de Monterrey por Pedro - Duration: 4:38. 
For more infomation >> ¡Fernanda Castillo y Erik Hayser, una historia de amor! | Un Nuevo Día | Telemundo - Duration: 6:37. 
For more infomation >> Huevo Sorpresa Gigante de Oddbods en Español de Plastilina Play Doh - Duration: 10:45. 
For more infomation >> Charlotte Casiraghi, sa surprenante explication sur la cruauté des djihadistes de Daech - Duration: 1:21. 
For more infomation >> AGENDA FCCR | De 29 de agosto a 4 de setembro de 2018 - Duration: 2:10. 
For more infomation >> Ovo Surpresa Gigante de Zak Storm em Português Brasil de Massinha Play Doh - Duration: 10:29. 
For more infomation >> 9 Consejos Realmente Efectivos Contra La Caída De Pelo - Duration: 5:31. 
For more infomation >> Desenvolvimento do bebê - 25 semanas de gestação - Duration: 2:24. 
Không có nhận xét nào:
Đăng nhận xét