Write the file, type wq!, and then press enter

Assignment Help Database Management System
Reference no: EM13947933

Use vi to create a data file with records. You will then sort the data.

* Log in to the Linux system as a user, and then open a Terminal emulation window.

* Type mkdir Project2-9, and then press Enter.

* Type cd Project2-9, and then press Enter.

* Type vi infile.dat, and then press Enter. The vi editor opens.

* To insert text, press Esc, and then Type i.

* Enter the following text and make sure you press Enter at the end of each line. (Each row is considered an employee record with colons separating the fields. The first field is the employee number. The second field is the employee name, and the third field is the employee salary.)

* To save the file, press Esc, and then type the colon symbol (:). The cursor moves to the bottom of the screen with a colon to its left.

* To write the file, type wq!, and then press Enter. The prompt returns.

* Sort the data in ascending order by typing sort infile.dat, press

* Enter, and then record the output.

* Sort the data in descending order by typing sort -r infile.dat, press * Enter, and then record the output.

* Sort the data in descending order and redirect the output to another file by typing sort -r infile.dat > reverse_sort.dat, and then press Enter.

* Sort the data in ascending order, redirect the output to another file, and then record the command you used.

* Close your window, and then log out.

Project 2-10

You will use the files created in Project 2-10. Project 2-10 requires completion of Project 2-9.

* Log in to the Linux system as a user, and then open a Terminal emulation window.

* Type cd Project2-9, and then press Enter.

* Cut the first field.

* Cut the second field.

* Cut the third field.

* Cut both the first and third field and redirect the output to a new file named salary.dat.

* Make a duplicate of infile.dat by typing cp infile.dat infile2.dat, and then press Enter.

* Open the file named infile2.dat, and add five additional records. Add a sixth record that has your name. Also, create a fictitious employee number and employee salary to complete your record.

* Type diff infile.dat infile2.dat, and then press Enter. Record the output.

* Close your window, and then log out.

Attachment:- ff.png

Reference no: EM13947933

Questions Cloud

Interplanar spacing for set of planes : 1. The metal rhodium has an FCC crystal struc- ture. If the angle of diffraction for the (311) set of planes occurs at 36.12° (first-order reflec- tion) when monochromatic x-radiation having a wavelength of 0.0711 nm is used, compute (a)  the inte..
Prepare new performance report for september using flexible : Prepare a new performance report for September using the flexible budget approach. (Note: Even though some of these costs might be classified as direct costs rather than as overhead, the flexible budget approach can still be used to prepare a flex..
The company''s quality control lab : Ernest lost both his legs in combat in Iraq. He has applied for a job with Excelsior Products in the company's quality control lab. The job requires inspectors to randomly check products coming off the assembly line for defects. Historically, all ins..
Would there be differences in the decision making process : Would there be differences in the decision making process when involving these individuals?
Write the file, type wq!, and then press enter : Enter the following text and make sure you press Enter at the end of each line. (Each row is considered an employee record with colons separating the fields. The first field is the employee number. The second field is the employee name, and the th..
Experiences you have had when you were exposed : Reflect on experiences you have had when you were exposed to different training methods (as trainer or trainee). Share personal advantages and disadvantages of each experience
The buyer later refuses to perform the contract : Jack wants to sell his house. He hires Walter, a real estate broker, to sell the house and signs an exclusive right-to-sell listing agreement. Walter finds a buyer, who signs a sales contract with Jack. However, the buyer later refuses to perform the..
Prepare a strategy map that illustrates the causal paths : Finally, prepare a strategy map that illustrates the causal paths. In preparing the map, use only three perspectives: learning and growth, process, and financial.
What a floor plan would involve : What he has in mind, think about strategic management, marketing, and other professional management activities, and provide insights into exactly what such a floor plan would involve.

Reviews

Write a Review

Database Management System Questions & Answers

  Explain the purpose database design process

Explain why functional dependency is important in relational design. Database Design: Why go through the database design process? What are important issues during the design phase that impact the success of the database?

  Create a simple query for each table that returns

Create a simple query for each table that returns all of the columns and all of the rows for each table. Write a query that displays each part that has been purchased by Huffman Trucking Company

  Review of object oriented software development methodologies

Analyze how the verify method can be used to plan out system effectively and ensure that the number of transactions do not produce record-level locking while the database is in operation.

  Search and set up the national parks database

create a table named Park. Accept the default ID primary key field with the AutoNumber data type, renaming it as Park ID. Enter at least five additional fields, such as Name, State, Fee, Hours

  Create a database for the application

Perform the following tasks to create the database required for the application: Create a database for the application.

  Make a report that identifies the most expensive bicycles

Prepare a report that identifies the five most expensive bicycles. The report should list the bicycles in descending order from most expensive to lsit expensive, the quantity on hand for each, and the mark up percentage for each.

  Database management system and database design

To what extent should end users be involved in the selection of a database management system and database design

  Create database to keep information of movies

Create a database for Ray. He is interested in movies and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce reports.

  Prepare fully attributed data model

Use the results of the transcripts of an interview with IT consultant. Prepare a Fully Attributed Data Model. Add the data attributes for each entity."

  Why would you choose a database system instead of simply

Why would you choose a database system instead of simply storing data in operating system files? When would it make sense not to use a database system?

  Create a clustered index on the groupid column

Write the CREATE INDEX statements to create a clustered index on the GroupID column and a nonclustered index on the IndividuallD column of the GroupMembership table.

  An electronic logic gate whose output is logic 0

An electronic logic gate whose output is logic 0 only when all inputs are logic 1

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd