Q2: Create the database its name ( your name ) and Create below the table if you know : Id Name Average Date of exam 1 Ali 70.5 28/2/2021 2 Sara 90.2 28/2/2021 3 Ahmed 40.5 28/2/2021 4 Noor 45.9 28/2/2021 5 Mohammed 55.2 28/2/2021 Id must be not null and without repetition • The name must have the default value • Show the successful students only

Q: select * from cast where cast_id=162652763; Use explain to display the query plan without creating…

A: the answer is given below

Q: The university would like to set up a relational database corresponding to this form. a. Normalize…

A: The given data appears to be a list of student records, with each record indicating a student's roll…

Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key,  name…

A: In the given Customer table creation query, salesman_id is a foreign key. But the given syntax of…

Q: SQL Querry Find the list of courses who haven’t got any section opened in Spring 2019. (Use outer…

A: It is simple SQL query to fetch the list of courses who haven't got any section opened in Spring…

Q: Database course:  Write SQL queries to do the following    A. List names of IT students.…

A: The SQL queries are given in step 2.

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: Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT.

A: ALTER TABLE MAINTENANCE_TYPES ADD MAINTENANCE_PRICE float;   Alter Query is used to change the DDL…

Q: Using the Henry Books database,update the paperback field for the book titled Black Houseto Y. You…

A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Q: SOQL Query to find out the All the contact that are associated with the Particular account id.

A: SOQL stands for Salesforce Object Query Language. we can use SOQL to read information stored in…

Q: RESTAURANT_ID | RESTAURANT OWNER1_NAME | RESTAURANT OWNER2_NAME | RESTAURANT_OWNER3_NAME | Paul…

A: Database normalization is the process of restructuring a relational database in accordance with a…

Q: The Car Maintenance team wants to update the price of Oil Change to 75. In addition, they will no…

A: We need to write the MYSQL query to update the price of Oil Change to 75 and remove the maintenance…

Q: i keep getting this message Msg 1778, Level 16, State 0, Line 23 Column 'salesman.salesman_id' is…

A: Given error is Column 'salesman.salesman_id' is not the same data type as referencing column…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: DELETE CASCADE: - When we constitute a foreign key using this option, it deletes the referencing…

Q: Complete the following exercise: Alter your student table adding a new column called enroll_date…

A: Alter your student table adding a new column called enroll_date using the datetime data type.…

Q: Question 8. All rows correspond to students whose rollnum's are between 20 and 30. (i) SELECT * FROM…

A: Given sentence in SQL database

Q: Write in SQL a command that creates the table Customers according to the above description (2…

A: SQL answers to the above first 3 questions are in step2 as per our guidelines we are supposed to…

Q: display the doctor has referred any patients to have a blood sugar test performed or not. If the…

A: Question: Create a query that displays the Doctor_ID, Doctor_Surname, and whether or not the doctor…

Q: DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY…

A: Answer in step 2

Q: A simple database composed Tollowing tables: PATIENT, TOR, DRUG, PRESCRIPTION, is now loaded with…

A: As per the guidelines we have given answer for the first three queries. You can find the solution in…

Q: 1. Prepare a list of orders by Shipper showing the Shipper ID, Order ID, Product ID and Quantity.…

A: In this question we have to understand about given SQL database and prepare the list of queries…

Q: The BOOK_PRICING database has to be updated by removing the Category column. Do you know for sure…

A: To determine if the "Category" column in the BOOK_PRICING database has been disabled, we need to…

Q: Create a database named book-collection-db and table named: bookcollect. Your table should contain…

A: To create a new database in MySQL, you use the CREATE DATABASE statement  Use a CREATE TABLE…

Q: In SQL  This sample database consists of the following tables(see image for tables and there is one…

A: 1. orderNumber is the primary key in the orders table, so it is always unique.This query selects…

Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key,  name…

A: As per the given data, while creating salesman table, you have declared commission with datatype…

Q: Using the Winners table from Figure 12-2, write a parameter query that selects theActor and Actress…

A: A query that has a parameter marker instead of a value of criteria is called as parameter query. The…

Q: Oracle supports creating objects and collections using type. Write SQL code for the following…

A: Answer :

Q: Write a trigger to put the total sale order amount before tax (unit price * quantity for all items…

A: The TRIGGER statement can be used to create triggers so that values are populated automatically when…

Q: CREATE TABLE Fielding( Player CHAR(25), CareerSpan VARCHAR(20), Matches INT, Innings INT, Catches…

A: SQL Query Use inner join to join the 3 tables and get the required result from query

Q: assume that a database has a table named Stock, with thefollowing columns:Column Name…

A: Create a table named Stock.   Table Stock has the following columns: Trading_Symbol of type nchar…

Q: Using the Henry Books database, add the new title from Stephen King to the wrote table: Book code =…

A: The question is asking to add a new book title by Stephen King to the "wrote" table in the Henry…

Q: In the BOOK_PRICING database, the Category field should be marked as obsolete. Make sure the column…

A: An obsolete playing field in a database is no longer in use or needed. These are often fields that…

Q: SQL A table Products have: a name (TEXT) a description (TEXT) a unit cost stored in cents…

A: HI THERE,I AM ADDING SCHEMA AND QUERIES BELOWPLEASE GO THROUGH IT THANK YOU

Q: a query generate a report indicating average patient. The report should display the Patient_Name,…

A: Question: Write a query to generate a report indicating the average overall test result for each…

Q: 15:41 Done STUDENTS STUDENT_ID STUDENT_NAME S123456 S246810 S369121 S654321 S987654 MODULES…

A: CREATE TABLE STUDENTS(STUDENT_ID VARCHAR(20) PRIMARY KEY, STUDENT_NAME CHAR,STUDENT_SURNAME CHAR);…

Q: The Car Maintenance team considered that the available maintenance tasks should also have the price…

A: TASK 1: -- Creating a new table MAINTENANCE_TYPES with following fields create table…

Q: List all products with their highest unit price, i.e. not discounted. the database is

A: Given: List all products with their highest unit price, i.e. not discounted.the database is

Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key,  name…

A: In SQL table is created by creating command and values are inserted by insert command. Syntax for…

Q: Q1: Identify one PK from each table and add the constraints using alter.

A: PK or Primary Key constraint represents unique values in a column or set of columns. PK column…