In which normal form (unnormalised, first normal form, second normal form or third normal form) is each of the below? Clearly motivate your answer. Tables below

Fill in the blanks with the appropriate words from the options given. Aggregate functions can be used in the select list or the____clause of a select statement or subquery. They cannot be used in a _clause. Group by, where O Where, having O Having, where Group by, having

PLS HELP ME : Write expressions of relational algebra to answer the following queries  Find MaMH and TenMH of all courses having SOTIET greater than 45. Find MaSV, HoSV, TenSV of all students of the department Hệ thống thông tin. (denoted department name is TenMH) Find MaKH, TenKH of all departments having no students. (denotation of departments is MaKH, , student code is denoted by MaSV) 4. Find MaMH, TenMH of all courses learned by both Lê Kim Lan and Trần Minh Chánh. (the symbol of the courses is MAKH) 5. Find the MaSV, HoSV, TenSV of student having the highest scholarship. (the symbol for the scholarship is HOCBONG) 6. Find the MaSV, HoSV, TenSV of all students participating in at least two different courses. 7. Find the MaSV, HoSV, TenSV of all students participating in one course many times.

Write SQL queries for the following statements. 1) Write SQL code which declares two variables for name and address. Store your name and address in respective variables. Display name and address in a single line using print statement. 2) Display table of 10 in given format using 10 x 1 = 10 10 x 2 = 20 . . . 10 x 10 = 100. 3) Write a code which declares a variable and stores age of youngest employee from “Employee” table. And display name of youngest employee 5 times his. 4) Assume that in “Employee” table, Emp_id are assigned from 1 to onward. ie first employee’s eid is 1, second employee’s eid is 2 and so on. Write a code that displays name of eldest employee without using aggregate function of “max”. You can use count function

Below is “Book Order,” the only table in library management system’s database. The design of “Book Order” as you may tell is in the zero normal formal form, you as the database designer want to convert the design into the third normal form.   Order ID Special order date Customer ID Customer last name Customer First name Customer birth date Book ISBN1 Book Title 1 Book Author 1 Book publication year 1 Book ISBN2 Book Title 2 Book Author 2 Book publication year 2 Store ID Store name Store location Special order status     Book Order(Order ID, Special order date, Customer ID, Customer last name, Customer First name, Customer birth date, Book ISBN1, Book Title 1, Book Author 1, Book publication year 1, Book ISBN2, Book Title 2, Book Author 2, Book publication year 2, Store ID, Store name, Store location, Special order status)

What exactly is Independent Sub Procedure?

Under what circumstances is it appropriate to say that two select statements from the same table both satisfy the union's requirements?