Pearson eText for Modern Database Management -- Instant Access (Pearson+)
13th Edition
ISBN: 9780137305940
Author: Jeffrey Hoffer, Ramesh Venkataraman
Publisher: PEARSON+
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 8.47PAE
Program Plan Intro
a. Value that will be stored using NUMBER(11) data type for input number 3,456,349.2334 in Oracle
Program Plan Intro
b. Value that will be stored using NUMBER(11, 1) data type for input number 3,456,349.2334 in Oracle database.
Program Plan Intro
c. Value that will be stored using NUMBER(11, -2) data type for input number 3,456,349.2334 in Oracle database.
Program Plan Intro
d. Value that will be stored using NUMBER(11, 6) data type for input number 3,456,349.2334 in Oracle database.
Program Plan Intro
e. Value that will be stored using NUMBER(6) data type for input number 3,456,349.2334 in Oracle database.
Program Plan Intro
f. Value that will be stored using NUMBER data type for input number 3,456,349.2334 in Oracle database.
Explanation of Solution
Explanation:
a.3456348
b.3456349.2
c.3456300
d.Not accepted, Exceeds precision
e.Not accepted, Exceeds precision
f...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Considered the tables structures that you need in this question are the same of DBS311 database :
Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named "Invalid credit". Display the result of the average as integer.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
BI U S
Paragraph
A v
In
x X2
Arial
10pt
...
All the following are true with respect to surrogate keys EXCEPT one. Which of the following is NOT true of surrogate keys? In other words, which statement below is false?
Group of answer choices
surrogate keys are usually generated by the DBMS.
surrogate keys are meaningful to the users.
surrogate keys are unique.
surrogate keys are usually numeric.
Computer Sciences Department frequent fliers have been complaining to Dane County Airport officials about the poor organization at the airport. As a result, the officials decided that all information related to the airport should be organized using a DBMS, and you have been hired to design the database. Your first task is to organize the information about all the airplanes stationed and maintained at the airport. The relevant information is as follows:• Every airplane has a registration number, and each airplane is of a specific model.• The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-lO) and has a capacity and a weight.• A number of technicians work at the airport. You need to store the name, SSN, address, phone number, and salary of each technician.• Each technician is an expert on one or more plane model(s), and his or her expertise may overlap with that of other technicians. This information about technicians must also…
Chapter 8 Solutions
Pearson eText for Modern Database Management -- Instant Access (Pearson+)
Ch. 8 - Prob. 8.1RQCh. 8 - Prob. 8.2RQCh. 8 - Prob. 8.3RQCh. 8 - Prob. 8.4RQCh. 8 - Prob. 8.5RQCh. 8 - Prob. 8.6RQCh. 8 - Prob. 8.7RQCh. 8 - Prob. 8.8RQCh. 8 - Explain why you sometimes have to reserve much...Ch. 8 - Why are field values sometimes coded?
Ch. 8 - Prob. 8.11RQCh. 8 - Prob. 8.12RQCh. 8 - Explain why normalized relations may not comprise...Ch. 8 - Prob. 8.14RQCh. 8 - List three common situations that suggest that...Ch. 8 - Explain the reasons why some experts are against...Ch. 8 - Prob. 8.17RQCh. 8 - Prob. 8.18RQCh. 8 - Prob. 8.19RQCh. 8 - Prob. 8.20RQCh. 8 - Prob. 8.21RQCh. 8 - Prob. 8.22RQCh. 8 - One of the strongest recommendations regarding...Ch. 8 - Explain why an index is useful only if there is...Ch. 8 - Indexing can clearly be very beneficial. Why...Ch. 8 - Prob. 8.26RQCh. 8 - Prob. 8.27RQCh. 8 - Describe the role of data dictionary in the...Ch. 8 - Prob. 8.29RQCh. 8 - Prob. 8.30RQCh. 8 - Explain how creating a view may increase data...Ch. 8 - Prob. 8.32RQCh. 8 - Prob. 8.33RQCh. 8 - Prob. 8.34RQCh. 8 - Prob. 8.35RQCh. 8 - Prob. 8.36RQCh. 8 - Prob. 8.37RQCh. 8 - Prob. 8.38RQCh. 8 - Prob. 8.39RQCh. 8 - How can views be used as part of data security?...Ch. 8 - Prob. 8.41RQCh. 8 - Prob. 8.42RQCh. 8 - Consider the following two relations for...Ch. 8 - Prob. 8.44PAECh. 8 - Prob. 8.45PAECh. 8 - Prob. 8.46PAECh. 8 - Prob. 8.47PAECh. 8 - Suppose you are designing a default value for the...Ch. 8 - When a student has not chosen a major at a...Ch. 8 - Prob. 8.50PAECh. 8 - Prob. 8.51PAECh. 8 - Consider the relations in Problem and Exercise...Ch. 8 - Prob. 8.53PAECh. 8 - Prob. 8.54PAECh. 8 - Prob. 8.55PAECh. 8 - Prob. 8.56PAECh. 8 - Prob. 8.57PAECh. 8 - Consider the relations specified in Problem and...Ch. 8 - Prob. 8.59PAECh. 8 - Prob. 8.60PAECh. 8 - Prob. 8.61PAECh. 8 - Prob. 8.62PAECh. 8 - Prob. 8.63PAECh. 8 - Prob. 8.64PAECh. 8 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 8 - Prob. 8.66PAECh. 8 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 8 - Refer to Figure 4-5 0. For each of the following...Ch. 8 - Prob. 8.69PAECh. 8 - Prob. 8.70PAECh. 8 - Prob. 8.71PAECh. 8 - Prob. 8.72PAECh. 8 - Prob. 8.73PAECh. 8 - Prob. 8.74PAECh. 8 - Prob. 8.75PAECh. 8 - Prob. 8.76PAECh. 8 - Prob. 8.77PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Does the DBMS or the user make the choice of which index to use to accomplish a given task?arrow_forwardIn Oracle, what is a datafile? How does it differ from a file systems file?arrow_forwardWhat problems might arise if your database does not have proper referential integrity? What kind of errors may there be?arrow_forward
- In Oracle, if you have two tables related by connecting a primary key in table B and a foreign key in table A, how does the database behave during the insertion of a new record into table A? Question 45 options: 1) It creates a new primary key attribute that is automatically numbered as a sequence of numeric values. 2) It prevents foreign key values from being duplicated in table A. 3) It prevents any records from being deleted from either Table A or Table B. 4) It prevents a row from being inserted into table A if the data in the foreign key column of table A doesn't match any of the values in the primary key column of the table B.arrow_forwardBriefly explain what is meant by referential integrity and how it is enforced bythe DBMSarrow_forwardWhat happens if someone tries to break a database's referential integrity? What types of errors are possible?arrow_forward
- What happens if your database does not enforce referential integrity? When it comes to making errors, what kind are most likely to occur?arrow_forwardSQL Database question is below. if you are solve ı'm very appreciate that.arrow_forwardWhy is the foreign key important for the integrity of a database? Can you come up with a scenario to show why it is necessary?arrow_forward
- Using the relations that I attached, defined and normalized, create the SQL DDL statements necessary to implement database schema as an OpenOffice database. You may also implement your database in MySQL, IBM DB2 Express, Microsoft Access, SQL Server if you have access to these database systems. The answer should include a document that contains all of the SQL statements that you created and a screenshot that shows the structures that you implemented in the database of your choice. Your DDL statements must accommodate the following elements: Create statements to create tables from the entities defined as part of the attachment. Appropriate use of Null (and Not Null) parameters to ensure data validity Appropriate use of constraint clauses to implement appropriate referential integrity Use of data types and formats that is appropriate for the data in your database schema. Appropriate use of keys including automatic generation of key values if appropriate Shoulkd include: * the…arrow_forwardThe following tables form part of a database held in a relational DBMS (Primary Key, Foreign Key): Employee (empNo, empName, empAddress, empGender, empPosition, deptNo) Department (deptNo, deptName, ManagerEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) …where: Employee contains employee details Department contains department details. ManagerEmpNo identifies the employee who is the Manager of the department. There is only one Manager for each department. Project contains details of the projects in each department. No two departments can run the same project. WorksOn contains details of the hours worked by each employee on each project. Give SQL for the following queries List all details of all female employees List the Names and Addresses of all employees who work in the department named “Human Resources”. List the Names of all employees who worked on the project named Manhattan List the total number of hours…arrow_forwardUsing a specific example (different from what the textbook discusses), explain the use of binary and shared/exclusive locks in a DBMS (in your own words).arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning