Discovering Computers ©2016 (Shelly Cashman Series) (MindTap Course List)
1st Edition
ISBN: 9781305391857
Author: Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Jennifer T. Campbell, Mark Frydenberg
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 11, Problem 2SG
Explanation of Solution
Field:
In relational
- In other words, the group of related column is called field.
Field name:
- A field name is one that uniquely identifies each field.
- For searching the data in the database, the field name must be specified...
Explanation of Solution
Common data types:
Some of the commonly used data types are:
- CHAR(n)
- VARCHAR(n)
- DATE
- DECIMAL(p,q)
- INT
- SMALLINT
“CHAR” data type:
A “CHAR” data type is a data type that represents the characters in the character set. It is used to specify the letters, special characters and columns containing numbers.
“VARCHAR” data type:
The “VARCHAR” data type is used to store a character string which extends up to “n” character. Here, “n” specifies the maximum number of character that the particular column tends to hold.
“DATE” data type:
This data type is used to store date and sometimes, time values. Usually DBMS stores the value of date in the numeric format according to the Julian calendar...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Draw a system/level-0 diagram for this scenario: You are developing a new customer relationship management system for the BEC store, which rents out movies to customers. Customers will provide comments on new products, and request rental extensions and new products, each of which will be stored into the system and used by the manager for purchasing movies, extra copies, etc. Each month, one employee of BEC will select their favorite movie pick of that week, which will be stored in the system. The actual inventory information will be stored in the Entertainment Tracker system, and would be retrieved by this new system as and when necessary. Example of what a level-0 diagram looks like is attached.
What is the value of performing exploratory data analysis in designing data visualizations? What are some examples?
Draw a level-0 diagram for this scenario: You are developing a new customer relationship management system for the BEC store, which rents out movies to customers. Customers will provide comments on new products, and request rental extensions and new products, each of which will be stored into the system and used by the manager for purchasing movies, extra copies, etc. Each month, one employee of BEC will select their favorite movie pick of that week, which will be stored in the system. The actual inventory information will be stored in the Entertainment Tracker system, and would be retrieved by this new system as and when necessary.
Chapter 11 Solutions
Discovering Computers ©2016 (Shelly Cashman Series) (MindTap Course List)
Ch. 11 - Define the terms, database and database software....Ch. 11 - Prob. 2SGCh. 11 - Prob. 3SGCh. 11 - Prob. 4SGCh. 11 - Prob. 5SGCh. 11 - Explain how a DBMS might manage deleted or...Ch. 11 - Prob. 7SGCh. 11 - Prob. 8SGCh. 11 - Prob. 9SGCh. 11 - Prob. 10SG
Ch. 11 - Prob. 11SGCh. 11 - Prob. 12SGCh. 11 - Prob. 13SGCh. 11 - Prob. 14SGCh. 11 - Prob. 15SGCh. 11 - Prob. 16SGCh. 11 - Prob. 17SGCh. 11 - A(n) _____ is a request for specific information...Ch. 11 - Prob. 19SGCh. 11 - Prob. 20SGCh. 11 - Prob. 21SGCh. 11 - Prob. 22SGCh. 11 - Prob. 23SGCh. 11 - Prob. 24SGCh. 11 - Prob. 25SGCh. 11 - Prob. 26SGCh. 11 - Prob. 27SGCh. 11 - Prob. 28SGCh. 11 - Prob. 29SGCh. 11 - Prob. 30SGCh. 11 - Prob. 31SGCh. 11 - Prob. 32SGCh. 11 - Prob. 33SGCh. 11 - Prob. 34SGCh. 11 - Prob. 35SGCh. 11 - Prob. 36SGCh. 11 - Prob. 37SGCh. 11 - Prob. 38SGCh. 11 - Prob. 39SGCh. 11 - Prob. 40SGCh. 11 - Prob. 41SGCh. 11 - Prob. 42SGCh. 11 - Prob. 43SGCh. 11 - Define the following terms: programming language,...Ch. 11 - Prob. 45SGCh. 11 - Define the terms, procedural language, compiler,...Ch. 11 - Prob. 47SGCh. 11 - Prob. 48SGCh. 11 - Prob. 49SGCh. 11 - Prob. 1TFCh. 11 - Prob. 2TFCh. 11 - Prob. 3TFCh. 11 - Prob. 4TFCh. 11 - Prob. 5TFCh. 11 - Prob. 6TFCh. 11 - Prob. 7TFCh. 11 - Prob. 8TFCh. 11 - One way to secure a database is to allow only...Ch. 11 - In a rollforward, the DBMS uses the log to undo...Ch. 11 - Prob. 11TFCh. 11 - Prob. 12TFCh. 11 - Prob. 1MCCh. 11 - Prob. 2MCCh. 11 - Prob. 3MCCh. 11 - Prob. 4MCCh. 11 - Prob. 5MCCh. 11 - Prob. 6MCCh. 11 - _____ feasibility measures whether an organization...Ch. 11 - Prob. 8MCCh. 11 - Prob. 1MCh. 11 - Prob. 2MCh. 11 - Prob. 3MCh. 11 - Prob. 4MCh. 11 - Prob. 5MCh. 11 - Prob. 6MCh. 11 - Prob. 7MCh. 11 - Prob. 8MCh. 11 - Prob. 9MCh. 11 - Prob. 10MCh. 11 - Prob. 2CTCh. 11 - Prob. 3CTCh. 11 - What is function creep?Ch. 11 - Prob. 5CTCh. 11 - Prob. 6CTCh. 11 - Prob. 7CTCh. 11 - Prob. 8CTCh. 11 - Prob. 9CTCh. 11 - Prob. 10CTCh. 11 - Prob. 11CTCh. 11 - Prob. 12CTCh. 11 - Prob. 13CTCh. 11 - Prob. 14CTCh. 11 - Prob. 15CTCh. 11 - Prob. 16CTCh. 11 - Prob. 17CTCh. 11 - Prob. 18CTCh. 11 - Prob. 19CTCh. 11 - Prob. 20CTCh. 11 - Prob. 21CTCh. 11 - Prob. 22CTCh. 11 - Prob. 23CTCh. 11 - Prob. 24CTCh. 11 - Prob. 25CTCh. 11 - Prob. 26CTCh. 11 - Prob. 27CTCh. 11 - Prob. 28CTCh. 11 - Prob. 1PSCh. 11 - Prob. 2PSCh. 11 - Prob. 3PSCh. 11 - Prob. 4PSCh. 11 - Prob. 5PSCh. 11 - Prob. 6PSCh. 11 - Prob. 7PSCh. 11 - Prob. 8PSCh. 11 - Database Recovery Your boss has informed you that...Ch. 11 - Prob. 10PSCh. 11 - Prob. 11PSCh. 11 - Prob. 1.1ECh. 11 - Prob. 1.2ECh. 11 - Prob. 1.3ECh. 11 - Prob. 2.1ECh. 11 - Prob. 2.2ECh. 11 - Prob. 2.3ECh. 11 - Prob. 3.1ECh. 11 - Prob. 3.2ECh. 11 - Prob. 3.3ECh. 11 - Prob. 4.1E
Knowledge Booster
Similar questions
- Draw a context diagram for this scenario: You are developing a new customer relationship Management system for the BEC store, which rents out movies to customers. Customers will provide comments on new products, and request rental extensions and new products, each of which will be stored into the system and used by the manager for purchasing movies, extra copies, etc. Each month, one employee of BEC will select their favorite movie pick of that week, which will be stored in. the system. The actual inventory information will be stored in the Entertainment Tracker system, and would be retrieved by this new system as and when necessary.arrow_forwardWrite a complete Java program named FindSumAndAverage that performs the following tasks in 2-D array: Main Method: a. The main() method asks the user to provide the dimension n for a square matrix. A square matrix has an equal number of rows and columns. b. The main() method receives the value of n and calls the matrixSetUp() method that creates a square matrix of size n and populates it randomly with integers between 1 and 9. c. The main method then calls another method named printMatrix() to display the matrix in a matrix format. d. The main method also calls a method named findSumAndAverage() which: • Receives the generated matrix as input. • Calculates the sum of all elements in the matrix. • Calculates the average value of the elements in the matrix. • Stores these values (sum and average) in a single-dimensional array and returns this array • e. The main method prints the sum and average based on the result returned from findSumAndAverage()). Enter the dimension n for the square…arrow_forwardThe partial sums remain the same no matter what indexing we done to s artial sum of each series onverges, * + s of each series to the series or show 12. (1)+(0)+(0)+(+1)+ 17, " (F) + (F) + (F)(F)(- 18. 19. 1 #20. (三)+(三)-(三)+(3) 20 (9)-(0)-(0)-- 10 +1 2.1+(男)+(男)+(罰)+(鄂 9 T29 x222-끝+1-23 + -.... Repeating Decimals 64 Express each of the numbers in Exercises 23-30 as the m integers. 23. 0.23 = 0.23 23 23... 24. 0.234 = 0.234 234 234. 25. 0.7 = 0.7777... 26. 0.d = 0.dddd... where d is a digit natio of own s converges or * 27. 0.06 = 0.06666.. 28. 1.4141.414 414 414... 29. 1.24123 = 1.24 123 123 123... 30. 3.142857 = 3.142857 142857. Using the ath-Term Test In Exercises 31-38, use the ath-Term Test for divergence to show that the series is divergent, or state that the test is inconclusive 8arrow_forward
- CPS 2231 Computer Programming Homework #3 Due Date: Posted on Canvas 1. Provide answers to the following Check Point Questions from our textbook (5 points): a. How do you define a class? How do you define a class in Eclipse? b. How do you declare an object's reference variable (Hint: object's reference variable is the name of that object)? c. How do you create an object? d. What are the differences between constructors and regular methods? e. Explain why we need classes and objects in Java programming. 2. Write the Account class. The UML diagram of the class is represented below (10 points): Account id: int = 0 - balance: double = 0 - annualInterestRate: double = 0.02 - dateCreated: java.util.Date + Account() + Account(id: int, balance: double) + getId(): int + setId(newId: int): void + getBalance(): double + setBalance(newBalance: double): void + getAnnualInterestRate(): double + setAnnualInterest Rate (newRate: double): void + toString(): String + getDataCreated(): java.util.Date +…arrow_forwardTHIS IS NOT A GRADING ASSIGNMENT: Please only do lab 2.2 (bottom part of the first picture) For that Lab 2.2 do: *Part 1 (do the CODE, that's super important I need it) *Part 2 *Part 3 I also attached Section 2.5.2 which is part of the step 1 so you can read what is it about. Thank you!arrow_forwardTHIS IS NOT A GRADING ASSIGNMENT: Please only do lab 2.2 (bottom part of the first picture) For that Lab 2.2 do: *Part 1 *Part 2 *Part 3 I also attached Section 2.5.2 which is part of the step 1 so you can read what is it about. Thank you!arrow_forward
- can you please give me: * the code (step 3) *the list file (step 5) *and answer step 6 Thank youarrow_forward# Find the error# Why will the following code not print out a list of contact namesphoneBook = {'Doe, Jane' : '843-000-0000' ,'Doe, John' : '843-111-1111' ,'Smith, Adam' : '843-222-2222' ,'Jobs, Steve' : '999-333-3333' ,}for contact in phoneBook.values():print(contact)arrow_forward# Find the error:# The following code creates an empty dictionary and attempts to add a record# Why will the following code not create a new dictionary entry as intended?phoneBook = {}phoneBook{'Jobs, Steve'} = '999-111-1111'arrow_forward
- Select all the possible polar representations of the vector that is obtained from rotating where by Zrot Ź x = 3e² T= 3п 8 Hint: Consider the negative angle that is equivalent to the positive angle of the rotated vector. 0arrow_forwardCharacter Analysis If you have downloaded the source code you will find a file named text.txt on the Chapter 08 folder. Write a program that reads the file's contents and determines the following: The number of uppercase letters in the file The number of lowercase letter in the file The number of digits in the file The number of whitespace characters in the filearrow_forwardWrite a program that reads the text file's contents and calculates and outputs the following in this order: • The number of words in the file • The number of lines in the file • The number of uppercase letters in the file • The number of lowercase letters in the file • The number of digits in the file • The number of letter H's in the file • The number of whitespace characters in the file NOTE: Your program should include at least one try-except error handling statement block. Your program should also validate any input that could cause your program to crash. I'm Henery The Eighth, I Am! Henery The Eighth, I Am, I am!I got married to the widow next door,She's been married seven times before.And ev'ryone was a Henery,She wouldn't have Willie or a Sam.I'm her eighth old man named Henery,Henery the Eighth, I Am!Second verse same as the first!I'm Henery The Eighth, I Am! Henery The Eighth, I Am, I am!I got married to the widow next door,She's been married seven times before.And…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning