Home
About DIA
Daffodil Family
Mission, Vision & History
Message from Chairman
Message From ED
Message From Advisor
Awards & Achievements
Admission
Why Daffodil
Undergraduate Programmes
Fees and Funding
Scholarship
How to apply
Information for Students
Campus Life
Student Services
Daffodil Sports Club
Daffodil Cultural Club
Daffodil Programming Club
Application
Class Schedule
Courses
Support
Events
Forum
DIA WIKI
SOP
Documentary
Presentation
Submitted Assignment
Submitted Assignment List
Contact Us
Exam Status
Exam Status
meeting_details
Sign in
Courses
DDD-L5DC-86
2_-_Enhancing_Design_(1)
Nav
Home
└
DDD-L5DC-86
└
2_-_Enhancing_Design_(1)
DDD-L5DC-86
0 %
Course content
Uncategorized
DDD_Topic_1_-_Introduction_to_the_Module
10 xp
Live
class record
Quiz
2_-_Enhancing_Design_(1)
10 xp
Quiz
DDD_Topic_3_-_Enhancing_Design_(2)
link
class
DDD_Topic_4_-_Data_Retrieval_(1)
DDD_Topic_5_-_Data_Retrieval_(2)
resource
class
DDD_Topic_6_-_Physical_Design_(1)
DDD_Topic_7_-_Physical_Design_(2)
DDD_Topic_8_-_Physical_Design_(3)
DDD_Topic_9_-_Physical_Design_(4)
DDD_Topic_10_-_Distributed_Databases
DDD_Topic_11_-_Data_Warehouses
DDD_Topic_12_-_Module_Overview
DDD-L5DC-86
Test-1
2_-_Enhancing_Design_(1)
10
XP
Prev
Set Done
Next
Fullscreen
About
Comments (
0
)
Statistics
Share
Views
12
Total Views
12
Members Views
0
Public Views
Actions
0
Likes
0
Dislikes
0
Comments
Share on Social Networks
Share Link
Copy Text
Share by mail
Please
login
to share this document by email.
Embed in your website
<iframe src="https://dia.df.daffodil.family/slides/embed/188?page=1" class="o_wslides_iframe_viewer" allowFullScreen="true" height="315" width="420" frameborder="0"></iframe>
Select page to start with
1
.
Relational Integrity constraints is
Relational Integrity constraints in DBMS are referred only primary key
Relational Integrity constraints in DBMS are referred to conditions which must be present for a valid relation
Only check constraint
2
.
Why cannot any part of a primary key be null?
A PRIMARY KEY column is equivalent to UNIQUE
Because a null value, being unknown
might be the same as the value in the primary key of another tuple.
3
.
Functional Dependence
If we know the value of A then we will know the value of B
Independent value
dependent value
4
.
Normalization is the process of
organizing the data in the database to create table
The normal form is used to reduce redundancy from the database table.
The normal form is used to use redundancy from the database table.
5
.
Problems Without Normalization
Null Value
Updation Anomaly,Deletion Anomaly
Insertion Anomaly, Updation Anomaly,Deletion Anomaly