róčédure: 1. Create a table named StudentGrade with the following columns and values. Set the appropriate da type for each column. Course Title Data Structures and Algorithms Readings in Philippine History Physical Education 3 Rizal's Life and Works Human-Computer Interaction Object-Oriented Programming Principles of Communication Platform Technology CourseCode Units Grade COSC1003 1.50 3 2.25 GEDC1006 PHED1003 GEDC1014 COSC1007 1.25 3 1.50 3 1.25 INTE1044 3 1.75 COSC1001 3 2.25 COSC1008 3 1.50 2. Using queries, display the following: a. The number of courses/subjects b. The total units c. The number of courses with grades higher than 2.00 (lower than 2.00 in the column) d. The number of courses with grades lower than 2.00 (higher than 2.00 in the column) e. The general weighted average (Get the sum of all the products of units and grades, then divie by the total units.) Expected output: a. 8 b. 23 c. 6 d. 2 e. 1.67

Q: For the 4 following questions, your submission will be the query that shows you’ve created the table…

A: According to the information given:- We have to write a query that shows you’ve created the table…

Q: CREATE TABLE PRODUCT (PRODUCT_ID INTEGER PRIMARY KEY, "NAME" TEXT NOT NULL, PRICE REAL NOT NULL);…

A: As per the given information, we need to write a SQL query that can be used to return the second…

Q: Q. List all the attributes of movie in the given Model.

A: Q. List all the attributes of movie in the given Model.  Answer. All the attributes of movie in the…

Q: Refer the below schema and create the table USERS. Column Name Datatype | Size Number Varchar2 20…

A: We have to create the table USERS from the given schema

Q: Create the following table: Table Name: SUPPLIERS…

A: Given: Create the following table: Table Name: SUPPLIERS           FIELD NAME     DATA TYPE…

Q: Create a table named REP_CONTRACTS containing the columns listed in the following chart. A composite…

A: First we have to create a table say STORE_REPS which should contain Rep_ID and Store_ID columns and…

Q: 3,#4,#5 Will provide my re

A:

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

A:

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: Given that information ERD and EERD. draw the dependency diagram 1NF,2NF and 3NF. Make sure that you…

A: ER diagram

Q: Question 1: Modify the select statement in this section to display the hire_date column in the…

A: SQL which refers to the  domain specific that are used for the language and  in the programming and…

Q: 1. Create/ a sequence, GOV_SEQUENCE_xx, that begins with 100 and increments by 100 and uses all…

A: The following question deals with the creation and usage of sequences in a database management…

Q: Normalize the following form into UNF 1NF, 2NF and 3NF. Show primary keys and foreign keys for all…

A: We have given a table and we need to normalize the given table into 1NF, 2NF, and 3NF. Then we need…

Q: a6 Create a table Promotion_list (EMPID, Name, Salary, DivisionName). a7 Load Promotion_list with…

A: The question is to write the query for the given problem. Here MYSQL has been used to design the…

Q: Refer the below schema and create the SCHEDULE. Column Constraint Datatype Size Reference table…

A: According to the given question we are required to create the Schedule table having the given table…

Q: 1. a) Create a table Staff Column Name Datatype Constraint Sid Number(3) Primary Key Varchar2(30)…

A: To write query statement to create a table for staff details.

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: Map the ER into relational schema

A: The relation schema for the given ER Diagram is: The entity tables and the relation are mapped .…

Q: Refer the below schema and create the SCHEDULE. Column Datatype Size Constraint Constraint name…

A: Brief Introduction:We are provided with the whole schema of the Bus Booking System in which we are…

Q: Show using pseudocode how you would break on the category field to produce a report like the…

A: Given :

Q: columns in the Athletics table are named AthleteID, First_name, Last_name, DOB, SportsCode, and…

A: Here have to determine about sql query for create table using SQL.

Q: What does a Details view entail?

A: Details view shows the clear view of the particular area with having greater clarity. Lets…

Q: P VRENTAL_ID DESCRIPTION COMPLETE_ADDRESS *OWNER_NAME OWNER_EMAIL OWNER PHONE OTHER DETAILS VACATION…

A: Answer :- 1. DROP PROCEDURE IF EXISTS p_property;GOCREATE PROCEDURE p_property_allAS BEGIN  SELECT *…

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: Which type of column can be simple or composite while also being correctly defined as both unique…

A: The question is asking about a type of column in a database table that can be simple or composite,…

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: Question 5 To make adjustments to your reference markers, you would navigate to the References tab…

A: The reference mark is the symbol that calls attention to an important sentence or idea. The endnote…