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
Recent questions tagged relational-model
0
votes
0
answers
91
DBMS Korth Edition 6 Exercise 2 Question 15 (Page No. 55)
Discuss the relative merits of procedural and nonprocedural languages.
ajaysoni1924
asked
in
Databases
Mar 25, 2019
by
ajaysoni1924
221
views
relational-model
databases
korth-edition6
descriptive
0
votes
0
answers
92
DBMS Korth Edition 6 Exercise 2 Question 14 (Page No. 55)
List two reasons why null values might be introduced into the database.
ajaysoni1924
asked
in
Databases
Mar 25, 2019
by
ajaysoni1924
169
views
databases
korth-edition6
relational-model
descriptive
0
votes
2
answers
93
DBMS Korth Edition 6 Exercise 2 Question 13 (Page No. 55)
Consider the bank database. Give an expression in the relational algebra for each of the following queries: a. Find all loan numbers with a loan value greater than ... borrower (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number)
ajaysoni1924
asked
in
Databases
Mar 25, 2019
by
ajaysoni1924
2.3k
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
94
DBMS Korth Edition 6 Exercise 2 Question 12 (Page No. 55)
Consider the relational database shown below. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who work for First Bank Corporation . b. Find the names and ... . employee (person name, street, city) works (person name, company name, salary) company (company name, city)
ajaysoni1924
asked
in
Databases
Mar 25, 2019
by
ajaysoni1924
534
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
1
answer
95
DBMS Korth Edition 6 Exercise 2 Question 11 (Page No. 54)
Describe the differences in meaning between the terms relation and relation schema.
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
293
views
databases
korth-edition6
relational-model
descriptive
–1
vote
0
answers
96
DBMS Korth Edition 6 Exercise 2 Question 10 (Page No. 54)
Consider the advisor relation shown in Figure , with s id as the primary key of advisor. Suppose a student can have more than one advisor. Then, would s id still be a primary key of the advisor relation? If not, what should the primary key of advisor be?
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
422
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
97
DBMS Korth Edition 6 Exercise 2 Question 9 (Page No. 55)
Consider the bank database given below. a. What are the appropriate primary keys? b. Given your choice of primary keys, identify appropriate foreign keys. branch(branch name, branch city, assets) customer (customer name, ... (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
387
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
1
answer
98
DBMS Korth Edition 6 Exercise 2 Question 8 (Page No. 54)
Consider the bank database given below. Give an expression in the relational algebra for each of the following queries. a. Find the names of all branches located in Chicago . b. Find the names of all borrowers who ... (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
1.5k
views
databases
korth-edition6
relational-model
relational-algebra
1
vote
0
answers
99
DBMS Korth Edition 6 Exercise 2 Question 7 (Page No. 54)
Consider the relational database given below. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who live in city Miami . b. Find the names of all employees ... . employee (person name, street, city) works (person name, company name, salary) company (company name, city)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
632
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
100
DBMS Korth Edition 6 Exercise 2 Question 6 (Page No. 54)
Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. $\sigma _{year\geq 2009}(takes)\Join student$ $\sigma _{year\geq 2009}(takes \Join student)$ $\pi _{ID,name,course_id}(student \times takes)$
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
401
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
101
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
358
views
databases
korth-edition6
relational-model
descriptive
relational-algebra
1
vote
0
answers
102
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
493
views
databases
korth-edition6
relational-model
rdbms
1
vote
0
answers
103
DBMS Korth Edition 6 Exercise 2 Question 3 (Page No. 53)
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.
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
400
views
databases
korth-edition6
relational-model
descriptive
0
votes
0
answers
104
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
answers
105
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
171
views
databases
korth-edition6
relational-model
descriptive
0
votes
0
answers
106
DBMS, Made easy practice book
Can primary keys be updated using sql update query? Is such a query accepted/rejected?
Harsh Kumar
asked
in
Databases
Dec 11, 2018
by
Harsh Kumar
502
views
databases
sql
relational-model
1
vote
2
answers
107
NIELIT 2018-42
____ symbol is used to denote derived attributes in ER model Dashed ellipse Squared ellipse Ellipse with attribute name underlined Rectangular Box
Arjun
asked
in
Databases
Dec 7, 2018
by
Arjun
1.4k
views
nielit-2018
databases
relational-model
1
vote
2
answers
108
Made Easy Workbook : Relational Model
What should be correct option for 1. and why...?
ajaysoni1924
asked
in
Databases
May 22, 2018
by
ajaysoni1924
739
views
databases
er-diagram
er-to-relational
relational-model
0
votes
3
answers
109
relational model
minimum no. of tables required....!!! How to do such question where aggregation generalization or specialization is involved
ajaysoni1924
asked
in
Databases
May 22, 2018
by
ajaysoni1924
498
views
databases
er-diagram
er-to-relational
relational-model
0
votes
2
answers
110
ACE Practice book DBMS
Participation Constraints can not be represented for a. Unary relationships b. Binary relationships c. Ternary relationships d. None
Arnab Bhadra
asked
in
Databases
Jun 21, 2017
by
Arnab Bhadra
1.3k
views
er-diagram
relational-model
databases
1
vote
1
answer
111
Relational Model
Suppose that we have a relation schema R(A, B, C) representing a relationship between two entity sets with keys A and B, respectively and suppose that R has the FD: A $\rightarrow$ B, then the relationship in relational model possible is __________ . A. One to many B. One to one C. Many to one D. Many to many
Samujjal Das
asked
in
Databases
Nov 12, 2016
by
Samujjal Das
725
views
databases
relational-model
entity-sets
6
votes
2
answers
112
ISRO2014-11
An aggregation association is drawn using which symbol? A line which loops back on to the same table A small open diamond at the end of a line connecting two tables A small closed diamond at the end of a line connecting two tables A small closed triangle at the end of a line connecting two tables
Anu
asked
in
Databases
Jun 28, 2016
by
Anu
6.5k
views
isro2014
databases
relational-model
7
votes
2
answers
113
ISRO2015-21
If $\text{D}_1,\text{D}_2, \dots \text{D}_n$ are domains in a relational model, then the relation is a table, which is a subset of $\text{D}_1 \oplus \text{D}_2 \oplus \dots \oplus \text{D}_n$ $\text{D}_1 \times \text{D}_2 \times \dots \times \text{D}_n$ $\text{D}_1 \cup \text{D}_2 \cup \dots \cup \text{D}_n$ $\text{D}_1 \cap \text{D}_2 \cap \dots \cap \text{D}_n$
Shimpy Goyal
asked
in
Databases
Jun 25, 2015
by
Shimpy Goyal
4.8k
views
databases
isro2015
relational-model
6
votes
1
answer
114
GATE CSE 1992 | Question: 13a
How is redundancy reduced in the following models? Hierarchical Network Relational
Kathleen
asked
in
Databases
Sep 13, 2014
by
Kathleen
994
views
gate1992
databases
descriptive
relational-model
Page:
« prev
1
2
3
4
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 questions tagged relational-model
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:...