Scene 1 (0s)
RELATIONAL DATABASES. By Masagurwoth Christ & Jamich Timothy.
Scene 2 (10s)
What is Relational Databases?. A relational database organizes data into tables with predefined relationships, making it easy to understand how different pieces of information connect..
Scene 3 (21s)
Identify the types of relationship that can be Created in a relational databases.
Scene 4 (33s)
1) One-to-one. A single record in one table can be associated with only one record in another table, and vice versa. Example: An employee and their unique access badge, or a user and their profile information..
Scene 5 (48s)
2) One-to-many. A single record in the first table can be associated with multiple records in the second table, but each record in the second table can only be associated with one record in the first. Example: A customer can have many orders, but each order belongs to only one customer..
Scene 6 (1m 22s)
3) Many-to-many. A single record in one table can be associated with many records in the second table, and a single record in the second table can also be associated with many records in the first. Example: A student can enroll in many courses, and a course can have many students. This type of relationship is often implemented using a separate "junction" table that links the two original tables..
Scene 7 (1m 44s)
Reduced redundancy: By storing data in separate, related tables, relational databases minimize data duplication. Data accuracy: Constraints like primary and foreign keys ensure data remains accurate and consistent across the database. ACID compliance: They follow ACID (Atomicity, Consistency, Isolation, Durability) properties, which guarantee that transactions are processed reliably and that the database returns to a consistent state after any failure..
Scene 8 (2m 4s)
The End. God bless you Thank You.