1. In your "/bcs215 directory, make a directory called hw3 and change your working directory to hw3.cd -/bcs215mkdir hw3cd hw32. Use the vi editor to create three text file c1, el, and m1. Each contains a list of full names as follows. The filecl lists students who registered for CSC 101 class, el lists students who registered for EGL 102 class, and m1 listsstudents who registered for MAT 103 class. The student names are sorted in alphabetic order.Note: Don't leave any space at the end of a line or a file.cielm1Amanda AguilarAaron SmithAaron SmithAmanda AguilarBenjamin MillerAmber JohnsonBrandon BrownBrandon BrownChris DavisChris DavisBrandon BrownDavid ClarkDaniel HallBrian WilsonJack MooreElizabeth WalkerChris DavisJohn MartinJack MooreKalief YoungNick ThompsonKalief YoungMichael HarrisDaniel HallGeorge JohnsonsJohn MartinNick TurnerNick TurnerKaren AdamsRichard WrightNick ThompsonNora ParkerRichard WrightNora ParkerSteve JonesWayne Philips3. Use the vi editor to create a script called hw3script and add commands from 3.1 to 3.8 into the script file:3.1. Commands to display students who registered for each class and the number of students in each class.3.2. Commands to find a complete list of students who registered for any of three classes and output theresult to a file named students. The result should NOT contain duplicates and should be sorted inalphabetic order.Hints: Merge three student files end-to-end and remove duplicates.

cd hw3 the vi editor to create three text file c1, e1, and m1. Each contains a list of full nam students who registered for CSC 101 class, el lists students who registered for EGL 1 ts who registered for MAT 103 class. The student names are sorted in alphabetic ord Don't leave any space at the end of a line or a file. el m1 da Aguilar - Johnson Aaron Smith Aaron Smit Amanda Aguilar Benjamin Miller Brandon Br lon Brown Chris Davi -Dari e Brandon Broum David Clar

cd hw3 the vi editor to create three text file c1, e1, and m1. Each contains a list of full nam students who registered for CSC 101 class, el lists students who registered for EGL 1 ts who registered for MAT 103 class. The student names are sorted in alphabetic ord Don't leave any space at the end of a line or a file. el m1 da Aguilar - Johnson Aaron Smith Aaron Smit Amanda Aguilar Benjamin Miller Brandon Br lon Brown Chris Davi -Dari e Brandon Broum David Clar

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

Similar questions

Using python write a program that reads the data from the attached .csv file: Crude0il_20212022.csv. The file contains data regarding the price and volume of Crude Oil traded from August 2021 to July 2022. Once the data has been read, determine and display the following information: The highest and lowest Close/Last price for crude oil for the months of August 2021 through July 2022. Both prices must be displayed with 2 decimal places using an f-string. The number of trading days for the months of August 2021 through July 2022. The total trading volume for the months of August 2021 through July 2022 displayed with the thousands comma separated. The average daily trading volume for the months of August 2021 through July 2022 displayed with the thousands comma separated. Date Close/Last Volume Open High Low 8/2/2021 71.26 429120 73.91 73.95 70.55 8/3/2021 70.56 486786 71.52 71.96 69.19 8/4/2021 68.15 557749 70.32 70.81 67.85 8/5/2021 69.09 397456 68.06 69.35 67.61 8/6/2021 68.28 497049…
The file winning_numbers.txt contains the winning numbers for the Powerball lottery since the beginning of the year. Below is a partial listing of the file winning_numbers.txt: Drawing Date Winning Numbers Prize 1/1/2022 6 12 39 48 50 7 2 500000000 1/3/2022 2 13 32 33 48 22 2 540000000 1/5/2022 6 14 25 33 46 17 2 630000000 1/8/2022 20 21 36 60 65 13 10 20000000 1/10/2022 14 17 18 21 27 9 2 27000000 1/12/2022 12 21 22 30 33 24 4 38000000 1/15/2022 3 18 37 51 59 13 2 48000000 1/17/2022 9 24 35 46 65 22 2 53000000 1/19/2022 11 15 43 55 61 10 3 62000000 1/22/2022 8 14 33 36 67 17 2 76000000 The winning numbers for the date 1/1/2022 are: 6 12 39 48 50 7 2 The numbers 6 12 39 48 50 are considered the 5 white balls (ping pong balls with numbers on them), 7 is considered the Powerball (color is a red ping pong ball with a number on it), and 2 is considered the Powerball Multiplier. A player of the game wants to know which white balls have been selected with the greatest frequency and which…
R-Studio 1.) You have an airport routes.csv file that contains 3409 airports, each row has a 3-letter code and the number of routes. Example: Airport NumberOfRoutes AAE 9 AAL 20 AAN 2 AAQ 3 AAR 8 AAT 2 AAX 1 AAY 1 ABA 4 ABB 2 ABD 6 ABE 13 ABI 2 ABJ 49 ABL 4 ABM 1 ABQ 42 ABR 1 ABS 1 ABT 3 ABV 30 ABX 4 ABY 4 ABZ 41 ACA 8 ACC 54 ACE 116 ACH 2 ACI 2 ACK 6 ACR 2 ACT 2 ACU 1 ACV 3 ACX 6 ACY 10 ACZ 1 ADA 17 ADB 66 ADD 105 ADE 23 ADF 2 ADK 1 ADL 51 ADQ 11 ADU 3 ADZ 11 AEB 3 AEP 65 For this dataset, consider the following models:(a) Suppose the given data points follow a power law distribution. Estimate the corresponding α parameter. (b) Suppose the given data points follow an exponential distribution. Estimate the corresponding λ parameter. (c) Suppose the given data points follow a uniform distribution. Estimate the corresponding range parameters [a, b] of the uniform distribution.(d)…
In python
main.asm %include "lib.asm" section .textglobal _start _start: ;; YOUR CODE HERE!; ; SAMPLEmov rdi, 65536 ; going to print 65536call print_num ; print the numbercall print_lf ; move to next line exit:mov rax, 60 ; exitmov rdi, 0 ; return codesyscall
Please give correct code. Thanks
save_compressed_image: takes a nested list and a filename (string) as input, and saves it in the compressed PGM format to a file with the given filename. If the image matrix given as input is not a valid compressed PGM image matrix, instead raise a AssertionError with an appropriate error message. >>> save_compressed_image([["0x5", "200x2"], ["111x7"]], "test.pgm.compressed") >>> fobj open("test.pgm.compressed", 'r') >>> fobj.read() = 'P2C\\n7_2\\n255\\n0x5 200x2\\n111x7\\n' >>> fobj.close() >>> image [["0x5", "200x2"], ["111x7"]] >>> save_compressed_image(image, "test.pgm") >>> image2 = >>> image True = == load_compressed_image("test.pgm") image2 • save_image: takes a nested list and a filename (string) as input. Checks the type of elements in the list If thou are intogors thon saves the posted list as a PCM imago matrix into a file with the given
A bucket list is a collection of goals, dreams, and aspirations that you would like to accomplish within your lifetime. The purpose of this assignment is to develop a program that allows the user to manage their personal bucket list and save it to an XML file bucketlist.xml. For full credit, run the program and create a file with at least three entry elements. Submit a document containing a copy of the source file, a screenshot of the program in action, and the contents of the XML file. File Structure Below is the basic structure (i.e. schema) for the XML file. You may add additional elements. <bucketList> <entry> <rank></rank> <description></description> <status></status> </entry> </bucketList> Note: Before running the program, manually create an XML input file with at least one entry element that contains values in each child element. GUI Requirements At a minimum, your GUI must meet the below requirements. No minimize…
The file london_weather.csv contains weather data for the years 1979 to 2020. The first five lines of this file are: date,cloud_cover,sunshine,global_radiation,max_temp,mean_temp,min_temp,precipitation,pressure,snow_depth19790101,2,7,52,2.3,-4.1,-7.5,0.4,101900,919790102,6,1.7,27,1.6,-2.6,-7.5,0,102530,819790103,5,0,13,1.3,-2.8,-7.2,0,102050,419790104,8,0,13,-0.3,-2.6,-6.5,0,100840,2 Note, in particular, that the dates are given as eight-digit integers in the format YYYYMMDD. There appears to be some inconsistencies in this data, as there are rows for which the column max_temp contains an entry that is smaller than the corresponding entry in min_temp. Write a Python function wrong_temperature(year) that returns the number of days in a given year for which the column max_temp contains an entry that is smaller than the corresponding entry in the column min_temp.
+|| 8 Exercise 1 (2%) Create an anonymous block that displays a course list. Declare a cursor and use the OPEN,FETCH, and CLOSE cursor statements to access the cursor. Use the %ROWTYPE attribute for the cursor. Output: Course Code Course Title Accounting Theory Microeconomics Financial Accounting Anthropology Introduction to Business Businéss Planning Web Technologies I Programming Logic Web Technologies II Python Programming Web Technologies III Database Design & SQL Communications I ACC104 ACC205 ANT100 BUS100 BUS230 CIS100 CIS105 CIS200 CIS225 00ESI) CIS400 ENG101 ENG201 GEO101 MGT410 Communication II The Physical Environment Human Resources Management Project Management Algebra Geometry Nursing Theory I Nursing Theory II MGT415 MTH120 MTH400 NSG130 NSG230 -19°C Mostly sunny ^ o prt sc home end insert delete F6 F7 F10 F11 F12 81 ) ( num backspace lock 6 } { ] enter 7. shift B. / dn 6d up 6d alt ctrl >
Code
Command Program Create a program that allows you to view and edit the sales amounts for each month of the current year. This program is required to use commands add, view, totals, edit, and exit. The program should use a list to store the sales data for each month with the three-letter abbreviation for the month (Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec) to use as the key for each item. When the program starts, it should read the sales data inserted from the user. If the user edits the sales data, the program should edit the data If the user selects total, then the program should calculate the total sales and average monthly sales. Use functions to view sales, edit sales, calculate total, and calculate average. Please use all commands, and thank you in advance.