The main key of the associated table is the foreign key. As a result, you can't have a primary key and a foreign key in the same column.
To ensure that data in a single column is unique, a primary key is employed. A foreign key is a column or set of columns in a relational database table that connects data from two other tables. It is used to identify a specific record in a relational database table.
The main key in the other table is referred to as the Reference Key. Foreign Key, on the other hand, is how you connect the second table to the primary tables (or Reference Key).
A composite key is a Candidate key that has many attributes. A foreign key is an attribute that is a primary key in its parent table but is not used in the host table. Non-unique and null values may be accepted by foreign keys.
A primary key is a field (or combination of fields) in a table that has values that are unique. Because each record has a separate value for the key, values of the key can be used to refer to whole records. Only one primary key per table is allowed.
Learner's Ratings
3.7
Overall Rating
46%
17%
11%
9%
17%
Reviews
S
Shabbir
5
This course very helpful for me🥰🥰🥰🥰🥰🥰🥰
D
Durgesh Rajbhar
5
i wan a pdf of this course
V
Vinayak Ghatage
5
Best One
K
Khushi Kumari Yadav
5
how can i get pdf of this session
A
Arvind Kumar
5
very nice course for begginer to under stand
H
hemant
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file
J
Juboraj Juboraj
4
Explain details & easy to understand.
A
Aman Kanaujia
4
All good , but provide the data also for the assignment , Without data the interest is less day by day from the course. So, try to solve this problem as asap.
S
Snehil
4
Everything is good but keyboard sounds more harsh and overlap your voice whereas this course is best.
F
FAROOK MOHAMMAD
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file.
Share a personalized message with your friends.