Create an SQL database of the above ER-diagram using “create table” statements. The type of attribute “quantity” is integer, “delivery_timestamp” is timestamp, and, for all the others, the type is varchar (up to 100 chars)

Write SQL update statements to do the following on the database schema shown in Figure 1.i. Insert a new course, <‘Knowledge Engineering’, ‘CS4390’, 3, ‘CS’>.ii. Delete the record for the student whose name is ‘Smith’ and whose student number is 17.

Write an SQL query to fetch the different projects available from the EmployeeSalary table.

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)

Express the following SQL code in Relational Algebra form.SELECT *FROM COURSEWHERE (COURSE.COLLEGE <> ’Business’OR COURSE.COLLEGE <> ’Engineering’)AND COURSE.CREDIT = ’U’;

Using the Henry Books database,Henry Books no longer carries books written by Barbara Owen. Delete this author from the authors table.  You will insert 2 snips for this question. What construct did you use to delete author Barbara Owens? Insert the snip of the construct used:     Insert the snip of the authors table.  Be sure all rows are displayed:

This assignment is aimed at building an understanding of how to improve performance within databases by taking advantage the computers hardware by modifying MS SQL settings Prerequisites: Completion of Assignment 1B, reading of Module Readings and Slides. Run the following query to understand how much Memory is currently in use in the database: SELECT   physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB,    large_page_allocations_kb/1024 AS sql_large_page_allocations_MB,    locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB,    virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB,    virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB,    virtual_address_space_available_kb/1024 AS sql_VAS_available_MB,    page_fault_count AS sql_page_fault_count,    memory_utilization_percentage AS sql_memory_utilization_percentage,    process_physical_memory_low AS sql_process_physical_memory_low,    process_virtual_memory_low AS…

I need help with this question for my Database Management class for SQL developer. Thank you   REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE) CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM) ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM) ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE)   Question: List TOY category items and orders placed for them.  Report:  Item_Num, Description, Order_Num, and Order_Date

I NEED HELP WITH THIS QUESTION FOR MY DATABASE MANAGEMENT CLASS FOR SQL DEVELOPER 5. Now compute Average GPA in each class. Display class_code, Class_GPA. Assume all courses are 3 credit courses. A general formula for GPA would be sum(gradepoints x Hrs)/sum(Hrs). Here you can just take an average of gradepoints as the credit hours are same for all courses.