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 2 Question 3 (Page No. 53)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
401
views
1
vote
1
vote
Consider the time slot relation. Given that a particular time slot can meet
more than once in a week, explain why day and start time are part of the
primary key of this relation, while end time is not.
databases
korth-edition6
relational-model
descriptive
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
401
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 23, 2019
360
views
DBMS Korth Edition 6 Exercise 2 Question 5 (Page No. 53)
What is the result of first performing the cross product of student and advisor, and then performing a selection operation on the result with the predicate s id = ID? (Using the symbolic notation of relational algebra, this query can be written as $\sigma sid= ID(student\times adviser).)$
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
360
views
databases
korth-edition6
relational-model
descriptive
relational-algebra
0
votes
0
votes
0
answers
2
ajaysoni1924
asked
in
Databases
Mar 23, 2019
437
views
DBMS Korth Edition 6 Exercise 2 Question 2 (Page No. 53)
Consider the foreign key constraint from the dept name attribute of instructor to the department relation. Give examples of inserts and deletes to these relations, which can cause a violation of the foreign key constraint.
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
437
views
databases
korth-edition6
relational-model
descriptive
0
votes
0
votes
0
answers
3
ajaysoni1924
asked
in
Databases
Mar 23, 2019
173
views
DBMS Korth Edition 6 Exercise 2 Question 1 (Page No. 53)
Consider the relational database given below . What are the appropriate primary keys? employee (person name, street, city) works (person name, company name, salary) company (company name, city)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
173
views
databases
korth-edition6
relational-model
descriptive
1
vote
1
vote
0
answers
4
ajaysoni1924
asked
in
Databases
Mar 23, 2019
497
views
DBMS Korth Edition 6 Exercise 2 Question 4 (Page No. 53)
In the instance of instructor shown below, no two instructors have the same name. From this, can we conclude that name can be used as a superkey (or primary key) of instructor?
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
497
views
databases
korth-edition6
relational-model
rdbms
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
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
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy
