šŸ·ļø LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION ā†’
Log in
HomeStudy Guides420,000CA160,000

ACS-1803 Study Guide - Final Guide: Query Language, Flat File Database, Cname Record

233 views7 pages
School
University of Winnipeg
Department
APPLIED COMPUTER SCIENCE
Course
ACS-1803
Professor
Eugene Kaluzniacky

For unlimited access to Study Guides, a Grade+ subscription is required.

Document Summary

These are the same questions i gave you to prepare for the mid- In bold ( also study the entire second. Set of questions on material after the mid term, that will be up. Give examples from student data: the smallest item of data is a character, but storing just characters alone in a computer won"t do; we need to group them. A group of characters is a field: the field has a name, a type (how the computer will represent it internally) and a length. e. g. , first name, text type, length 15 (incl. blanks). E. g. , john is an example of this field: a group of fields. side-by-side, is known as a record. : e. g. , a,b,9,%,$, layout (structure, or design). e. g. studno. 20: then there is the data record itself, that is, the real world data for one record that follows this layout.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers

Related Documents

ACS-1803
Final Exam
Study Guide
ACS-1803 Study Guide - Final Guide: Master Production Schedule, Material Requirements Planning, Vendor-Managed Inventory
burgundywhale514
BUS 237 Lecture Notes - Lecture 5: Content Management, Database Application, Relational Database
cyanlocust845
BUS 237 Lecture Notes - Lecture 5: Data Element, Web Server, Spreadsheet
emeralddinosaur257

Related Questions

Question 4. [4 MARKS] You decide to save all your passwords in files, one password per file. You then decide you want to update your 6-character UTORid password, but you don't remember which of your password files you saved it in. Luckily, this is the only 6-character password you have so you decide to write a function to find the password and change it. Your code runs, but the function's body contains four bugs which will result in the function execution not matching its docstring description. In the space provided, rewrite the buggy lines with the bugs fixed. Do not add or remove any lines. def change password(files_list, new-password): " (list of str, str) -> str Preconditions: (1) files list is not empty. (2) Each file in files_list contains one single-line password. (3) All files in files_list contain passwords of different lengths. (4) Your 6-character password is guaranteed to be in one of these files. In the appropriate file from files_list, replace your 6-character password with new-password, and return your old password. #Code If you think a given line contains a bug, rewrite it. Otherwise leave it blank. found = True for filename in files list[:-1]: passwd_file = open(filename, 'r') first line = passwd_file.read() password = first line.strip("2") if password == 6: passwd_file.close() passwd_file = open(filename, 'w') passwd_file.write(new_password) found = True passwd_file.close() if found: # This is correct. Do not modify. return password

Question 3. [5 MARKS] def return_mix(num, word): "(int, str) -> object Precondition: word contains at least 3 characters. if word [2] == 'r': return 2 * num elif num > 10: return (word + word) elif word[1:3] == "ab": return (2 == 3) Write the return value and type for each of the following function calls: Return value Return Type Function Call return_mix(5, "Canada") return_mix(12, "Toronto") return_mix(16, "Canada") return_mix(-2, "cabinet") return_mix(11, return_mix(11, "Can"))

Question 7. [11 MARKS] This question has you write the bodies of two functions. Complete each function according to its docstring. Part (a) [6 MARKS] Note: you will most likely not need all of the space on this page. def count_letter_case (L): "" (list of list of str) -> list of tuple of int Precondition: each str in L is non-empty and contains only alphabetic characters Count the number of words in each sublist of L that start with lowercase and uppercase letters. Return a new list where each element is a two-item tuple in which the first item is the number of words in the list at the corresponding index of L that start with a lowercase letter and the second item is the number of words in the list at the corresponding index of L that start with an uppercase letter. >>> count_letter_case([['apple', 'Banana'], ['PEAR'], [], ['PEACH', 'apRICot', 'plum']]) [(1, 1), (0, 1), (0, 0), (2, 1)]