Please identify the most appropriate data type(s) for the following scenarios (there may be more than one component): 1. 2. 3. 4. 5. 6. 7. N 8. 9. 10. A student's grade point average Unsigned char The number of courses a student has completed A person's first, middle, and last initials String Whether or not someone is a current student The day of the month The amount of money in a bank account The letter grade earned on an exam (Assuming the legal grades are A, B, C, D, and F.) The number of atoms in a mole of hydrogen, 6.02 x 1023 Do you like coffee? How many pet cats someone has

Please identify the most appropriate data type(s) for the following scenarios (there may be more than one component): 1. 2. 3. 4. 5. 6. 7. N 8. 9. 10. A student's grade point average Unsigned char The number of courses a student has completed A person's first, middle, and last initials String Whether or not someone is a current student The day of the month The amount of money in a bank account The letter grade earned on an exam (Assuming the legal grades are A, B, C, D, and F.) The number of atoms in a mole of hydrogen, 6.02 x 1023 Do you like coffee? How many pet cats someone has

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

Assume you're working on a Java application that will store the names and ages of a family's children. Describe how you would go about identifying the data types needed for your application. For your application, provide three (3) data components and their corresponding data types. Give a rationale for your response.
External data is typically excluded from a Data Strategy. A. True B. False
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
Study the relational schema: EMP(ID, Name, DeptID) DEPT(DeptID, DName, Loc) Which of the following join conditions will correctly join the two tables? a. Emp.Name = Dept.DName O b. Emp.ID = Dept.ID O c. Emp.DeptID = Dept.DeptID %3D d. Emp.ID = Dept.DeptID %3!
In the binary data below "1" is assigned to students who are business majors in a statistics class and "0" is for all other majors. 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1 0 1 1 1 1 0 1 0 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 17 What proportion of students are business majors? a 0.894 b 0.868 c 0.843 d 0.818
ID At_fault_claims 1001 0 1001 1 1002 0 1002 1 1002 1 1003 0 1004 1 1005 1 1005 0 Aggregate the the dataframe above at the ID to create the following claim count variables: : Number of At Fault claims Number of Not At Fault claims it should be written with python We should now have two additional columns 'at fault count' and 'not at fault count' in our aggregate dataframe
The histogram chart below has a single bar for every state in the United States. Each state is placed in a bucket, or range, based on its area in square miles. Count of States by Area in Square Miles 24 Area (Square Miles) (count) 18 12 50,000 100,000 150,000 200,000 Which of the following conclusions is BEST supported by the histogram chart? More than half of all states are smaller than 50,000 square miles B The most common size of states is between 50,000 and 100,000 square miles © Some states are larger than 200,000 square miles D More than half of all states are larger than 100,000 square miles
There have been several actors who have played the titular character in the British sci-fi series Doctor Who since the show began in the early 1960s. In 2005 the series was rebooted and Christopher Eccleston, David Tennant, Matt Smith, Peter Capaldi, and Jodie Whittaker have all played the Doctor since. Several Whovians (fans of the show) were asked to rank the actors of the Doctor from their favorite to their least favorite. The results are in the preference schedule below using the initials of each actor (so CE = Christopher Eccleston; DT = David Tennant; etc.). 6 8 12 16 17 18 23 20 1st Choice CE DT DT DT MS MS PC JW 2nd Choice MS CE PC PC JW CE JW CE 3rd Choice DT JW CE JW CE DT DT PC 4th Choice PC MS JW MS PC PC CE DT 5th Choice JW PC MS CE DT JW MS MS Is there a Condorcet winner?Answer: Explain: Do any of the voting methodsPlurality Method, Instant…
(1) Prompt the user for a title for data. Output the title. Ex: Enter a title for the data: Number of Novels Authored You entered: Number of Novels Authored (2) Prompt the user for the headers of two columns of a table. Output the column headers. Ex: Enter the column 1 header: Author name You entered: Author name Enter the column 2 header: Number of novels You entered: Number of novels (3) Prompt the user for data points. Data points must be in this format: string, int. Store the information before the comma into a string variable and the information after the comma into an integer. The user will enter -1 when they have finished entering data points. Output the data points. Store the string components of the data points in an ArrayList of strings. Store the integer components of the data points in a second ArrayList of integers. Ex: Enter a data point (-1 to stop input): Jane Austen, 6 Data string: Jane Austen Data integer: 6 (4) Perform error checking for the data point entries. If…
A_ risk calculation uses an "educated guess" based on observation rather than actual numbers based on historical data. (To help the auto-grader, give your answer either in ALL CAPS or all lowercase).
3. Consider the following tables and then provide a pipe diagram for the requested output. ID Age ID Gender ID Name ID Friend_ID 15 3 M Bob 6. 3 31 F 6. Maria Sally George Maria 8 45 F 8 8 11 11 33 11 F 2 11 8 19 2 11 8 ... ... ... ... ... ... a. The average age of users b. The name of the user with the most friends. c. The pairs of user ID for those that follow one another (e.g., if 3 is a friend of 6 and 6 is a friend of 3 then (3, 6) would be listed as one of the pairs). d. The 10 most common names for users under the age of 20. 4. As discussed in class, what are some advantages of functional programming? 5. Explain how parallel programing can be accomplished using Streams and functional programming in Java 8. 6. What aspects of functional programming align well parallel programming?
Program language: Python Prompt: Create histograms for each feature in a similar way for each of the different classes present in the data. Data: http://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data