Tip:
Highlight text to annotate it
X
Good morning, I'm your anchor Josh and today on ISYS Talks, we will be informing you on
what database relationships are. As the term suggests, a database relationship
describes the relationship which exists between two database tables.
They are made of a portion or series of data that are matched using common characteristics
found within distinct data sets.
A few examples of these relationships include, One to One, One to Many and Many to Many.
Now lets start our main segment.
Joining me in the discussion of relationships are Ernest and Natalie.
Hi Josh I'm glad to be here
Hi Josh I'm glad she's here.
Err, so, guys tell me what you think about relationships.
Well a relationship is when a two people who've been on several dates decide to be romantically
involved together.
Ah, sorry I meant database relationships
Oh well then, the first type of database relationship would be one to one.
This would be a row in a table is associated to one and only one row in another table.
An example of a one-to-one relationship is a person can have one student number and a
student number can only be assigned to one person.
Yes Ernest, that's right. There is also one to many relationships. These
are when row in a table in a database can be associated with one or more rows in another
table. An example of a one-to-many relationship is
a single order has many items within that order.
That's more what we wanted. There is also another final type of relationship
isn't that correct?
You mean many to many relationships, when one or more rows in a table are associated
with one or more rows in another table. An example of a many-to-many relationship
is a table of customers who can purchase many different products and a table of products
that can be purchased by many different customers.
I see, that certainly was informative, thank you Ernest, Natalie, we're looking forward
to having you on the show again.
What? I'm not going anywhere.
Ah... Well.... If you say so.
R-right....*Ahem*
Today we are introducing our new "Advice" segment, a part of our show where we call
in an expert to help answer whatever questions the guest may have.
Well then, let's begin "I would like to introduce our expert, Michael Lee".
Michael please tell us what you think about relationships and which is your favourite.
Mostly my favourite relationships are ones that are over by the morning.
Haha, I see, we're talking about database relationships again Ernest.
Well, Michael are there any tips you can offer to the viewers on remembering these various
relationships?
You can remember one to one relationships as a marriage, one to many relationships as
a player who sleeps around & many to many, well, I think that's commonly known as ***!
Ah Michael, could we please keep it P.G. in here.
Thank you.
Seriously Michael.
Anyway, thank you for your insight. Now, today we are joined by an anonymous guest
who has travelled to the studio to ask Michael Lee a few questions.
Welcome guest name... Er.. M. Um... Mansour? Ok, what kind of questions do you have for
Michael today?
Thank you, firstly I wanted to say that I am a big fan of ISYSGroup 7: Talks and enjoy
the new segment very much especially Michael Lee's performance it's... above average.
Um... Thanks?
My first question to you Michael, is, even though I have a lovely one to one relationship,
I want to know how you can manage a healthy unary relationship as well.
Okay... What do you mean by that?
Maybe I didn't speak properly; I meant to say, there is a certain someone who attends
my works, I often poke fun at him but that's only because I do not know how to express
my unary desires for him.
Unary...?
Well, I'm still not sure what you mean... But if you want to have a bidirectional relationship
with this person, it's probably best to just tell him.
Bidirectional?
It means a relationship which goes both ways.
Oh ok.
I suppose what you're saying is right. But I'm not quite sure how this person will
react.
Dude, the only way you can know is if you tell them right?
Yes... Ok then, Michael Lee, I want to tell you that I-
It looks like we're out of time.
W-wait.
Thank you all for watching today, make sure to keep an eye out for the next Isys114: Talks.