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 8 (Page No. 317)
ajaysoni1924
asked
in
Databases
Mar 28, 2019
162
views
0
votes
0
votes
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.
databases
korth-edition6
database-design
er-diagram
descriptive
ajaysoni1924
asked
in
Databases
Mar 28, 2019
by
ajaysoni1924
162
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
335
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
335
views
databases
korth-edition6
database-design
er-diagram
descriptive
0
votes
0
votes
0
answers
2
ajaysoni1924
asked
in
Databases
Mar 28, 2019
641
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
641
views
databases
korth-edition6
database-design
er-diagram
descriptive
2
votes
2
votes
0
answers
3
ajaysoni1924
asked
in
Databases
Mar 28, 2019
514
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
514
views
databases
korth-edition6
database-design
er-diagram
descriptive
0
votes
0
votes
0
answers
4
ajaysoni1924
asked
in
Databases
Mar 28, 2019
240
views
DBMS Korth Edition 6 Exercise 7 Question 9 (Page No. 317)
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?
ajaysoni1924
asked
in
Databases
Mar 28, 2019
by
ajaysoni1924
240
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
Recruitment of Scientific Officers in the Department of Atomic Energy 2023
GATE CSE 2023 Paper & Analysis - Memory Based
From GATE to Australia
DRDO Previous Year Papers
From Rank 4200 to 64: My Journey to Success in GATE CSE Exam
Subjects
All categories
General Aptitude
(2.5k)
Engineering Mathematics
(9.3k)
Digital Logic
(3.3k)
Programming and DS
(5.9k)
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
(843)
Tier 1 Placement Questions
(17)
Job Queries
(75)
Projects
(9)
Unknown Category
(853)
Recent Blog Comments
Recommend test series??
pressman pdf/ geeksforgeeks
where to study software engineering for BARC
+1
1200/1000 = 1.2
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy
