Below is a data file named as "mydata.txt":northwest NW Charles MainwesternWE Sharon Graysouthwest SWLewis Dalsasssouthernsoutheast SEeasternnortheastSO Suan ChinPatricia HemenwayEA TB SavageNEAM Main Jr.NO Ann StephensnorthAB, ABB, ABBB, ABBBB,ABC,ABCABC, ABCABCABC,AAA,AAAA, AAAAA300000.0053000.89290000.7354500.10400000.00440500.4557800.10455000.50AAB,AABB,AABBB, etc.Write egrep and regular expressions to accomplish the following pattern searches:a) search all the lines that contain "ABC", "ABCABC" and "ABCABCABC"b) search all the lines that contain "north"c) search all the lines that contain ".50" or ".00"

Explanation:a) To search for all the lines that contain "ABC", "ABCABC" and "ABCABCABC", we can use…

Below is a data file named as "mydata.txt": northwest NW Charles Main western WE Sharon Gray southwest SW southern southeast SE eastern northeast Lewis Dalsass SO Suan Chin Patricia Hemenway EA TB Savage NE AM Main Jr. NO Ann Stephens 300000.00 53000.89 290000.73 54500.10 400000.00 440500.45 57800.10 455000.50 north AB, ABB, ABBB, ABBBB, ABC ABCABC, ABCABCABC, AAA,AAAA, AAAAA AAB,AABB,AABBB, etc. Write egrep and regular expressions to accomplish the following pattern searches: a) search all the lines that contain "ABC", "ABCABC" and "ABCABCABC" b) search all the lines that contain "north" c) search all the lines that contain ".50" or ".00"

Below is a data file named as "mydata.txt": northwest NW Charles Main western WE Sharon Gray southwest SW southern southeast SE eastern northeast Lewis Dalsass SO Suan Chin Patricia Hemenway EA TB Savage NE AM Main Jr. NO Ann Stephens 300000.00 53000.89 290000.73 54500.10 400000.00 440500.45 57800.10 455000.50 north AB, ABB, ABBB, ABBBB, ABC ABCABC, ABCABCABC, AAA,AAAA, AAAAA AAB,AABB,AABBB, etc. Write egrep and regular expressions to accomplish the following pattern searches: a) search all the lines that contain "ABC", "ABCABC" and "ABCABCABC" b) search all the lines that contain "north" c) search all the lines that contain ".50" or ".00"

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: How can i transform this table to 1NF, 2NF, and 3NF ID First_Name Last_Name Game1_score…

A: 1NF:No multi-valued attribute should be there. 2NF:A relation must be in first normal form and…

Q: 1. Given the expression a*(b+tc)*d, write down its prefix notation and postfix notation.

A: Prefix and postfix notation of the given expression

Q: What Level of normalization is the following table? Student_ID Student_Name Course_ID…

A: The given table is in the First Normal Form (1NF), which means it has atomic values in each cell.

Q: Kaggie data se ice date Use the above data set Describe the data set • Use descriptive statistic…

A: Introduction

Q: 2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table…

A: 2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table…

Q: INSTRUCTIONS  Using spreadsheet software enter the following table below that shows the number of…

A: Organization and display of tourism information is crucial to understanding trends and making…

Q: 8002 1002 30/3/2020 528.10 8003 1003 12/4/2020 194.78 8004 1004 23/4/2020 619.44 1. Create both the…

A: Actually, database is a used to stores the data.

Q: The State of New York certifies firefighters throughout the state and must keep track of all of…

A: Given: The State of New York certifies firefighters throughout the state and must keep track of all…

Q: Identify the relational keys in the following two tables. Branch branchNo street city postcode 22…

A: we need some SQL keys here:- Keys aid in the identification of any row of data in a table. A table…

Q: complete n-ary tree is a tree in which each node has n children or no children. Let I be the number…

A: Introduction; Given, Complete n - ary tree. L= 41, I = 10. Then we have to find value of n"

Q: AIRPORT KLX TABLE Date 11-Dec 11-Dec 11-Dec 11-Dec 11-Dec 12-Dec 12-Dec 12-Dec AirlineID UA NW AA DL…

A: E4.5a The Insertion anomaly Suppose if the new terminal be in need of to get added that is not…

Q: Which code was used to make the plot below from the following dataset called df ?

A: Given dataset contains three columns that are serial numbers, total and eye_color. We need to plot…

Q: SQL 2019 The UTF-16 encoding can be used With A. the varchar data type B. a and b only C. the nchar…

A: UTF-16 encoding is a character encoding method that represents characters in a computer's memory as…

Q: SQL 2019 The UTF-8 encoding may be used with the following data types: a. the varchar data type; b.…

A: SQL Server 2019 is a widely used relational database management system (RDBMS) developed by…

Q: Population 29500000 25550000 17230000 Country Code SELECT * FROM Country; Population Code ISOCode2…

A: In SQL, the SELECT command is used in the SQL query to fetch the data from the table. The SQL query…

Q: Which dataset is the source for the following pivot? SalesOrder A5467 A8433 A5691 A5582 1255 23 8…

A: Here is the answer below:-

Q: A: obtain the name and credit limit of the customer whose number currently is stored in…

A: SQL is a computer language stands for Structured Query language.Which is used for operating…

Q: Identify the relational keys in the following two tables. Вranch branchNo street city postcode | 22…

A: Super Key – A super key is a group of single or multiple keys which identifies rows in a table.…

Question

Below is a data file named as "mydata.txt":
northwest NW Charles Main
western
WE Sharon Gray
southwest SW
Lewis Dalsass
southern
southeast SE
eastern
northeast
SO Suan Chin
Patricia Hemenway
EA TB Savage
NE
AM Main Jr.
NO Ann Stephens
north
AB, ABB, ABBB, ABBBB,
ABC,ABCABC, ABCABCABC,
AAA,AAAA, AAAAA
300000.00
53000.89
290000.73
54500.10
400000.00
440500.45
57800.10
455000.50
AAB,AABB,AABBB, etc.
Write egrep and regular expressions to accomplish the following pattern searches:
a) search all the lines that contain "ABC", "ABCABC" and "ABCABCABC"
b) search all the lines that contain "north"
c) search all the lines that contain ".50" or ".00"

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Answer

VIEW

Step 2: Answer

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

An online retailer stores information about the items purchased made by its customers. Each day the following information is summarized and stored in a publicly available database. • The date each item was purchased • The 5-digit product code of each item purchased • The prices in dollars at which the items were purchased • The number of purchases made of each item at each price A sample portion of the database is shown below. Date Product Code Purchase Price Number of purchases 21/05/2017 16342 23.95 7 21/05/2017 18442 23.95 7 21/05/2017 22345 5.88 22 21/05/2017 20964 32.14 10 22/05/2017 16342 24.45 22/05/2017 14224 42.99 1 Which of the following CANNOT be determined using only the information in the database? The number of purchases made by an individual customer O The average cost of an individual item purchase on the site. How many times a certain product was purchased in a given month. O The product code of the most-purchased item on the site in a given year.
Q2/ Consider the following table is used to store branch information: branchNo branchAddress telNos BO01 8 Jefferson Way, Portland, OR 97201 503-555-3618, 503-555-2727, 503-555-6534 BO02 City Center Plaza, Seattle, WA 98122 206-555-6756, 206-555-8836 BO03 14 -8th Avenue, New York, NY 10012 212-371-3000 BO04 16- 14th Avenue, Seattle, WA 98128 206-555-3131, 206-555-4112 The table is considered as not normalized, explain why? And what is the INF of the table?
It has to be based on this table
Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 215 84 2002 215 HS 1991 215 JC 1994 216 B4 1989 216 CDP 2004 216 CNP 2002 216 HS 1985 217 HS 1992 217 JC 2000 218 B4 1990 218 CDP 2000 218 CNP 2005 218 HS 1984 218 M2 1995 TABLE EMPLOYEE EDUCATION Table name: EDUCATION EDU_CODE EDU_DESCRIPTION a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. EMP_EDUC 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma PRIMARY KEY(s) Junior College degree Master's degree FOREIGN KEY(s)
SQL Data Manipulation Database tables are: Hospital hospitalNo name city 1493 Cambridge St Boston capacity Cambridge Mount Sinai 2 East 101st St H117 600 H120 New York 700 ******** ******* ******* Doctor doctorNo salary hospitalNo specialty Cardiologist Neurologist name Robert Donald Xin Wang D201 180000 H117 D205 225000 H120 Patient | age phoneNo 617-482-5801 212-353-1463 patientNo name doctor P366 Arthur Gluck 72 D201 P351 Lisa Hershman 46 D205 ****
Appendix EMPLOYEE Fnamo Minit Lname Ssn Bdato Addross Ser Salary Super ssn Dno 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 333445555 1955-12-08 638 Voss, Houston, TX John B Smith Franklin Wong 40000 888665555 25000 987654321 999887777 1968-01-10 3321 Castlo, Spring, TX Wallaco 987654321 1941-06-20 201 Borry, Bollaire, TX Alicia Zolaya 4. Jonnifor 43000 888665555 4. Narayan 666884444 1962-09-15 975 Fire Oak, Humblo, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX Ramosh K Joyce 25000 333445555 Ahmad V Jabbar 987987987 1969-03-20 980 Dalas, Houston, TX M 25000 087654321 4. James Borg 888665555 1937-11-10 450 Stono, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dnamo Dnumber Mgr ssn Mgr start date Dnumbor Dlocation Rosearch 333445555 1988-05-22 Houston Administration 4. 987654321 1995-01-01 Stafford Headquarters 1. 888665555 1981-06-19 5. Bellaire 5. Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456789…
Quick Answer please
Identify the relational keys in the following two tables. Branch branchNo street city postcode SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX BS99 INZ NW10 6EU BO05 22 Deer Rd London BO07 B003 BO04 32 Manse Rd Bristol BO02 56 Clover Dr London Staff staffNo fName IName position sex DOB salary branchNo SL21 John White Manager M 1-Oct-45 30000 BO05 SG37 Ann Beech Assistant F 10-Nov-60 12000 BO03 SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant F 19-Feb-70 9000 BO07 SG5 Susan Brand Manager F 3-Jun-40 24000 BO03 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 Tabel Superkey Candidate Primary Key Alternate Foreign Key Key Keys Branch Staff
SQL 2019 The UTF-8 encoding can be used with a. the varchar data type b. a and b only c. the char data type d. the nchar data type e. all of the above
Attribute Name Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 PROD NUM SALE DATE PROD LABEL VEND_CODE VEND_NAME QUANT SOLD PROD_PRICE AA-E3422QW 15-Jan-2018 Rotary sander 211 QD-300932X 15-Jan-2018 0.25-in. drill Band saw 211 309 NeverFail, Inc. NeverFail, Inc. BeGood, Inc. 1 $49.95 8 RU-995748G 15-Jan-2018 $3.45 1 $39.99 Sample Value Sample Value 211348 211349 AA-E3422QW 15-Jan-2018 Rotary sander 211 Power drill 157 NeverFail, Inc. ToughGo, Inc. 2 GH-778345P 16-Jan-2018 $49.95 1 $87.75 c) Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created.