Written by BLOGDAY Updated at Aug 16, 2024 | Reading time: 5
Share huge data set among many people
Quick and easy to find information
90% of the tables in database will be linked with another tables.
10%of the tables will be independent.
There are three types of relationships between tables
Tables can have a single / multiple relationships or may not have relationships.
Structured data - 2 dimensional data Rows,Columns
PrimaryKey in one table will be given as ForiegnKey in another table to build relationship.
PrimaryKey & ForiegnKey with relationship between them.
1 to 1 - any PrimaryKey can become ForiegnKey
1 to many employees in a department
PK of parent table will be FK in child table
Department table Deptid(PK),DeptName,
Employees Table Empid,EmpName,DeptId(FK)
New table will be created and extra column will be added(Bridge Table)
Patient Table(PatientNo(PK),PatientName,Adress),
Doctors Table(DoctorNo(PK),Name,Qualification,Salary, DateOfJoining, DateOfResigning)
SDLC-Software Development Life Cycle
Domain expert(SRS documentation)
ERD(Entity Relationship Diagram)
Peter Chan-Used to design Database
SQL server performs existence check when we create relationship.
commands (DDL,DML,DQL,DCL,TCL)
Nov 14, 2024 | Arabic blog
Nov 14, 2024 | Business & Entrepreneurship
Nov 12, 2024 | Cybersecurity
Nov 12, 2024 | Web Development
Nov 10, 2024 | Arabic blog
كتاب "أسرار استخدام شبكة انستقرام" هو دليل شامل يهدف إلى تزويد القارئ بالمع...
Read moreالخطوات الأساسية و الإحترافية لتصميم الشعارات المونوجرام من البداية للنهاية...
Read moreCanva for Productivity: Design Faster & Smarter with Time-Saving Techni...
Read moreLearn MERN stack by building real-world applications with Node, Express, Mo...
Read more