Relational Algebra (Cartesian Product Operation)

Подписаться 2,7 млн

Просмотров 95 тыс.

50% 1

DBMS: Relational Algebra (Cartesian Product Operation)
Topics discussed:
1. Recap of various fundamental operations in relational algebra.
2. Basics of Cartesian (X) product operation in relational algebra.
3. Syntax and working of Cartesian (X) product operation in relational algebra.
4. Solved examples using Cartesian (X) product operation in relational algebra.
5. Homework problem to perform simple Cartesian (X) product operation.
Follow Neso Academy on Instagram: @nesoacademy(bit.ly/2XP63OE)
Contribute: www.nesoacadem...
Memberships: bit.ly/2U7YSPI
Books: www.nesoacadem...
Website ► www.nesoacadem...
Forum ► forum.nesoacad...
Facebook ► goo.gl/Nt0PmB
Twitter ► / nesoacademy
Music:
Axol x Alex Skrindo - You [NCS Release]
#DBMSByNeso #DBMS #RelationalAlgebraOperations

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 29

@moonath. Год назад

It would be great if you were to show the answers to homework in the following video, so for example the homework answers for Union operation could be shown in the beginning of Set difference operation.

@MrLogicAddict Год назад

It looks like results of both expressions are gonna be the same. But second expression should give intermediary Cartesian table of 4 rows when first expression should give 8 rows. Probably the second method would be preferable from the perspective of memory utilization, but not sure about processor time. :)

@CSE_11 Год назад

🗿👏🏻

@alffonti8227 10 месяцев назад

I have the same question. I think it might have better performance, but I'm not sure.

@sithutun688 25 дней назад

the best channel I have ever watched. you should give all courses free. I think that you will get more popular and million views

@Black-xy4pj 5 месяцев назад

You’re amazing!

@A-ONE991 3 месяца назад

Thanks sir 😊😊

@arjunp5559 Год назад

why don't we use the Instructor and Course tables.? π name, Course_ID (σ Dept_name = Physics (INSTRUCTOR X COURSE))

@SyedMuhammadAli-tr4cg Год назад

i also want to know

@sahilpahuja8116 11 месяцев назад

@theflash2352 what is the ambiguity in his query , if u know please do tell.

@justanarmy9536 10 месяцев назад

There are going to be two columns named Dept_Name in INSTRUCTOR X COURSE@@sahilpahuja8116

@elenaguo1094 9 месяцев назад

I think as he said, there are multiple ways to answer the question

@ani10101 8 месяцев назад

if we consider instructor and course relation ans - π name,course_ID( σ instructor.Dept_name = course.Dept_name (σ instructor.Dept_name="Physics"( INSTRUCTOR X COURSE ))) It may be wrong.

@samblack5113 8 месяцев назад

why the ID number and instrcotr did must be the dame

@SivaVuyyuru-p1m 6 месяцев назад

How about we do an ^ operation (AND) Pi name,course_id( select dept_name='physics' ^ Instructor.Id=Teaches.Id(INSTRUCTOR X TEACHES))

@gabrielerneving541 6 месяцев назад

Yeah I thought about that too, it should work no?

@JohnLee-dp8ey 4 месяца назад

For the example, I can get the same output by 1st selecting where Teacher ID = Instructor ID, and then select by Department = Physics. Wanna ask if in general, do you always get the same output if you select by Condition A, then select by Condition B, as compared to if you select by Condition B, then select by Condition A?