- 54
- 871 101
Web Tech Paradise
Nepal
เข้าร่วมเมื่อ 6 พ.ค. 2020
For more solutions:
webtechparadise.com/questions-and-solutions
webtechparadise.com/questions-and-solutions
Introduction to Database, DBMS and Database System
#database #dbms #databasesystem #dbmstutorials
In this video, we introduce to the basic concept of Databases, DBMS and Database System for the beginners.
0:00 Database
0:25 Examples of Database
2:21 DBMS
4:46 Database System
In this video, we introduce to the basic concept of Databases, DBMS and Database System for the beginners.
0:00 Database
0:25 Examples of Database
2:21 DBMS
4:46 Database System
มุมมอง: 446
วีดีโอ
Foreign Key and Referential Integrity. All you need to know.
มุมมอง 1.7K2 ปีที่แล้ว
#referentialintegrity #foreignkey #datascience #database #dbms #dbmstutorials #sql #mysql #computerscience Foreign Key is an attribute (or a set of attributes) that refers to the Primary Key of another table. In this video, we discuss the following topics: 0:00 What is a Foreign Key? 0:59 Why do we use Foreign Keys? 1:34 Referential Integrity. 4:55 How to create a Foreign Key? 6:47 When to use ...
What is Moonlighting? Why Wipro fired 300 employees?
มุมมอง 2042 ปีที่แล้ว
#wipro #moonlighting #moonlight #firing #itcompanies #tech #jobs #jobs2022 #technews #india Wipro, the Tech giant of India, recently fired 300 employees over moonlighting. What is moonlighting? Why do employees moonlight? How do they moonlight? Is it ethical? What are the pros and cons of moonlighting? Image credits: Mikhail Nilov(pexels) Max Fischer(pexels) @surface(Unsplash) @smudgern6(Unspla...
Super Key vs Candidate Key vs Primary Key. Understand the difference.
มุมมอง 10K2 ปีที่แล้ว
Super Key is super-set of a key which can uniquely identify each record in the table. Candidate Key is the Minimal Super Key. Primary Key is one of the Candidate keys. Primary Key is one or more attributes used to uniquely identify each record in the table. #dbms #database #sql #mysql #exam #interviewquestions #primary_key #super_key Image credits: Unsplash: benwhitephotography Unsplash: tommyt...
Primary Key vs Composite Key in SQL
มุมมอง 3.5K2 ปีที่แล้ว
#sql #dbms #primary_key #composite_key #mysql The main purpose of using a primary key, in a table, is to uniquely identify each record in a table. When Primary Key has multiple fields, it is called Composite Key.
PHP & MySQL: Part 6: Pushing local git repository to remote(github.com).
มุมมอง 4112 ปีที่แล้ว
PHP & MySQL: Part 6: Pushing local git repository to remote(github.com).
PHP & MySQL: Part 5: Introduction to Git and Basic Git Commands.
มุมมอง 1922 ปีที่แล้ว
PHP & MySQL: Part 5: Introduction to Git and Basic Git Commands.
PHP & MySQL: Part 4: Include vs require vs require_once
มุมมอง 1772 ปีที่แล้ว
PHP & MySQL: Part 4: Include vs require vs require_once
PHP & MySQL: Part 3: Include statement with PHP templates
มุมมอง 1282 ปีที่แล้ว
PHP & MySQL: Part 3: Include statement with PHP templates
PHP & MySQL: Part 2: Finding the right directory for LAMP and XAMPP
มุมมอง 1022 ปีที่แล้ว
PHP & MySQL: Part 2: Finding the right directory for LAMP and XAMPP
Web Project in PHP & MySQL (Part 4): Insert form data in MySQL using PDO with prepared statements.
มุมมอง 1512 ปีที่แล้ว
Web Project in PHP & MySQL (Part 4): Insert form data in MySQL using PDO with prepared statements.
Web Project in PHP & MySQL (Part 3): Working with HTML Form in PHP using POST method.
มุมมอง 852 ปีที่แล้ว
Web Project in PHP & MySQL (Part 3): Working with HTML Form in PHP using POST method.
Web Project in PHP & MySQL (Part 2): Adding CSS to HTML & PHP Templates
มุมมอง 832 ปีที่แล้ว
Web Project in PHP & MySQL (Part 2): Adding CSS to HTML & PHP Templates
Web Project in PHP & MySQL (Part 1): Getting Started HTML & PHP Templates
มุมมอง 1822 ปีที่แล้ว
Web Project in PHP & MySQL (Part 1): Getting Started HTML & PHP Templates
Introduction to Enterprise Resource Planning(ERP)
มุมมอง 28K3 ปีที่แล้ว
Introduction to Enterprise Resource Planning(ERP)
Drawing ER Diagram in Google Docs | DBMS Project Report with Sample Project | Part 2B
มุมมอง 7K3 ปีที่แล้ว
Drawing ER Diagram in Google Docs | DBMS Project Report with Sample Project | Part 2B
Final Project Report and Advice and Tips | DBMS Project Report with Sample Project | Closing Video
มุมมอง 3.8K3 ปีที่แล้ว
Final Project Report and Advice and Tips | DBMS Project Report with Sample Project | Closing Video
MySQL Implementation | DBMS Project Report with Sample Project | Part 4
มุมมอง 3.2K3 ปีที่แล้ว
MySQL Implementation | DBMS Project Report with Sample Project | Part 4
Mapping ER Model to Relational Model | DBMS Project Report with Sample Project | Part 3
มุมมอง 3.8K3 ปีที่แล้ว
Mapping ER Model to Relational Model | DBMS Project Report with Sample Project | Part 3
ER Diagram | DBMS Project Report with Sample Project | Part 2A
มุมมอง 3.7K3 ปีที่แล้ว
ER Diagram | DBMS Project Report with Sample Project | Part 2A
Database Management System Project Basics
มุมมอง 8K3 ปีที่แล้ว
Database Management System Project Basics
Project Background and Identifying Entities | DBMS Project Report with Sample Project | Part 1
มุมมอง 6K3 ปีที่แล้ว
Project Background and Identifying Entities | DBMS Project Report with Sample Project | Part 1
Introduction to Enterprise Information Systems
มุมมอง 11K3 ปีที่แล้ว
Introduction to Enterprise Information Systems
Anomalies in Databases and Normalization Practice Question for DBMS Exams
มุมมอง 9K3 ปีที่แล้ว
Anomalies in Databases and Normalization Practice Question for DBMS Exams
Normalization Practice Question up to 3NF for DBMS Exams
มุมมอง 67K3 ปีที่แล้ว
Normalization Practice Question up to 3NF for DBMS Exams
Normalization Question with Solution up to BCNF for DBMS Exams
มุมมอง 26K3 ปีที่แล้ว
Normalization Question with Solution up to BCNF for DBMS Exams
ER diagram for a commercial bank (for DBMS exams).
มุมมอง 3.3K3 ปีที่แล้ว
ER diagram for a commercial bank (for DBMS exams).
ER Diagram(example with solution) for a college based on the given conditions
มุมมอง 10K3 ปีที่แล้ว
ER Diagram(example with solution) for a college based on the given conditions
👍
good
Thanks a lot sir 🙂
Thanks. However, this is confusing. In 4:30, you say or imply that a candidate key can only have one attribute. However, this is not true, afaik. A candidate key can be minimal and still have 2 or more or more attributes, depending on the relation it belongs to.
Mannnnnnnnnnnnnnnnnnnnnnnnnnny Thannnnnnnnnnnnnnnnnnnnnks so amaizing explainition
Hya copy ma garera bujhako vaye hunthyo k lekhya nai clear vayena😢
Good handing writing
In revoke , there will be from instead of to 😅
Extremely well explained without convoluted examples and fancy words, thanks!!
Simple and Concised explanation
you are very irritated sir
Just tell in confidence why your voice is so low!?
Thank you!
in 1 short clearly understand no need to watch full video great thank you sir
Example ❤
This helped me so much and is simple Thank you
in c why it is bus join booking i think it will be bus join passenger bcz it say passenger pid...please let me correct
Excellent 👍
Can we solve part c the following way S1<- σStudentName="JohnSmith"(Student) S2<-S1*College S3<-σTeachingSubject="Computer Organization"(Teacher) S4<-πTeacherName(S2*S3)
this guy is allergic to cartesian product
english balna aaudaina na vana. nepali bata sikauni
thank you brother. this is very usefull.
I have been trying to figure out the difference for quite a while. Thank you for clearing it up. Thank you for all your videos.
Page mere se le leta bhai agar tumhe page ki itni kAmi hai toh 8:26
its to hard to understand what u r trying to teach pls be more clear cause i m boot
why can't we use sigma in last question ?
Thank You Sir❤
Good Teaching Worst Handwriting 🙂
Hand writing not at all good
Who is here from IIC, Itahari? 😂
Life saver.
poor explanation
Very nice
Good Good Good explanation
Great
very bad hand writing
thank you..its a helpful video❤
Background sound is so annoying k
background annoying haina tme annoying ho padha na voli exam xa yarr😑
A vagwan ko hok feri🤣 chinnuna jannu
Sir in c) question college relation is not used but you have joined the college by join whether it is mandatory to join all the relation or not
It’s because of common attribute. Teacher ID is common on Teacher Table as well as on College students Table.
Which symbol is used for or
improve your english please
Sometimes all a student needs is a video like this , I knew relational algebras in our course was not so vast and tough, I just needed some right examples to revise from thanks mate
why did you not join passenger table in the third question? shouldn't it be passenger join bus join booking??
Because pid is also there in booking table so no need to join passenger table
@@stergamingyt3594 what about dest bro
No of Hours worked determines total charge then it is transitive dependency
sir nepali mai video banaununa TU ko question solve garera
AWESOME!
You have to write both SQL Query + Relational Algebra
Thanks for your question cause its better for practise as exam question.
3000 لايك و نطلع لايف
thank you so much this video was very helpfull