Refer to the given tables. Salesperson Salesperson Commission Year of Department Manager Number Name Name Percentage Hire Number Product Number SALESPERSON table Salesperson Number PRODUCT table Product Name QUANTITY table Product Number Unit Price Quantity Which feature of the tables makes it clear that they are in second normal form? O Each non-key attribute is fully functionally dependent on the key of that table. The tables are completely free of data redundancy. O Each non-key attribute functions completely independently of the key of that table. The tables are dependent on one another in descending order. Sm

Please solve Quickly C++ programming language

database

SQL Queries:   Given the following schema. Primary keys are underlined and highlighted in yellow and foreign keys are bold. The meaning of the relations is straightforward. Medical_Staff(MS_Id, MS_First, MS_Last, MS_PhoneNumber, MS_Occupation, Salary) Blood_Bank(Bank_Id, Bank_Name, Bank_Street, Bank_City, Bank_St, Bank_PhoneNumber) Donor(Donor_Id, Donor_First, Donor_Last, Donor_BloodType, Donor_City, Donor_St, DOB, TotalNumberOfDonations) Donation_Record(Donor_Id, Donation_Date, Donation_Amount) Employee(MS_Id, Bank_Id) Storage(Donor_Id, Donation_Date, Bank_Id)   Write SQL queries to answer the following questions:   a.Find the average donation amount for Sue Thompson (Donor Id = 3329) for the year 2018.                   b.Sum all donations by Bank for each State (i.e. the State the blood bank is located in, not the Donor).                     c.Find the name of the youngest donor and all the donations made in by that donor in 2020.

All of the following are true about relational table except Each column has a distinct name Each table must have an identifier All the values in a column can be with different data types Oc. Each row represents one instance

Create the following tables in your database with the following schema: Table: Employee | Column Name | Type | empId I name | supervisor | salary | int | varchar | | int | int empId is the primary key column for this table. Each row of this table indicates the name and the ID of an employee in addition to their salary and the id of their manager. Table: Bonus | Column Name | Type | | empId | bonus | int | int empId is the primary key column for this table. empId is a foreign key to empId from the Employee table. Each row of this table contains the id of an employee and their respective bonus. Add the following data to your tables: Input: Employee table: | empId | name | supervisor | salary | | 3 | Brad | null | 4000 | 1000 | 2000 | 4000 | John | 3 | 2 | 4 | Dan | 3 | Thomas | 3

Given the following schema, answer the following questions    USERS Attribute Data Type USER_ID NUMBER(3) USER_NAME VARCHAR2(20) USER_TYPE VARCHAR2(10) USER_LIMIT NUMBER(1)                           BOOKS Attribute Data Type BOOK_ID NUMBER(5) BOOK_TITLE VARCHAR2(25) BOOK_YEAR VARCHAR2(4)       Write the SQL code that will create the tables structures for the tables named Books, and Users. Identify and include any PK and FK for both tables.

INFO 2103 Database Programming Assignment #3     For this assignment, please use the SUPPLIER and COMPUTER table. The script is available in Google Classroom. Script name: computer.sql. Note: Use Subqueries          1.    Display the supplier that supplied the most computers.           2.   Display the building location that has the most computers.

Based on the ERD below, write the SQL statement to change the job description of “Database Designer” to “Database Developer”. After completing this task examine the results with a select statement. (Hint: Use an Update Statement.)