Using the World database,two updates are needed for one row in the Cities table. The city of Giumri in Armenia (country code ‘ARM’) is spelled incorrectly in the table.  It should be spelled ‘Gyumri’.  Also, the district is currently ‘irak’ in the table and should be ‘Irak’.  Make these changes in one construct.  You will insert 2 snips for this question: Insert your snip of the construct here:   Run a query to display ID 127 in the City table.  Insert your snip here:

Hi, the data that is populating the Supplier Field is from this string object in bold that is one of this variable parameters:  var supplierField = form.addField('custpage_supplier', 'select', 'Supplier', 'customrecord_reorder_suppliers').setLayoutType('startrow');   How do I go about retrieving the suppliers name and reordering the name view from this internal ID 'customrecord_reorder_suppliers'. This ID/string object is to a custom table in NetSuite that houses the supplier information. *Please see screenshot of suppliers table*   I have tried: var supplierName = 'customrecord_reorder_suppliers'.toString().split(' ').reverse().join(' ');. To reassign that string object so I could call it in a function but it still did not work.    If needed we can get on a chat to discuss this in more detail. Please let me know.

Task 2: ' The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.

Read the data into a DataFrame with ID as the index. Convert the “Hired” column into Date/Time data type Create a new column with years of experience with the company at present without rounding. Create a new Boolean column for senior status with employees with at least 10 years of experience as senior and others are not. Create a new column for longevity pay equal to $150 per whole year of experience in the company. Create a list of column names for each data type in the DataFrtame.

The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.

Write a script that attempts to insert a new category named “Guitars” into the Categories table. If the insert is successful, the script should display this message: SUCCESS: Record was inserted. If the update is unsuccessful, the script should display a message something like this: FAILURE: Record was not inserted. Error 2627: Violation of UNIQUE KEY constraint 'UQ__Categori__8517B2E0A87CE853'. Cannot insert duplicate key in object 'dbo.Categories'. The duplicate key value is (Guitars).

Create a view vLab3_xxx in the  class database list the staff who have the highest salary in each of the branch city. You will need both Staff and Branch table. The output header should be (city, name, salary) where the name is "fname lname".

Suppose you want to list information on all the classes that Pitt Fitness offers, including the day of the week, time, location, and length of class. To do this, you could create a query. What table(s) should you add to the query? If you use only the Classes table instead of all the tables together, does it make a difference to the output? What if someone had never reserved a specific class?

You have a table that contains the following fields: Last Name, First Name, Street, City, State, and Postal Code. There are 50,000 records in the table. What indexes would you create for the table?   You have a table that contains the following fields: Book ISBN Number, Book Title, Author Last Name, Author First Name, Publication Year, and Publisher Name. There are 75,000 records in the table. What indexes would you create for the table?

I NEED HELP WITH THIS QUESTION FOR MY DATABASE MANAGEMENT CLASS FOR SQL DEVELOPER 5. Now compute Average GPA in each class. Display class_code, Class_GPA. Assume all courses are 3 credit courses. A general formula for GPA would be sum(gradepoints x Hrs)/sum(Hrs). Here you can just take an average of gradepoints as the credit hours are same for all courses.