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

  Primary key identified for each relation

Review the Entity Relationship diagram and derive a relational schema using the rules and naming conventionsof the course text. A primary key identified for each relation

  Explain a structured data type that can hold multiple values

The array was the first example of a structured data type that can hold multiple values. The structure is the second example

  Verify your implementation by viewing the data dictionary

Implement the authorization table using any two suitable application models presented - Use the scripts provided to create a schema - Create three different profiles based on the criteria.

  Does the relational model as seen by an sql query writer

Does the relational model, as seen by an SQL query writer, provide physical and logical data independence? Explain.

  Explain how data is physically stored and accessed

Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

  Describe the different procedure performed in dbms

Describe the different procedure performed in DBMS for student database in which fields are student id, student name, student class, marks.

  Ideal choice for relational database design

The Entity-Relationship Diagram is widely used in the design of relational databases. Why do you think this is so - what is it about this model that makes it the ideal choice for relational database design?

  Implement a good information systems plan

Implementation of business analytics, an organization will also need to implement a good information systems plan in order to collect, manage, and organize all of the data.

  Modifying a database design in visio

Modifying a Database Design in Visio- This assignment contains two (2) Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment

  Main types of actions involve databases

What four main types of actions involve databases? Briefly discuss each. What are the responsibilities of the DBA and the database designers? What is the difference between a database schema and a database state?

  Suggest a learning algorithm for the problem

What is required to defi ne a well-posed learning problem ?

  Design an expanded entity relationship model diagram

You are to design an Expanded Entity Relationship Model Diagram. An example of the Expanded Entity Relationship Model Diagram is seen in Figure 3.27 on page 89.

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