DOBLNameClayJohnsonClayIDFNameRickMikeRhoda20/04/199605/05/200511/08/19991. Use the table above to answer the following questions;a) Write a SQL statement to create a database called "My friends" and a table called "friends"(make ID, your primary key) and populate it with the above records.b) Write a query statement to add 'residence', 'p one_number', and 'address' to the friends'table.c) After adding the fields, the fields will be set to null by default, write a query statement to setthose null entries to actual data using any data of your choice.dy Write a SQL statement to insert three additionl records into your friends table.e) Write a query to display a categorized version bf your friends table using LName as yourcategorical dataset.D Write a query statement to display records with "n" in their LName.23 a. Using the chen notation approach, sketch and show the type of relationship between theCistomers and their purchase, products and their prices, Vendors and the products they havesold. You also came across a tabular that have tecords of daily sales and monthly sales made.entities for the database design. Note cach entity should have at least 3 attributes.Read carefully the case study below and answer the question that follows.KECH Is a new business in town that deals in sales of computers and their accessories.Upn your interaction with them, you noticel them to having a file that keep records ofSold. Youlso came across a tabular that have tecords of daily sales and monthly sales made,a. Using the chen notation approach, sketch and show the type of relationship between theetiies for the datboce desion. Note cach entity should have at least3 attributes.

Answered: 1. Use the table above to answer the…

Engineering

Computer Science

1. Use the table above to answer the following questions;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 3MC

See similar textbooks

Similar questions

Write the two SQL command sequences required to: a.Create a temporary table named TEMP_1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT. b.Copy the matching EMP_2 values into the TEMP_1 table.
The following tables provide a very small portion of the data that will be kept in the database. These data need to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in Problem 65. RENTAL RENT_NUM RENT_DATE MEM_NUM 1001 01-MAR-13 103 1002 01-MAR-13 105 1003 02-MAR-13 102 1004 02-MAR-13 110 1005 02-MAR-13 111 1006 02-MAR-13 107 1007 02-MAR-13 104 1008 03-MAR-13 105 1009 03-MAR-13 111 VIDEO VID_NUM VID_INDATE MOVIE_NUM 54321 18-JUN-12 1234 54324 18-JUN-12 1234 54325 18-JUN-12 1234 34341 22-JAN-11 1235 34342 22-JAN-11 1235 34366 02-MAR-13 1236 34367 02-MAR-13 1236 34368 02-MAR-13 1236 34369 02-MAR-13 1236 44392 21-OCT-12 1237 44397 21-OCT-12 1237 59237 14-FEB-13 1237 61388 25-JAN-11 1239 61353 28-JAN-10 1245 61354 28-JAN-10 1245 61367 30-JUL-12 1246 61369 30-JUL-12 1246
Is this statement true or false? The term "null" refers to a column in a database table that does not contain any data and is thus empty.
ASSUME 6.2 IS DONE Write a SQL statement to get the list of all the tasks that started after2022-05-10. Include all the columns from the task table. Write a SQL statement that returns a list of the team members with alltheir tasks. Include the team member’s name and the description ofthe task in the results. Write a SQL statement to get a list of the tasks in the database,arranged by duration from largest to smallest. Include all the columnsfrom the Task table.
2.1 In the table above, Vanesa’s last name was omitted. Write an SQL query to add the lastname. Assume the last name is ‘Johnson’ 2.2 John Silas is an employee in a Logistics company with ID = 02361. He was newly promotedwith an increase of R2000 on his salary. Write an SQL query to update his record in thestafflist table 2.3 An alias provides a mechanism to rename a column or an expression. Under whatconditions should you enclose an alias in double quotes?
This is my attempt at DBDL statements trying to plan a database in MySQL. Employers: CREATE TABLE Employers ( EmployerID INT PRIMARY KEY, CompanyName VARCHAR(255), Location VARCHAR(255), ContactInfo VARCHAR(255), ); Customers: CREATE TABLE Customers ( CustomerID INT PRIMARY KEY, Name VARCHAR(255), ContactInfo VARCHAR(255), Education VARCHAR(255), Experience INT ); Reference: CREATE TABLE References ( ReferenceID INT PRIMARY KEY, Name VARCHAR(255), ContactInfo VARCHAR(255), RelationshipToCustomer VARCHAR(255) ); Skills: CREATE TABLE Skills ( SkillID INT PRIMARY KEY, SkillName VARCHAR(255), ProficiencyLevel VARCHAR(255) ); EmploymentPositions: CREATE TABLE EmploymentPositions ( PositionID INT PRIMARY KEY, PostionTitle VARCHAR(255), EmployerID INT, Duration VARCHAR(255), FOREIGN KEY (EmployerID) REFERENCES Employers(EmployerID) ); Interviews: CREATE TABLE Interviews ( InterviewID INT PRIMARY KEY, InterviewDate DATE, Interviewer VARCHAR(255), Feedback VARCHAR(255) ); HiringStatus:…
Database course: a. Write in SQL a command that creates the table Customers according to the above description. b. Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account. c. Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990. d. Write a SQL query that displays the number of customers who born on the 16th day of a month. e. Write in SQL a query that displays the ids of the customers who have the highest income. f. Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials. (I need the codes to copy them please) Photo is there.
Below is a schema for an HR database:employee(empid, fname, lname, managerid, departmentid, employee_rank)It's an employee table, which has employee id, first name, last name, manager id (which is an employee id), department id, and employee_rank, such as VP, CEO, SVP, etc.Using SQL, answer this question (write a SQL query that answers this question) [tip: use a recursive query]. 11. For employee 42, find the path-of-managers directly to the CEO?
A select operation in a relational database decreases the size of a table by removing columns that fulfill certain criteria.Is this statement truthful or false?
A select operation in a relational database decreases the size of a table by removing columns that fulfill given criteria.Is this statement truthful or false?
Assistance with SQL statements Previous code; CREATE TABLE Lab4program_piershed ( code VARCHAR(5) PRIMARY KEY, name VARCHAR(20), tel VARCHAR(20));CREATE TABLE Lab4course_xxxx ( cid INT PRIMARY KEY, name VARCHAR(20), credits INT, mycode VARCHAR(5), FOREIGN KEY (mycode) REFERENCES Lab4program_xxxx(code)); 1. Insert 3 records into your Lab4program_xxxx table. The code should be "CPS", "TECH", "MATH", or "BIO". Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 3 records to your table. 2. Insert 4 records into your Lab4course_xxxx table with at least 2 different mycode. Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 4 records to your table.
In Sql These are some database from a set of tables insert into AccountHolder(AccountID, CustomerID, AccountType)values (55003, 115, 'Savings'),(44001, 101, 'Chequing'),(55006, 109, 'Savings'),(44002, 102, 'Chequing'),(44003, 113, 'Chequing'),(55007, 108, 'Savings'),(44004, 103, 'Chequing'),(44005, 110, 'Chequing'),(55005, 112, 'Savings'),(44006, 114, 'Chequing'),(55001, 111, 'Savings'),(44007, 107, 'Chequing'),(44008, 104, 'Chequing'),(55004, 106, 'Savings'),(44009, 105, 'Chequing'),(44010, 113, 'Chequing'),(55002, 107, 'Savings'),(44011, 110, 'Chequing'),(44012, 104, 'Chequing') select * from AccountHolder insert into Branch(LocationID, BranchName, Address, Type, DepositSum, LoanSum)values (1, 'Boulevard Branch', '3268 Wade Boulevard', 'Rural', 171848.88, 37681.72),(2, 'Avenue Branch', '4814 Dare Avenue', 'Rural', 232707.42, 68324.56),(3, 'Street Branch', '208 Ferry Street', 'Commercial', 375010.75, 44665.08),(4, 'Road Branch', '468 Zulauf Road', 'Commercial', 496001.41,…

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS