Dark Mode

Recent questions tagged korth-edition6

0 votes

0 answers

61

DBMS Korth Edition 6 Exercise 3 Question 21 (Page No. 110)
Consider the library database.Write the following queries in SQL. a. Print the names of members who have borrowed any book published by McGraw-Hill . b. Print the names of members who have borrowed all books published by McGraw-Hill ... at all. member(memb no, name, age) book(isbn, title, authors, publisher) borrowed(memb no, isbn, date)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

555 views

0 votes

0 answers

62

DBMS Korth Edition 6 Exercise 3 Question 20 (Page No. 110)
Give an SQL schema definition for the employee database. Choose an appropriate domain for each attribute and an appropriate primary key for each relation schema. here is database employee (employee name, street, city) works (employee name, company name, salary) company (company name, city) manages (employee name, manager name)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

217 views

0 votes

0 answers

63

DBMS Korth Edition 6 Exercise 3 Question 19 (Page No. 110)
Show that, in SQL, <> all is identical to not in.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

150 views

0 votes

1 answer

64

DBMS Korth Edition 6 Exercise 3 Question 18 (Page No. 110)
List two reasons why null values might be introduced into the database.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

796 views

1 vote

0 answers

65

DBMS Korth Edition 6 Exercise 3 Question 17 (Page No. 110)
Consider the relational database given below. Give an expression in SQL for each of the following queries. a. Give all employees of First Bank Corporation a 10 percent raise. b. Give all managers of First Bank Corporation ... ) works (employee name, company name, salary) company (company name, city) manages (employee name, manager name)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

300 views

0 votes

0 answers

66

DBMS Korth Edition 6 Exercise 3 Question 16 (Page No. 109)
Consider the employee database, where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find the names of all employees who work for First Bank Corporation . b. Find all ... ) works (employee name, company name, salary) company (company name, city) manages (employee name, manager name)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

500 views

1 vote

0 answers

67

DBMS Korth Edition 6 Exercise 3 Question 15 (Page No. 109)
Consider the bank database, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find all customers who have an account at all the branches located in Brooklyn . b. ... customer name, loan number) account (account number, branch name, balance ) depositor (customer name, account number)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

748 views

0 votes

0 answers

68

DBMS Korth Edition 6 Exercise 3 Question 14 (Page No. 109)
Consider the insurance database, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find the number of accidents in which the cars belonging to John Smith were involved. b ... , date, location) owns (driver id, license) participated (report number, license, driver id, damage amount)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

696 views

0 votes

0 answers

69

DBMS Korth Edition 6 Exercise 3 Question 13 (Page No. 109)
Write SQL DDL corresponding to the schema given below. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys. person (driver id, name, address) car (license, model, year) accident ... number, date, location) owns (driver id, license) participated (report number, license, driver id, damage amount)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

221 views

0 votes

0 answers

70

DBMS Korth Edition 6 Exercise 3 Question 12 (Page No. 109)
Write the following queries in SQL, using the university schema. a. Create a new course CS-001 , titled Weekly Seminar ,with 0 credits. b. Create a section of this course in Autumn 2009, with sec id of 1. c. Enroll every ... of any course with the word database as a part of the title; ignore case when matching the word with the title.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

468 views

0 votes

0 answers

71

DBMS Korth Edition 6 Exercise 3 Question 11 (Page No. 108)
Write the following queries in SQL, using the university schema. a. Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result. b. Find the ... instructor. d. Find the lowest, across all departments, of the per-department maximum salary computed by the preceding query.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

842 views

0 votes

0 answers

72

DBMS Korth Edition 6 Exercise 3 Question 10 (Page No. 108)
Consider the relational database given below Give an expression in SQL for each of the following queries. a. Modify the database so that Jones now lives in Newtown . b. Give all managers of First Bank Corporation a ... city) works (employee name, company name, salary) company (company name, city) manages (employee name, manager name)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

365 views

0 votes

0 answers

73

DBMS Korth Edition 6 Exercise 3 Question 9 (Page No. 107-108)
Consider the employee database, where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find the names and cities of residence of all employees who work for First Bank ... works (employee name, company name, salary) company (company name, city) manages (employee name, manager name)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

591 views

0 votes

0 answers

74

DBMS Korth Edition 6 Exercise 3 Question 8 (Page No. 107)
Consider the bank database, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find all customers of the bank who have an account but not a loan. b. Find the names ... (customer name, loan number) account (account number, branch name, balance ) depositor (customer name, account number)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

577 views

0 votes

0 answers

75

DBMS Korth Edition 6 Exercise 3 Question 7 (Page No. 107)
Consider the SQL query select distinct p.a1 from p, r1, r2 where p.a1 = r1.a1 or p.a1 = r2.a1 Under what conditions does the preceding query select values of p.a1 that are either in r1 or in r2? Examine carefully the cases where one of r1 or r2 may be empty.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

134 views

0 votes

0 answers

76

DBMS Korth Edition 6 Exercise 3 Question 6 (Page No. 107)
The SQL like operator is case sensitive, but the lower() function on strings can be used to perform case insensitive matching. To show how, write a query that finds departments whose names contain the string “sci” as a substring, regardless of the case.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

106 views

0 votes

0 answers

77

DBMS Korth Edition 6 Exercise 3 Question 5 (Page No. 107)
Suppose that we have a relation marks(ID, score) and we wish to assign grades to students based on the score as follows: grade F if score < 40, grade C if 40 ≤ score < 60, grade B if 60 ≤ score < 80, ... following: a. Display the grade for each student, based on the marks relation. b. Find the number of students with each grade.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

291 views

0 votes

0 answers

78

DBMS Korth Edition 6 Exercise 3 Question 4 (Page No. 106)
Consider the insurance database given below , where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find the total number of people who owned cars that were involved in accidents ... date, location) owns (driver id, license) participated (report number, license, driver id, damage amount)

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

427 views

0 votes

0 answers

79

DBMS Korth Edition 6 Exercise 3 Question 2 (Page No. 106)
Suppose you are given a relation grade points(grade, points), which provides a conversion from letter grades in the takes relation to numeric scores; for example an A grade could be specified to correspond to 4 points, an A− ... by the total credits for the associated courses. c. Find the ID and the grade-point average of every student.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

688 views

0 votes

1 answer

80

DBMS Korth Edition 6 Exercise 3 Question 1 (Page No. 105)
Write the following queries in SQL, using the university schema. (We suggest you actually run these queries on a database, using the sample data that we provide on the Web site of the book, db-book.com. Instructions for ... enrollment, across all sections, in Autumn 2009. g. Find the sections that had themaximum enrollment in Autumn 2009.

ajaysoni1924 asked in Databases Mar 25, 2019

by ajaysoni1924

498 views

0 votes

0 answers

81

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

166 views

0 votes

0 answers

82

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

107 views

0 votes

2 answers

83

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

1.4k views

0 votes

0 answers

84

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

337 views

0 votes

1 answer

85

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

173 views

–1 vote

0 answers

86

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

331 views

0 votes

0 answers

87

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

269 views

0 votes

1 answer

88

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

647 views

1 vote

0 answers

89

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

371 views

0 votes

0 answers

90

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

214 views

Page:

Recent questions tagged korth-edition6