Create a script, save & submit as as Project7.sql, that will perform the following. Issues a "DROP TABLE" command for the external table that will be created in the following step Creates an external table based on the data stored in the "ResearchData.csv" file. This file contains data related to my Ph.D. Computer Science research related to Protein Structure Alignment. The Data contains multiple fields separated by commas. The first field represents the name identifier for a protein (i.e. Protein ID and Chain ID, e.g. 1ADF_A implies Protein ID:1ADF and Chain ID:A). The table field names are "Protein ID", "RMSD_1" ...... "RMSD_32". Creates a query (using a substitution variable to represent the Protein Identifier) that retrieves all of the RMSD values associated with that protein.

Create a script, save & submit as as Project7.sql, that will perform the following. Issues a "DROP TABLE" command for the external table that will be created in the following step Creates an external table based on the data stored in the "ResearchData.csv" file. This file contains data related to my Ph.D. Computer Science research related to Protein Structure Alignment. The Data contains multiple fields separated by commas. The first field represents the name identifier for a protein (i.e. Protein ID and Chain ID, e.g. 1ADF_A implies Protein ID:1ADF and Chain ID:A). The table field names are "Protein ID", "RMSD_1" ...... "RMSD_32". Creates a query (using a substitution variable to represent the Protein Identifier) that retrieves all of the RMSD values associated with that protein.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 2.7CP

See similar textbooks

Similar questions

Create a table in your own database using the following statement. CREATE TABLE DateRange (DateID INT IDENTITY, DateValue DATE, DayOfWeek SMALLINT, Week SMALLINT, Month SMALLINT, Quarter SMALLINT, Year SMALLINT ); Write a stored procedure that accepts two parameters: A starting date The number of the consecutive dates beginning with the starting date The stored procedure then inserts data into all columns of the DateRange table according to the two provided parameters.
Sales Database: Customers(custId, lastName, firstName, address, phone, creditLimit) Orders(ordNumber, itemNumber, qtyOrdered.) Items(itemNumber, itemName, price) For the Sales Database referenced above, write the SQL command to create the LineItem table, assuming the Orders table and items table already exist.
Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL please
Create a new table named BOOK_TYPE in the finalexam database. The BOOK_TYPE table has two character columns: TYPE has a length of 3 characters and is the table’s primary key, and DESCRIPTION has a length of 20 characters.
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain conditions. Under what circumstances would you create a View?
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. SQL DataBase Test: Create a new table to store maintenance operations Test Query: DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
with it, paste your code in a text file named Student.txt and save it in your task folder. Write the SQL code to create a table called Student. The table structure is summarised in the table below (Note that STU_NUM is the primary key): STU_NUM Attribute Name STU_SNAME STU_FNAME STU_INITIAL STU_STARTDATE COURSE_CODE PROJ_NUM STU STU_S STU_F STU_INITIAL NUM NAME NAME 01 02 Snow John E CHAR(6) After you have created the table in question 1, write the SQL code to enter the first two rows of the table as below: Stark Arya с VARCHAR(15) VARCHAR(15) CHAR(1) DATE CHAR(3) INT(2) Data Type STU_STARTDATE COURSE_ PROJ_ CODE NUM 05-Apr-14 12-Jul-17 201 305 6 11 Assuming all the data in the Student table has been entered as shown below, write the SQL code that will list all attributes for a COURSE_CODE of 305.
Create table statements (file name must be: 1_create_table.txt). Make sure you specify primary keys and foreign keys. Specifying “not null” constraint is optional. Specifying “on delete action” and “on update action” are optional.
Task 3: Create(Enter) new product by using a Procedure with IN Parameters Follow these steps to create a procedure that allows a company employee to add a new product to the database. This procedure needs only IN parameters. In SQL Developer, create a procedure named PROD_ADD_SP that adds a row for a new product in the BB_PRODUCT table. Keep in mind that the user provides values for the product name, description, image filename (use same template for file name as ‘roasted.jpg’ or ‘double-roasted.jpg’ ) , price, and active status. Address the input values or parameters in the same order as in the preceding sentence. Call the procedure with these parameter values: ('Roasted Blend', 'Well-balanced mix of roasted beans, a medium body', 'roasted.jpg',9.50,1). Check whether the update was successful by querying the BB_PRODUCT table. -This will be a page where you allow new product information to be entered into Edit box by end user and then there will be INSERT or ADD Product…
Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create and use a sequence to handle generating and populating the project ID. The first number issue by the sequence should be 600, and no caching should be used. Use a record variable to handle the data to be added. Data for the new row should be the following: project name is “Covid-19 relief fund”, start date: Feb 1, 2022, end date: Jun 30, 2022, and fundraising goal is half million. Any columns not addressed in the data list are currently unknown. 2.Create anonymous block to retrieve and display data for all pledges made in a specified month. One row of output should be displayed for each pledge. More specifically, each row include: Pledge ID, donor ID, and pledge amount If the pledge is being paid in a lump sum, display “Lump Sum” If the pledge is being paid in monthly, display “Monthly ** ” followed by number of months for payment The list should be sorted to display all lump sum pledges first