Register

Recent questions tagged korth-edition6

1 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?
In the instance of instructor shown below, no two instructors havethe same name. From this, can we conclude that name can be used as asuperkey (or primary key) of instruc...
User Avatar
1 votes
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.
Consider the time slot relation. Given that a particular time slot can meetmore than once in a week, explain why day and start time are part of theprimary key of this rel...
User Avatar
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)
Consider the relational database given below . What are the appropriateprimary keys?employee (person name, street, city)works (person name, company name, salary)company ...
User Avatar
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.
Describe at least 3 tables that might be used to store information in asocial-networking system such as Facebook.
User Avatar
2 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.
List at least two reasons why database systems support data manipulationusing a declarative query language such as SQL, instead of just providinga a library of C or C++ f...
User Avatar
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.
List five responsibilities of a database-management system. For each responsibility,explain the problems that would arise if the responsibilitywere not discharged.
User Avatar
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.
Explain the concept of physical data independence, and its importance indatabase systems.
User Avatar
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.
List four significant differences between a file-processing system and aDBMS.
User Avatar
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
List four applications you have used that most likely employed a databasesystem to store persistent data
User Avatar
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.
Keyword queries used in Web search are quite different from databasequeries. List key differences between the two, in terms of the way thequeries are specified, and in te...
User Avatar
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.
List six major steps that you would take in setting up a database for aparticular enterprise.
User Avatar
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.
List five ways in which the type declaration system of a language such asJava or C++ differs from the data definition language used in a database.
User Avatar
Page: