Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
DBMS Korth Edition 6 Exercise 7 Question 9 (Page No. 317)
ajaysoni1924
asked
in
Databases
Mar 28, 2019
238
views
0
votes
0
votes
Suppose the advisor relationship was one-to-one. What extra constraints
are required on the relation advisor to ensure that the one-to-one cardinality
constraint is enforced?
databases
korth-edition6
database-design
er-diagram
descriptive
ajaysoni1924
asked
in
Databases
Mar 28, 2019
by
ajaysoni1924
238
views
answer
comment
Follow
share this
share
0 Comments
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
0
Answers
← Previous
Next →
← Previous in category
Next in category →
Related questions
0
votes
0
votes
0
answers
1
ajaysoni1924
asked
in
Databases
Mar 28, 2019
331
views
DBMS Korth Edition 6 Exercise 7 Question 12 (Page No. 317-318)
Figure shows a lattice structure of generalization and specialization (attributes not shown). For entity sets A, B, and C, explain how attributes are inherited from the higher-level entity sets X and Y. Discuss how to handle a case where an attribute of X has the same name as some attribute of Y.
ajaysoni1924
asked
in
Databases
Mar 28, 2019
by
ajaysoni1924
331
views
databases
korth-edition6
database-design
er-diagram
descriptive
0
votes
0
votes
0
answers
2
ajaysoni1924
asked
in
Databases
Mar 28, 2019
639
views
DBMS Korth Edition 6 Exercise 7 Question 11 (Page No. 317)
In SQL, foreign key constraints can only reference the primary key attributes of the referenced relation, or other attributes declared to be a super key using the unique constraint. As a result, total participation constraints on a ... 4.4.7 of korth). (Unfortunately, these features are not supported on any widely used database currently.)
ajaysoni1924
asked
in
Databases
Mar 28, 2019
by
ajaysoni1924
639
views
databases
korth-edition6
database-design
er-diagram
descriptive
2
votes
2
votes
0
answers
3
ajaysoni1924
asked
in
Databases
Mar 28, 2019
512
views
DBMS Korth Edition 6 Exercise 7 Question 10 (Page No. 317)
Consider a many-to-one relationship R between entity sets A and B. Suppose the relation created from R is combined with the relation created from A. In SQL, attributes participating in a foreign key constraint can be null. Explain how a constraint on total participation of A in R can be enforced using not null constraints in SQL.
ajaysoni1924
asked
in
Databases
Mar 28, 2019
by
ajaysoni1924
512
views
databases
korth-edition6
database-design
er-diagram
descriptive
0
votes
0
votes
0
answers
4
ajaysoni1924
asked
in
Databases
Mar 28, 2019
161
views
DBMS Korth Edition 6 Exercise 7 Question 8 (Page No. 317)
Consider a relation such as sec_course, generated from a many-to-one relationship sec_course. Do the primary and foreign key constraints created on the relation enforce the many-to-one cardinality constraint? Explain why.
ajaysoni1924
asked
in
Databases
Mar 28, 2019
by
ajaysoni1924
161
views
databases
korth-edition6
database-design
er-diagram
descriptive
Subscribe to GATE CSE 2023 Test Series
Subscribe to GO Classes for GATE CSE 2023
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
From Rank 4200 to 64: My Journey to Success in GATE CSE Exam
What are the key things to focus on during the final 10-15 days before the GATE exam to improve performance?
All India GO Classes Mock test
NTA UGC NET JRF December 2022 Apply Online Form 2023
Life happens, just chill and do hardwork
Subjects
All categories
General Aptitude
(2.5k)
Engineering Mathematics
(9.3k)
Digital Logic
(3.3k)
Programming and DS
(5.8k)
Algorithms
(4.6k)
Theory of Computation
(6.7k)
Compiler Design
(2.3k)
Operating System
(5.0k)
Databases
(4.6k)
CO and Architecture
(3.8k)
Computer Networks
(4.6k)
Non GATE
(1.3k)
Others
(2.4k)
Admissions
(649)
Exam Queries
(842)
Tier 1 Placement Questions
(17)
Job Queries
(74)
Projects
(9)
Unknown Category
(853)
Recent Blog Comments
@abhi_3_0_12 bro revise now, Gate is on upcoming...
I want to buy the test series today but I want to...
@mahendrapatel The more you give those (some...
@ChatGPT bhai muze vo test bhi dena tha...
AIMT is live now:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy
