Skip to Content
Home
Events
Forum
Courses
Application
Jobs
Contact us
+1 555-555-5556
Sign in
Contact Us
Home
Events
Forum
Courses
Application
Jobs
Contact us
+1 555-555-5556
Sign in
Contact Us
Courses
DDD-L5DC-86
2_-_Enhancing_Design_(1)
Nav
Home
└
DDD-L5DC-86
└
2_-_Enhancing_Design_(1)
DDD-L5DC-86
0
%
Completed
Course content
Uncategorized
DDD_Topic_1_-_Introduction_to_the_Module
10 xp
Join this Course
to access resources
Join this Course
to access resources
Quiz
2_-_Enhancing_Design_(1)
10 xp
Quiz
DDD_Topic_3_-_Enhancing_Design_(2)
Join this Course
to access resources
Join this Course
to access resources
DDD_Topic_4_-_Data_Retrieval_(1)
DDD_Topic_5_-_Data_Retrieval_(2)
Join this Course
to access resources
Join this Course
to access resources
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
Next
Fullscreen
Share
About
Comments (
0
)
Rating
0
0
There are no comments for now.
Join this Course
to be the first to leave a comment.
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