3. Using queries, create a database named Gallery and the two (2) tables below. Set the appropriate data types. Table 1. Users UserID Username Date Created 001 sparsley0 2019-02-19 002 dsumshon1 2018-12-24 003 hpointing2 2018-12-11 004 smannagh3 2018-08-05 005 gstarsmore4 2018-07-09 006 dzuann5 2019-01-09 Table 2. Pictures PicturelD FileName UserID DateCreated 1001 laptop.jpeg 003 2019-02-07 1002 sti_orca.jpeg 007 2019-09-04 1003 home.jpeg 005 2019-02-16 1004 bsit.jpeg 001 2019-10-19

Q: Write a SQL query that displays the number of customers who born on the 16th day of a month .  Write…

A: 1. select count(customerID) from Customers where to_char(custDOB,'DD') = 16; 2. select customerID…

Q: Write 8 different SQL queries with their descriptions for the database you created. You must write…

A: The 8 different Queries with their description are given below: Join Nested Set Operations…

Q: create database CTU__YourICASNo GO USE CTU__YourICASNo; GO CREATE TABLE Course(     CourseID int…

A: Table Course: Table Students: Table Semester: Table Facilitator: Table Module:

Q: Display the highest, lowest, and average customer credit limits. Name these results high, low, and…

A: SOLUTION : ANSWER 1 This query will number of employees for each job title in ascending orderhere is…

Q: You are required to create the following tables in a database named STUDENT_REGISTRATIONS. Ensure…

A: create the following tables in a database named STUDENT_REGISTRATIONS.:-

Q: Create the following queries for the “books” database. For each query make sure to only include…

A: SELECT COUNT(TITLE_ID) AS "# of long books" FROM TITLES WHERE TITLES.PAGES>=450 GROUP BY TYPE;

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

Q: Given the following table, COURSES, with the following rows, what values are generated by the query…

A: SUBSTRING will return the substring from specified start and ending indices So now we find the…

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: The Driver Relationship team wants to have quick search options for the active drivers. The team…

A: Task 4: INDEX is used search/retrieve data more quickly. It is basically used to speed up query.…

Q: MS SQL Server  create a view that contains clients and their total balances in their accounts. The…

A: Here Client ,Account tables are given .From this we have to create view. view is a virtual table…

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: The screenshot of the Query and the results below is from the question of each number, and saved…

A: Answer:

Q: Add a CHECK constraint on the BEDROOOM column in the ROOMS table. It must accept a value from 1 to 5…

A: CHECK is the keyword used for CHECK constraint and after table has created, if you want to add this…

Q: You are required to create the following tables in a database named SICKLEAVE: EMPLOYEES EMPLOYEE_ID…

A: Kindly Note: As per our company guidelines we are supposed to answer only first 3 sub-parts. Kindly…

Q: create database CTU__YourICASNo GO USE CTU__YourICASNo; GO CREATE TABLE Course(     CourseID int…

A: Query to retrieve information from table facilitator and module using join w.r.t. facilitatorID is:…

Q: Create a View to show the city name of any location that has a department. Only show the city name…

A: Introduction: A SQL database, often known as a relational database, is made up of a number of highly…

Q: Normalise the data :

A: Q

Q: Using the schema below write the DDL code to create the customer and order table in the  new…

A: The SQL queries for the DDL and DML commands are provided below.DDL stands for Data Definition…

Q: . Using the Henry Books database, list the book code and title of every book that has the type SFI…

A: In this question we have to write a query for using a Henry book database for the given queries…

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: From the database scheme write the query(all tables are empty) 1) Insert your name and your phone…

A: The given diagram is a logical model for the rent of apartments where the apartment has a building…

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: create the following tables in a database named STUDENT_REGISTRATIONS. Ensure that you create the…

A: in the following section we will be writing the oracle SQL queries for the above mentioned table…

Q: Insert the following data into your database tables. STUDENTS STUDENT_ID STUDENT_NAME…

A: Solution:--   1)The given data in the question are all those things that must be included in     the…

Q: The screenshot of the Query and the results below is from the question of each number, and saved…

A: SQL (Structured Query Language) is a structured programming language for managing relational…

Q: L script which is the physical design for this database   ### Animals This table contains the…

A: Note: As per the Bartleby policy we can solve only one question at a time. Please repost the…

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: Create a table in SQL developer and name it as ‘MyCrush’. The table should consists of only three…

A: Please give positive ratings for my efforts. Thanks.   ANSWER   SQL Satements to create and insert…

Q: Open the AttendeeFirstName query in Design View and add criteria to select only those records where…

A: According to the question , we have to write a SQL Query according to given criteria. In step 2, we…

Q: The Student table contains marks of 10 students belong to different sections Create the following…

A: Dear Student, To create the table we will use the CREATE instruction of SQL. So, SQL query will be…

Q: Write Create Table SQL statements Work Session table  The table must have a primary key. The table…

A: While creating session table remember one thing that first you have to create TEXTBOOK and AUTHOR…

Q: create database CTU__YourICASNo GO USE CTU__YourICASNo; GO CREATE TABLE Course(     CourseID int…

A: Answer: Before updating table:   SQL Query( ALTER TABLE students ADD studentAge INT NOT NULL AFTER…

Q: create tables appointments having columns appointment id as primary key, appointment time,…

A: SOLUTION - create tables 1) appointments having columns appointment id as primary key, appointment…