Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 8.69PAE
Program Plan Intro
Filling the table by Y for yes and N for No based on the given assumptions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Select from below ALL statements that are true.
Select one or more:
a.
Adding locking and unlocking statements (in arbitrary ways) to transactions is sufficient to assure database consistency in concurrent schedules.
b.
A conflict serializable schedule assures database consistency.
c.
The "B" in "B+-tree" stands for "Binary".
d.
The search key field/attribute of a primary index for a table does NOT have to be the primary key of the table.
e.
If an index is a sparse index, it MUST BE a primary index.
f.
It is a good idea to allow ONLY SERIAL schedules because they guarantee database consistency.
Please help me answer these three questions regarding Oracle database. All are T or F. Explanation is much appreciated as well.
Group functions do ignore NULL values
Multiple row functions works on each records one by one and they return one result per each record
Multiple row functions works on group of records all at once but they also return one result per each data set
.Consider the Bank Management System.account(account_number, branch_name, balance)branch (branch_name, branch_city, assets)customer (customer_name customer_street, customer_city)loan (loan_number, branch_name, amount)depositor((customer_name, account_number)borrower(customer_name, loan_number)Answer the following queries using relational algebra operators1.List all branch names and their assets2. List all accounts of Brooklyn branch3. List all loans with amount > 10004. List all accounts of Perryridge branch with balance < 10005. List Numbers of accounts with balances between 700 and 900
Chapter 8 Solutions
Modern Database Management
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
- In Oracle, what is a datafile? How does it differ from a file systems file?arrow_forwardwhich of the following can be determined from Turnitin's Index? a) How much plagiarism was committed b) whether or not sources are cited c) whether or not sources were cited appropriately d) none of the abovearrow_forwardAnswer the following for the business rule. "Each player may play on more than one team, and each team has more than one player" 1. What is the Cardinality? 2. How do you represent this in ER diagram? 3. How do you implement this in oracle database. Explain itarrow_forward
- The database contains the following data items and their values: A = 1000B = 1500C = 3000 Log file is empty at first (contains no entries). x, y, z, t - transaction local variables (not stored in DB). The following transaction execution schedule is given: T0 T1 T2 START TRANSACTION WRITE(2000, B) Start TRANSACTION READ (x, A) x=x+n1n2n3n4n5 WRITE (x, A) CHECKPOINT START TRANSACTION COMMIT TRANSACTION READ (y, B) y = y-n3n4n5 READ (z, C) z=z+n1n2n3n4 WRITE (z, C) WRITE (y, B) CHECKPOINT COMMIT TRANSACTION Read (t, C) SYSTEM FAIL The activity logging is performed (in the database). Log file entries are not buffered and are saved to disk when each new log file entry is inserted (Immediate Database Modification scheme is used). No fuzzy checkpointing is used. Any of Early lock release and Logical Undo Loging are not used. a) What will be the contents of…arrow_forward18. 15% of the product sold by the company is returned. The company decides to recycle them to avoid loss. Inthat scenario, which of the given is considered as a data?A. 15% of the sold product are returnedB. the company decided to recycle the productsC. the company does not want lossD. 85% of the products are qualityarrow_forwardWhich advantages does Quinlan point out in (1995) about stored procedures?arrow_forward
- Functional dependencies Patient_id --> p_name, phone,email,home_address Identification_number-->d_name, telephone_number, d_email, speciality Appointment_number-->Appointment_date, appointment_time , appointment_reason Bill_number-->bill_date, Appointment_number ,patient_ID Payment_id--> amount Normalise these tables. Make the normalization to 3NF and explain every step in the process.arrow_forwardNote: Terry’s phone is not available in the evidence. However, several files that originated from the phone exist somewhere in the evidence. Can you find them? Are they related to the case? 2009-M57-Patents The 2009-M57-Patents scenario tracks the first four weeks of the 13corporate history of the M57 Patents company. The company started operation on Friday, November 13th, 2009, and ceased operation on Saturday, December 12, 2009. As might be imagined in the business of outsourced patent searching, lots of other activities were going on at M57-Patents.arrow_forwardClosely examine the following tables and use it to answer the questions that follow: department course student_type student_category Student registration registration_type Suppose that the following are true: - all id column are primary keys in whichever table they are - the dept_id in course table is foreign key that is referencing the id column in the department table - the foreign keys stud_type_id, stud_cat_id in the student table are referencing the id columns in the student_type and student_category tables respectively. - the coursecode and stud_id columns in the registration table are foreign keys in the course and student tables respectively. 1. Design an Entity Relationship Diagram for the system above. 2. Write query that would return the names and contacts of all Local students. 3. Write a query that would return names, contact and locations of all departments that has a location text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”] 4. What would…arrow_forward
- When would it be reasonable to make the assumption that two select statements taken from the same database are consistent with one another? What type of circumstances would warrant such an assumption?arrow_forwardWhat kind of Big O notation does database execution time fall into? Sure, I'll take care of it. If I erase X, how many will be gone? For a single commercial. From a single online search?arrow_forwardConsider a schedule with 4 transactions with 1, 2, 3, and 4 operations respectively. Calculate the possible number ofa) Serial schedulesb) Non serial schedules Please answer these question in detail with full explaination. I need a proper long answer. Thanks :)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase 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 LearningSystems ArchitectureComputer ScienceISBN:9781305080195Author:Stephen D. BurdPublisher: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
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning