. The student data file contains the following attributes: - Id: Integer (2 bytes) - Name: Varchar(16) (16 bytes) - Age: Integer (2 bytes) - Phone: Varchar(10) ( bytes) There are 10,000 records in this data file. We want to store the data file in a hard drive with the block(page) size = 1024 bytes. 1.1 How many blocks or pages that need for storing this data file in a hard drive? (3 pts.) 1.2 If we store the data file in SQLite, how many blocks or pages that need for the storing?

. The student data file contains the following attributes: - Id: Integer (2 bytes) - Name: Varchar(16) (16 bytes) - Age: Integer (2 bytes) - Phone: Varchar(10) ( bytes) There are 10,000 records in this data file. We want to store the data file in a hard drive with the block(page) size = 1024 bytes. 1.1 How many blocks or pages that need for storing this data file in a hard drive? (3 pts.) 1.2 If we store the data file in SQLite, how many blocks or pages that need for the storing?

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 1GZ

See similar textbooks

Similar questions

Python How to read a file into a dictionary when key is on the first line of the text and value is on the second line of the text Example of the text file: Alabama (should be assign as key) Montgomery (should be assign as value) Alaska Juneau Arizona Phoenix
A file has r=20000 STUDENT records of fixed-length. Each record has the following fields: NAME (30 bytes), SSN (10 bytes), ADDRESS (40 bytes), PHONE (9 bytes), BIRTHDATE (8 bytes), SEX (1 byte), MAJORDEPTCODE (4 bytes), MINORDEPTCODE (4 bytes), CLASSCODE (4 bytes, integer), and DEGREEPROGRAM (3 bytes). Suppose the block size is 512 bytes. (a) Calculate the record size R in bytes. (b) Calculate the blocking factor (number of tuples per block) and the number of blocks required. (c) Calculate the average block accesses it takes to find a record by doing a linear search on the file. (d) Assume the file is ordered by SSN; calculate the block accesses takes to search for a record given its SSN value by doing a binary search.
A file has r = 20, 000 STUDENT records of fixed length. Each record has the following fields: NAME (30 bytes), SSN (9 bytes), ADRESS(40 bytes), PHONE(9 bytes), BIRTHDATE (8 bytes), SEX(1 byte), CLASSCODE( 4 bytes, integer) MAJORDEPTCODE(4 bytes), MINORDEPTCODE(4 bytes), and DEGREEPROGRAM( 3 bytes). An additional byte is used as a deletion marker. Block size B = 512 bytes. a) Calculate the blocking factor bfr (=floor(B/R), where R is the record size) and number of file blocks b, assuming unspanned organization (a record can’t be split across blocks). b) Suppose only 80% of the STUDENT records have a value for PHONE, 85% for MAJORDEPTCODE, 15% for MINORDEPTCODE, and 90% for DEGREEPROGRAM. We use a variable-length record file. Each record has a 1-byte field type for each field in the record, plus the 1-byte deletion marker and a 1-byte end-of-record marker. Suppose that we use a spanned record organization, where each block has a 5-byte pointer to the next block (this space is not used…
A movie file has the following record structure:name ofthe movie producer director type productioncostAssume that the name of the movie is the primary key of the file. Thefield type refers to the type of the movie, for example, drama, sci-fi, horror, crimethriller, comedy and so forth. Input a sample set of records of your choice into themovie file.i) Implement a primary index-based ISAM file organization.ii) Implement secondary indexes on director, type and productioncost.
Program this Sometimes data comes in as a structured format that you have to break down and turn into records so you can process them. CSV, or comma-separated values, is a common standard for doing this. Construct a program that reads in the following data file: Lee, Jason, 55908 Flores, Jim, 56500 Cruz, Aaron, 46000 Cruz, Chris, 34500 Swift, Geoffrey, 14200 Xiong, Fong, 65000 Zafra, Sabrina,51500 Process the records and display the results formatted as a table, evenly spaced, as shown in the example output. EXAMPLE OUTPUT Last First Salary $65,000 $56,500 $55,900 Xiong Fong Flores Jim Lee Jason Zafra Sabrina Cruz Aaron Cruz Chris Swift $51,500 $46,000 $34,500 Geoffrey $14,200 CONSTRAINTS 1. Write your own code to parse the data. Don't use a CSV parser 2. Use string formatting to properly space out the columns. Make each column one space longer than the longest value in the column. 3. Format the salary as currency with dollar signs and commas. 4. Sort the results by salary from highest…
Instructions Your job is to write a program to encrypt outgoing messages and decrypt incoming messages using a Vigenere Cypher. In this assignment, you will parse a string of words from a file into tokens using the strtok_s command with pointers and then use the Vigenere Cypher algorithm to encrypt and decrypt the parsed words. Before you can perform any encryption/decryption activities, the first step is to read in messages from a file and parse the messages into individual words. The Program: Setting up classes and understanding tokenization The first step in encrypting/decrypting messages is to parse the messages into words before applying the encryption/decryption algorithms to them. This parsing process is called “tokenization.” Read the contents of a file into this array using the getline command. The objective of this assignment is to demonstrate the use of pointers in a program utilizing c-strings and tokenization. The use of pointers is foundational in C++. This…
Sometimes data comes in as a structured format that you have to break down and turn into records so you can process them. CSV, or comma-separated values, is a common standard for doing this. Construct a program that reads in the following data file: Lee, Jason, 55900 Flores, Jim, 56500 Cruz, Aaron, 46000 Cruz, Chris, 34500 Swift, Geoffrey, 14200 Xiong, Fong, 65000 Zafra,Sabrina,51500 Process the records and display the results formatted as a table, evenly spaced, as shown in the example output. EXAMPLE OUTPUT Last Xiong Flores Lee Zafra Cruz Cruz Swift First Salary Fong $65,000 Jim $56,500 Jason $55,900 Sabrina $51,500 Aaron $46,000 Chris $34,500 Geoffrey $14,200 CONSTRAINTS 1. Write your own code to parse the data. Don't use a CSV parser 2. Use string formatting to properly space out the columns. Make each column one space longer than the longest value in the column. 3. Format the salary as currency with dollar signs and commas. 4. Sort the results by salary from highest to lowest.…
A new video store in your neighborhood is about to open. However, it does not have a program to keep track of its videos and customers. The store managers want someone to write a program for their system so that the video store can operate. The program will require you to design 2 ADTs as described below: [1] VIDEO ADT Data Operations Video_ID (preferably int, auto-generated) Movie Title Genre Production Number of Copies Movie Image Filename [1] Insert a new video [2] Rent a video; that is, check out a video [3] Return a video, or check in, a video [4] Show the details of a particular video [5] Display all videos in the store [6] Check whether a particular video is in the store [2] CUSTOMER PARENT ADT Data Operations Customer_ID (preferably int, auto-generated) Name Address [1] Add Customer [2] Show the customer details [3] Print list of all customers [3] CUSTOMER-RENT CHILD ADT Customer_ID ( Video_ID (of all rented videos of a…
A new video store in your neighborhood is about to open. However, it does not have a program to keep track of its videos and customers. The store managers want someone to write a program for their system so that the video store can operate. The program will require you to design 2 ADTs as described below: [1] VIDEO ADT Data Operations Video_ID (preferably int, auto-generated) Movie Title Genre Production Number of Copies Movie Image Filename [1] Insert a new video [2] Rent a video; that is, check out a video [3] Return a video, or check in, a video [4] Show the details of a particular video [5] Display all videos in the store [6] Check whether a particular video is in the store [2] CUSTOMER PARENT ADT Data Operations Customer_ID (preferably int, auto-generated) Name Address [1] Add Customer [2] Show the customer details [3] Print list of all customers [3] CUSTOMER-RENT CHILD ADT Customer_ID ( Video_ID (of all rented videos of a…
def create_dict_by_region(directory_path, number_of_regions):"""Given a directory of files with name of the form "regionN.txt" where goes from1 to number_of_regions.Create two dictionaries:- dict1: a dictionary where the keys are the region number and the value is the nameof that region.- dict2: a dictionary where the keys are the names of the regions and the value isa list of the states in that region.:param directory_path: the directory where these files are:param: number_of_regions: the number of region files we expect to find in the directory:return: tuple of the two dictionaries dict1, dict2"""REGIONS FILES: REGION1 FILE:North PA NY REGION 2 FILE: Middle VA MD NC REGION 3 FILE: South GA AL REGION 4 File: West TX NM OK CA
Sometimes data comes in as a structured format that you have to break down and turn into records so you can process them. CSV, or comma-separated values, is a common standard for doing this. Construct a program that reads in the following data file: Lee, Jason, 55900 Flores, Jim, 56500 Cruz, Aaron, 46000 Cruz, Chris, 34500 Swift, Geoffrey, 14200 Xiong, Fong, 65000 Zafra,Sabrina,51500 Process the records and display the results formatted as a table, evenly spaced, as shown in the example output. EXAMPLE OUTPUT Last Xiong Flores Lee Zafra Cruz Cruz Swift First Salary Fong $65,000 Jim $56,500 Jason $55,900 $51,500 $46,000 $34,500 Geoffrey $14,200 Sabrina Aaron Chris CONSTRAINTS 1. Write your own code to parse the data. Don't use a CSV parser. (3 points) 2. Use string formatting to properly space out the columns. Make each column one space longer than the longest value in the column. (4 points) 3. Format the salary as currency with dollar signs and commas. (2 points) 4. Sort the results by…
Using visual studio 2019 and using c# programming Create a WPF app that will take a value n from the user, representing a side of a square matrix. Your program will generate an n x n char matrix. The chars’ values are randomly generated. This matrix will be printed into a text file. Suppose the data that is contained in the text file is as follows. s d k w e a e r e q j g e u c n t q a d s w a s f w t n The user must be able to provide a string to your app and your app will verify that the string exists in the generated matrix. For example, suppose the user wants to see if qwerty is in the matrix. The user provides qwerty to your system, and they are informed it doesn’t exist in there! What if the user provides aereq? Well, the user will be informed the string exists. I will only be testing in the vertical (going down) and horizontal (going right to left) directions. Please explain your algorithms for this part