Question: 6. Regular Expressions/SQL. Write SQL for the following problems on the university database. A. Find students whose name is properly capitalized (both first and last

6. Regular Expressions/SQL.

Write SQL for the following problems on the university database.

A. Find students whose name is properly capitalized (both first and last name start from an upper-case letter, rest of the name is lower-case). Hint: you can use [A-Z] to represent any upper case letter in regular expressions.

B. Find course titles that consist of exactly 3 words (e.g., Theory of Computation).

C. Find students whose SSN numbers has a pattern of 321 repeated twice (sequentially).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please solve this accordingly for "Database Management System" Request: Please write the answers in a notebook (White Paper), scan the image of your notebook and upload it. Make sure your handwriting...

USING SQL ACCOMPLISH THE TASKS: Task 1: Write a create script: 1. Using the ERD pictured below, write all the table and constraint creation statements you would need to create the database in a...

Please provide me complete answer for this with explanation. Show all necessary work. Write SQL queries for the following scenario: A library database stores information about books, authors, and...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

Fixing the payment system at Alvalade XXI: a case on IT project risk management Ramon O'Callaghan Tilburg University, The Netherlands Correspondence: AO'Callaghan, School of Economics and Business...

Journal of Case Studies in Education Elementary teachers' experiences and perceptions of departmentalized instruction: A case study Alecia Strohl Valdosta State University Lorraine Schmertzing...

CSIS 325 Lab 4 (SQL CREATE TABLE) Before beginning this lab, be sure you have successfully downloaded and installed SQL Server Express 2014: (You should have already done this in your first lab, but...

Before getting an oil change, it is a good idea to drive a few miles to warm up the engine Why?

7. Find all Pythagorean triples in which one of the three numbers is 7. Explain your answer.

Maximization of shareholder wealth as a goal is superior to accounting profit maximization because (@) A. it considers the time value of the money. (.) B. following the shareholder wealth...

There are only 3 general journal entries! Question 1: (20 points) Twitter leased high-tech electronic equipment from Tesla Leasing on January 1, 2021 Tesla purchased the equipment from IBM at a cost...

Question If I decide to convert my traditional IRA to a Roth IRA, can I move the money back to a traditional IRA within the same year (or before the tax return due date) if that is advantageous (for...

Question Can life insurance be used in a Keogh (HR 10) plan?

Question At what age is a defined benefit plan more advantageous than a defined contribution plan for taxdeferring the maximum amount of retirement savings?