Create the following tables and insert some values. STUDENT (STDNO, SNAME, DEPTNO#) DEP (DEPTNO, DNAME) COURSE (CORSNO, CNAME, DEPTNO#, CMAX) ENROLMENT (STDNO#, CORSNO#, GRADE, EDATE) Query a single table 1) Display the whole content of the DEP table 2) Display all columns of the 'CP' department 3) Display the whole content of the STUDENT table 4) Display STDNO and SNAME for students in department 'CP' 7) Display all columns for departments when the Dname starts with letter 'M' or 'C'. 8) Display all columns for courses sorting the result by the CMAX descending.

Q: (d) Descendants by gender: For all persons who have a descendant, compute the number of descendants…

A: COUNT The number of rows that match a certain criterion are returned by the COUNT() function. AVG…

Q: Statement: The columns listed in a GROUP BY command must come from the columns listed in the SELECT…

A: Statement: The column listed in the GROUP BY command must come from the columns listed in the SELECT…

Q: (1) Create a table LOAN with the Attributes as: Loan_ID(Primary Key) Amount C_id BNAME 801 9000 1601…

A: Note: There are multiple questions are given in one question. According to the rule, you will get…

Q: 1. ID Last Name First Name Create the My Employee table with the following fields: Number(4)…

A: The solution is given in the next step

Q: Switch to the Melbourne Swim Teams In cell B14, use the INDEX function to display the value in the…

A:

Q: Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with…

A: A relational database contains tables. Tables are also called relations and they contain rows and…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Click the small + sign beside the employee with ID 149. What do you see? Why do you see it?

A: Datasheet view: Datasheet view provides the visual way to create a table. It is used to arrange the…

Q: Q1) List the products that are supplied by a vendor

A: SQL command is used to create and manipulate data with the help of DDL (data definition language)…

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table:   INSERT INTO OWNER…

Q: 7) Write an SQL query to count how many account holders belong to each recurrent_acno

A: NOTE Below is the answer for the given question. Hope you understand it well. If you have any…

Q: Given following two tables (EMPLOYEE, DEPARTMENT). Note, Dno in table EMPLOYEE and Dnumber in table…

A: Dear Student, The required query with explanation is given below -

Q: Alter the structure of the table Activities by adding a new column called 'ActivityDescription' of…

A: alter table add is used to add columns in existing table. This helps in adding columns which comes…

Q: Using the Winners table from Figure 12-2, write a SELECT statement that selects onlythe Animated…

A: The SELECT statement that selects only the Animated field for records whose Animated field begins…

Q: Q1) Please write. a query statement from emp table to display deptno 10’s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: write a mysql statement for following i) to show the structure of the table bike ii) to change the…

A: The language that is used to perform queries on a database is ‘structure query language’. It has…

Q: creat the following tables and insert your own values: emp(eno, ename, bdate, title, salary, dno)…

A: The SQL INSERT INTO Statement is used to add new rows of data to a table in the database

Q: Which of the following is NOT TRUE about the TEACHERS table structure? Field/Column Name Data Type…

A: option (C) is the CORRECT option.

Q: Create the Branch_Reps table and define the constraints at the table level. Note that Not Null can…

A: Creating a simple table entails naming it, creating its columns, and specifying the data type for…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: What will be the result after executing this statement: SELECT SUBSTR('International', 6, 6) FROM…

A: SUBSTR(string, start, length) this is the syntax .

Q: 1. ID Last Name First Name Userid Salary Create the My Employee table with the following fields:…

A: Here is the complete solution of the above problem. See below steps.

Q: 1. ID Last Name First Name Userid Salary Create the My Employee table with the following fields: Not…

A: We need to write query about the above problem. See below steps.

Q: Column Name Sie Constraints Data Type DepelD Varchar 4 Primary key DepeName 40 Not mull Varchar…

A: I have created the query below for the table:

Q: Insert two records in each table or use if you have already created this schema. Q#2 Display…

A: For this question we have to write the queries for required 10 question. All these queries include…

Q: Refer to the CREATE TABLE statement: CREATE TABLE Country ( ); Name VARCHAR (50), Population INT,…

A: The question is asking to complete an SQL INSERT INTO statement to add a new row into the 'Country'…

Q: 11. Which of the following statements is true with regard to BCNF tables, i.e. Boyce-Codd Normal…

A: The given question are multiple choice selected question.So can I explained in detail.

Q: 1. Create the My Employee table with the following fields: Number(4) Varchar(25) Varchar(25)…

A: Here is the complete solution of the above problem. See below steps.

Q: Activity 7: Sorting Data Using ORDER BY In this activity you will sort rows by using the ORDER BY…

A: The ORDER BY clause in MySQL is used to sort the results of a query in ascending or descending…

Q: 10-Create a products table that has product id, product name, and price fields. Write a query to…

A: Algorithm :  1) Create the table products. 2) Insert some values in the table. (I have added 4…

Q: Create the CUSTOMER table structure illustrated in Figure P8.16. The customer number should store…

A: GIVEN Create the CUSTOMER table structure illustrated in Figure P8.16. The customer number should…

Q: a column is acting as a unique reference key for a table which kind of key is this? a) compound b)…

A: A column is acting as a unique reference key for a table which kind of key is this ? a) compound b)…

Q: find uniq data

A: logic:-  use distinct keyword to filter distinct rows from a table.  Syntax:-  select distinct…

Q: 3) Write an SQL query to display the accountno, name, Recurrent_acno, transaction_date whose Eixed…

A: NOTE Below is the answer for the given question. Hope you understand it well. If you have any…

Q: rite the syntax to insert into a relational table called students the address column references an…

A: Lets see the solution.

Q: a)Create 3 tables(product_categories,products,product_sale) with primary key,foreign key in each…

A: Initially 3 tables are created product, product_category, product_sale. Each table is related to…

Q: Create a table named "LIBRARY" with the specifications mentioned below. Display the details of the…

A: The CREATE TABLE statement is used to create a new table in a database. Syntax: CREATE TABLE…

Q: The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City,…

A: Information provided: MemberLastName, MemberFirstName, Street, City, State, ZipCode, and…

Q: d) Find how many reservations have been made for each taxi. Sort the output from the highest to the…

A: Answer:- Atrributes: It is a column in a table Table CUSTOMER: Atrributes : 1.custID( Type),…