04 (10 Marks) Consider the Banking database: (Answer 2 only) branch (branch-name, branch-city, assets) customer (customer-name, customer-street, customer-only) account (account-number, branch-name, balance) loan (loan-number, branch-name, amount) depositor (customer-name, account-number) borrower (customer-name, loan-number) A) Use the Relational Algebra to Explain the following queries: 1. Gamount>1200 (loan) 2. Ioan-number (amount > 1200 (loan)) 3. Icustomer-name (borrower) Icustomer-name (depositor) B) Use the UML to represent the Banking database. C) Use SQL to write 4 different queries from Banking database.

04 (10 Marks) Consider the Banking database: (Answer 2 only) branch (branch-name, branch-city, assets) customer (customer-name, customer-street, customer-only) account (account-number, branch-name, balance) loan (loan-number, branch-name, amount) depositor (customer-name, account-number) borrower (customer-name, loan-number) A) Use the Relational Algebra to Explain the following queries: 1. Gamount>1200 (loan) 2. Ioan-number (amount > 1200 (loan)) 3. Icustomer-name (borrower) Icustomer-name (depositor) B) Use the UML to represent the Banking database. C) Use SQL to write 4 different queries from Banking database.

C++ for Engineers and Scientists

4th Edition

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Bronson, Gary J.

Chapter5: Repetition Statements

Section: Chapter Questions

Problem 11PP

See similar textbooks

Similar questions

1.Compute the values of the following expressions if x is 1, y is 4 and z is 14. Assume thattrue relations have a value of 1 (I want to see how these problems are worked out) .a. x+5<=z-(x||z)-y b. z/y%z-6<=!y c. x>=1&&y==3+y||z<14 d. x-!y-y<=z*z/6>y
(2)List the names of the production companies, and the titles and years of their movies. Include allproduction companies, even the ones without movies. Sort alphabetically by the production companyname. ( so there a table of 'movie' and a table of 'production’）
a) Find names and surnames of professors who teach a course in the "Biology" program: π(first_name, last_name)(σ(course_name = "Biology")(Course ⨝ Professor)) b) Find the student IDs and names of students who have not taken any exam (from any course): π(student_id, first_name, last_name)(Student - π(student_id)(Exam)) c) Find student IDs of students who have passed every exam from the "Data Science" program: π(student_id)(Student ⨝ (σ(programme = "Data Science")(Course) ⨝ (Student.student_id = Exam.student_id) ⨝ (Exam.grade >= 5))) d) Find the course IDs and names of courses that have been passed by at least two different students: π(course_id, course_name)(Course ⨝ Exam) ÷ ρ(count(students_passed), count(students_passed)(Course ⨝ Exam)) do these solutions fulfil these requirements 2. Use RELATIONAL ALGEBRA to write the following queries:a) Find names and surnames of professors, who teach a course in "Biology" programmeb) Find the student IDs and names of students who have not…
Relational Operation My Solutions > Let \( X=8 \), perform some relational operation that will address the following problems: 1. Is \( X \) less than 5 ? place the result as Answer1. 2. Is \( \mathrm{X} \) in between 9 and 15 ? place the result as Answer2. 3. Is \( X \) an odd number 5 ? place the result as Answer3. 4. Is \( \mathrm{X} \) greater than 13 or less than 2 ? place the result as Answer4. 5. Is \( \mathrm{X} \) not equal to 4 or not equal to 6 ? place the result as Answer5. Script 0
3. Create a table for student mark list and insert the values for name, id, m1,m2,m3,m4,m5, total and grade of each student. Calculate the grades using “if else / nested if” statement and display the total no. of student, total marks and grade of each student.Output:Total 5 Students Student:Kavita, Marks:98 Student:Pritam, Marks:97 Student:Ayan, Marks:78 Student:Rishav, Marks:87 Student:Aziz, Marks:92 Do it in oracle sql
- Identify the Partial Dependencies in the Rental relation. - Give one example of one problem with data that can arise when inserting new data in this table that is a result of partial dependencies. - Normalize the Rental relation to 2NF. - Give one example of one problem that can arise when updating data that is a result of transitive dependencies. - Normalize to 3NF.
- Delete the salesman who has the highest salary among all salesmen
Construct the Table
Secret key between A and B.
9.use the data which is given as shown bwlow to Write a SQL statement to display the most expensive and the cheapest product (list price). Display product ID, product name, and the list price.
(b) Using IF function, write a formula in cell range D24 to display your recommendation. Hint: IF the Weighted Score of VDI is more than DaaS, then VDI should be recommended, else DaaS should be recommended. (g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55. Screenshots attached thnaks
Reference 4