Question: 1. Use computers.txt a. Find all entries of faculty whose name starts with the letter F, G, H, I, J or K. b. Find all

1. Use computers.txt a. Find all entries of faculty whose name starts with the letter F, G, H, I, J or K. b. Find all entries of faculty whose name ends with an n. c. Find all entries that are on the 4th floor of their building. This means that the room number is 4xx (so for instance, it should not include 314 just because there is a 4). d. Find anyone whose office is only 2 digits. This one is tricky in that you have to figure out how to specify that it should not include 3-digit numbers. e. Find all entries that include either a Unix or Linux platform computer. f. Assume that you want to find all faculty who have a PC in their office. While the command egrep PC computers.txt will work in this case, explain why it may not work in general. That is, can you figure out why egrep PC computers.txt may give you wrong answers if we had other entries in the computers.txt file?

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!

3. BMT has developed a new product. It can go into production for an initial investment of $3,000,000. The equipment will be depreciated using straight-line depreciation over 5 years to a value of...

CIT 371 Lab 9: Regular expressions and grep (egrep) Start VMware and your VM, log in as Student (password:LinuxIsCool!). cd to ~/FILES. You will use the files computers.txt (step 1) and addresses.txt...

Please I need help with this assignment Log into Coivcenter and start your VM, log in as Student, cd to ~/FILES. You will use the files computers.txt (step 1) and addresses.txt (step 2). Your answers...

Please if we have a text file that we can call computers. Txt or addresses. Txt. I want to know egrep command (Linux regular expression) to solve these questions. Thank you You can use theses as a...

2-Use subquery to find the students IDs who scored more than the average mark. [use Grades Table] 3-Write a SQL query to find a list of the student ID and who have failed the course (scores 39 or...

* * A SQL TABLE IS PROVIDED. PLEASE ANSWER THE FOLLOWING QUESTIONS USING THE SQL TABLE. * * - List all students with a major in "Computer Science". - Show the name and department of each course. -...

I need perfect answers to questions 1 to 20. Using the university database, give the following queries in SQL (SQL Server 2019). 1. Find the name of each instructor who has taught at least one course...

HELLO PLEASE SOLVE AND HELP ME WITH THIS DATA BASE ASSIGNMENT Instruction: Save this file as Lab 4 _ YOURID _ SectionID and for each query below, express the query in SQL , run it , and include the...

Bernard Flinn operated a business known as Harvey Investment Co., Inc./High Risk Loans. Flinn worked as a loan broker, matching those who came to him with lenders willing to loan them money given...

1. From what you remember of electronegativities, show the direction of the dipole moments of the following bonds. 2. In each case, predict whether the dipole moment is relatively large...

1. Name the three substances loaded into the top of the blast furnace.

Selected transactions for Clark Decor, an interior design company, in its first month of business are as follows. Jan. 2 Marie Clark invested cash in the business in exchange for ordinary shares. 3...

An apple growers orchard provides nectar to a neighbors bees, while the beekeepers bees help the apple grower by pollinating the apple blossoms. Use Figure 28.2b to explain why this situation might...

ADVANCED ANALYSIS User cost is equal to the present value of future profits in the model presented in Figure 27W.7 . Will the optimal quantity to mine in the present year increase or decrease if the...

LAST WORD The figure in the Last Word section shows that a 10-fold increase in a countrys GDP per person is associated with about a 20-point increase in EPI. Do you think that this pattern can be...