Dark Mode

Recent questions tagged korth-edition6

0 votes

0 answers

91

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

204 views

0 votes

0 answers

92

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

347 views

1 vote

0 answers

93

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

267 views

0 votes

0 answers

94

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

295 views

0 votes

0 answers

95

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

99 views

0 votes

0 answers

96

DBMS Korth Edition 6 Exercise 1 Question 12 (Page No. 34)
Describe at least 3 tables that might be used to store information in a social-networking system such as Facebook.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

294 views

0 votes

0 answers

97

DBMS Korth Edition 6 Exercise 1 Question 11 (Page No. 34)
List at least two reasons why database systems support data manipulation using a declarative query language such as SQL, instead of just providing a a library of C or C++ functions to carry out data manipulation.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

389 views

0 votes

0 answers

98

DBMS Korth Edition 6 Exercise 1 Question 10 (Page No. 34)
List five responsibilities of a database-management system. For each responsibility, explain the problems that would arise if the responsibility were not discharged.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

101 views

0 votes

1 answer

99

DBMS Korth Edition 6 Exercise 1 Question 9 (Page No. 34)
Explain the concept of physical data independence, and its importance in database systems.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

257 views

0 votes

1 answer

100

DBMS Korth Edition 6 Exercise 1 Question 8 (Page No. 34)
List four significant differences between a file-processing system and a DBMS.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

554 views

0 votes

0 answers

101

DBMS Korth Edition 6 Exercise 1 Question 7 (Page No. 34)
List four applications you have used that most likely employed a database system to store persistent data

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

187 views

0 votes

0 answers

102

DBMS Korth Edition 6 Exercise 1 Question 6 (Page No. 34)
Keyword queries used in Web search are quite different from database queries. List key differences between the two, in terms of the way the queries are specified, and in terms of what is the result of a query.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

155 views

0 votes

0 answers

103

DBMS Korth Edition 6 Exercise 1 Question 3 (Page No. 34)
List six major steps that you would take in setting up a database for a particular enterprise.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

96 views

0 votes

0 answers

104

DBMS Korth Edition 6 Exercise 1 Question 2 (Page No. 33)
List five ways in which the type declaration system of a language such as Java or C++ differs from the data definition language used in a database.

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

79 views

0 votes

1 answer

105

DBMS Korth Edition 6 Exercise 1 Question 1 (Page No. 33)
What Are two Disadvantages of Databases?

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

137 views

Page:

« prev
1
2
3
4

Recent questions tagged korth-edition6