Relational Database
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Relational Database as PDF for free.
More details
- Words: 92
- Pages: 7
Relational Database
What is a Relationship? • Relationship within Mammals!!! Types: – One to many – One to one – Many to many
In Database?? • eg. Record of a customer in sales department… Customer
Orders
Items
Another example…. • Student in an Educational institute….. Student
Course
Modules Room
Teacher type
In Access Database…..
Referential Integrity • Must be set when a relationship is created between tables. • To prevent non-existent data to be inputted into a relational database. • Example………..
Think about this!!! as it will be visited at later stage
What is a Relationship? • Relationship within Mammals!!! Types: – One to many – One to one – Many to many
In Database?? • eg. Record of a customer in sales department… Customer
Orders
Items
Another example…. • Student in an Educational institute….. Student
Course
Modules Room
Teacher type
In Access Database…..
Referential Integrity • Must be set when a relationship is created between tables. • To prevent non-existent data to be inputted into a relational database. • Example………..
Think about this!!! as it will be visited at later stage
Related Documents
Relational Database
June 2020 14
Relational Database
November 2019 18
Relational Database Management System
June 2020 16
Relational Database Design
June 2020 9
Planning A Relational Database
December 2019 21
Neutrosophic Relational Database
November 2019 19More Documents from "Anonymous 0U9j6BLllB"
Ias 33 Eps
June 2020 16
The Rope
June 2020 18
Fixed Assets Ias 16
June 2020 21
Introduction To Financial Statements And Audit
June 2020 15
Irr Calculation
June 2020 15