Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Webpage for Databases:
Recent questions tagged databases
0
votes
1
answer
811
DBMS Korth Edition 6 Exercise 3 Question 18 (Page No. 110)
List two reasons why null values might be introduced into the database.
List two reasons why null values might be introduced into the database.
ajaysoni1924
897
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
descriptive
+
–
1
votes
0
answers
812
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)
Consider the relational database given below. Give an expression in SQLfor each of the following queries.a. Give all employees of “First Bank Corporation” a 10 percen...
ajaysoni1924
373
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
813
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)
Consider the employee database, where the primary keys areunderlined. Give an expression in SQL for each of the following queries.a. Find the names of all employees who w...
ajaysoni1924
762
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
1
votes
0
answers
814
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)
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 accou...
ajaysoni1924
1.0k
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
815
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)
Consider the insurance database, where the primary keysare underlined. Construct the following SQL queries for this relationaldatabase.a. Find the number of accidents in ...
ajaysoni1924
796
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
816
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)
Write SQL DDL corresponding to the schema given below. Make anyreasonable assumptions about data types, and be sure to declare primaryand foreign keys.person (driver id, ...
ajaysoni1924
303
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
817
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.
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 thi...
ajaysoni1924
623
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
818
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.
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 dup...
ajaysoni1924
1.1k
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
819
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)
Consider the relational database given below Give an expression in SQLfor each of the following queries.a. Modify the database so that “Jones” now lives in “Newtown...
ajaysoni1924
549
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
820
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)
Consider the employee database, where the primary keys areunderlined. Give an expression in SQL for each of the following queries.a. Find the names and cities of residenc...
ajaysoni1924
929
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
821
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)
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 h...
ajaysoni1924
905
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
822
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.
Consider the SQL queryselect distinct p.a1from p, r1, r2where p.a1 = r1.a1 or p.a1 = r2.a1Under what conditions does the preceding query select values of p.a1 thatare eit...
ajaysoni1924
249
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
823
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.
The SQL like operator is case sensitive, but the lower() function on stringscan be used to perform case insensitive matching. To show how, write aquery that finds departm...
ajaysoni1924
217
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
824
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.
Suppose that we have a relation marks(ID, score) and we wish to assigngrades to students based on the score as follows: grade F if score < 40,grade C if 40 ≤ score < 60...
ajaysoni1924
438
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
825
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)
Consider the insurance database given below , where the primary keysare underlined. Construct the following SQL queries for this relationaldatabase.a. Find the total numb...
ajaysoni1924
676
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
2
votes
0
answers
826
DBMS Korth Edition 6 Exercise 3 Question 3 (Page No. 106)
Write the following inserts, deletes or updates in SQL, using the university schema. Increase the salary of each instructor in the Comp. Sci. department by 10%. Delete all courses that have never been offered (that is, do not occur ... 10,000.
Write the following inserts, deletes or updates in SQL, using the university schema.Increase the salary of each instructor in the Comp. Sci. department by 10%.Delete all ...
ajaysoni1924
557
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
relational-model
sql
+
–
0
votes
0
answers
827
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.
Suppose you are given a relation grade points(grade, points), which providesa conversion from letter grades in the takes relation to numeric scores; forexample an “A”...
ajaysoni1924
841
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
1
answer
828
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.
Write the following queries in SQL, using the university schema. (We suggestyou actually run these queries on a database, using the sample datathat we provide on the Web ...
ajaysoni1924
1.1k
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
sql
+
–
0
votes
0
answers
829
DBMS Korth Edition 6 Exercise 2 Question 15 (Page No. 55)
Discuss the relative merits of procedural and nonprocedural languages.
Discuss the relative merits of procedural and nonprocedural languages.
ajaysoni1924
216
views
ajaysoni1924
asked
Mar 25, 2019
Databases
relational-model
databases
korth-edition6
descriptive
+
–
0
votes
0
answers
830
DBMS Korth Edition 6 Exercise 2 Question 14 (Page No. 55)
List two reasons why null values might be introduced into the database.
List two reasons why null values might be introduced into the database.
ajaysoni1924
165
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
descriptive
+
–
0
votes
2
answers
831
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)
Consider the bank database. Give an expression in the relationalalgebra for each of the following queries:a. Find all loan numbers with a loan value greater than $10,000....
ajaysoni1924
2.3k
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
832
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)
Consider the relational database shown below. Give an expression in therelational algebra to express each of the following queries:a. Find the names of all employees who ...
ajaysoni1924
528
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
1
answer
833
DBMS Korth Edition 6 Exercise 2 Question 11 (Page No. 54)
Describe the differences in meaning between the terms relation and relation schema.
Describe the differences in meaning between the terms relation and relation schema.
ajaysoni1924
282
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
descriptive
+
–
–1
votes
0
answers
834
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?
Consider the advisor relation shown in Figure , with s id as the primarykey of advisor. Suppose a student can have more than one advisor. Then,would s id still be a prima...
ajaysoni1924
416
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
835
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)
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...
ajaysoni1924
382
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
1
answer
836
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)
Consider the bank database given below. Give an expression in the relationalalgebra for each of the following queries.a. Find the names of all branches located in “Chic...
ajaysoni1924
1.5k
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
1
votes
0
answers
837
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)
Consider the relational database given below. Give an expression in therelational algebra to express each of the following queries:a. Find the names of all employees who ...
ajaysoni1924
630
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
838
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)$
Consider the following expressions, which use the result of a relationalalgebra operation as the input to another operation. For each expression,explain in words what the...
ajaysoni1924
400
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
839
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).)$
What is the result of first performing the cross product of student andadvisor, and then performing a selection operation on the result with thepredicate s id = ID? (Usin...
ajaysoni1924
354
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
descriptive
relational-algebra
+
–
1
votes
0
answers
840
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...
ajaysoni1924
485
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
rdbms
+
–
Page:
« prev
1
...
23
24
25
26
27
28
29
30
31
32
33
...
97
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register