EBK MODERN DATABASE MANAGEMENT,
13th Edition
ISBN: 9780134792279
Author: TOPI
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 8.51PAE
Program Plan Intro
The types of indexes recommended for a given
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Consider the following database schema for student game, where each team is led by a
student of the team and each game is between two teams (Host and Guest):
Students
Student Id
Student Name
Address
Teams
Team Id
Team Name
Rank
Team Leader
Membership
Student id
Team Id
Games
Game id
Score
Date
Host Team
Guest Team
Your task is to show all the primary and foreign keys in Schema.
Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1.Given the preceding information, answer Questions a through e.a. How many database requests can you identify for an inventory update for both PRODUCT and PART?b. Using SQL, write each database request you identified in Step a.c. Write the complete transaction(s).d. Write the transaction log, using Table 10.1 as your template.e. Using the transaction log you created in Step d, trace its use in database recovery.
Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1.
Given the preceding information, answer Questions a through e.
How many database requests can you identify for an inventory update for both PRODUCT and PART?
Using SQL, write each database request you identified in Step a.
Write the complete transaction(s).
Write the transaction log, using Table 10.1 as your template.
Using the transaction log you created in Step d, trace its use in database recovery.
Chapter 8 Solutions
EBK 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
- QUESTION 14 Consider the database schema below for cities in countries. A country have many cities, and the same city name can be found in different countries. Country (ID: integer, Name: String (unique), SN: serialNumber (int)(unique)) City (serialNo: integer (unique, not null), CountryID: Integer, CityName: String, Population: integer) The same country (ID , name) can be added twice in Country relation with different SN? No, violates entity Integrity constraint No, violates referential integrity constraint. No, violates key constraint. Yes. No, violates domain constraints.arrow_forwardLet the database has two relations P(a, b) and Q(m, a, n) in which a is the primary key of the relation P and m is the primary key of the relation Q. Instance of P has 70 Tuples and Instance of Q has 42. What is the maximum number of rows in the new instance produced by P Q? ( is natural join)arrow_forwardMotor Vehicle Dealership Database: Consider Aaron's dealership, a multi-brand vehicle dealership whose database consists of four relations as described below. Using this database, answer questions Vehicle(make, model, manfYear, color, vinNum, type, purchaseld) Stock(stockNum, unitPrice, deliveryDate, vehiclesRemaining) Manufacturer(name, manfCode, plantLocation) Purchase(purchaseld, mCode, numVehicles, orderDate, deliveryStatus) • A vehicle can be one of the following types: Car, Truck, SUV • vinNum →Vehicle Identification Number • manfCode/mCode → a 4 character alphanumeric code for the manufacturer • manfYear → year of vehicle manufacture • purchaseld and stockNum refer to the same item • The delivery status is true if the order has been delivered to the dealership and false otherwise • Manufacturer name may not contain the same data as the make of the Vehicle. For example, • name of the manufacturer: Ford Motor Company • make of the vehicle: Ford Q1. Using SQL, list the names of all…arrow_forward
- Given the following relation R and its functional dependencies: R(workerNumber, repairNumber, workerName, machineNumber, spentTime, repairDate, machineName, workshopNumber, workshopName ) workerNumber à workerName repairNumber à repairDate, machineNumber machineNumber à machineName, workshopNumber workshopNumber à workshopName Explain the types of all the dependencies in the relation R. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.arrow_forwardplease quickly thanks !arrow_forwardQUESTION 3 Consider the following database schema for a library. Book (BooklD:int, BookTitle:string(unique), Author:string, publisher:string) Borrowing-Record (BooklD: int, CustomerCPR: int, Date: date, Time: time, Price: double) Customer (CPR:int, name: String) BookID in Borrowing-Record is considered as a foreign key? True Falsearrow_forward
- Create a database schema for a dental clinic. The dental clinic has five relations, Patients, Doctors, staff, Appointments, Payments. You are free to choose the attributes for each relation, and you are required to show the Primary keys.arrow_forwardVehicle Dealership Database: Consider Reggie's dealership, a multi-brand vehicle dealership whose database consists of four relations as described below. Vehicle(make, model, manlkear, color, vinNum, type, purshassld) Stock(stockNum, uniterice deliverxlate. vehicleskemainina) Manufacturer(name, manilede elantlocation) Purchase(purchaseld. mGede. numKehicles, erderDate. delixerxStatus) A vehicle can be one of the following types: Car, Truck, SUV vinNum - Vehicle Identification Number is made up of 17 characters (alphanumeric) mantXear → year of vehicle manufacture mantCede/ mCede- a 4.character alphanumeric code for the manufacturer • RUurshaseld, and steckNum refer to the same item • Each individual order consists of the same type of vehicle. For example, • Order#1 - 35 cars Order#2 - 50 SUV's Order#3 - 20 trucks The delivery status is true if the order has been delivered to the dealership and false otherwise.arrow_forwardQUESTION 3 Consider the following database schema for a library. Book (BookID:int, BookTitle:stringtunique), Author:string, publisher:string) Borrowing-Record (BookID: int, CustomerCPR: int, Date: date, Time: time, Price: double) Customer (CPR:int, name: String) CPR in Customer is considered as a foreign key? True Falsearrow_forward
- Draw ERD for the following situation: Kopolo Airline wants a database to keep track with its flight ticket payment. Multiple passengers (identified by first name, last name, and address) can reserve multiple flights with Kopolo Airline. Each flight is identified by its flight number, departure city, departure time, arrival city, and arrival time. When a passenger book for a flight, the database records the amount due, booking date, seat info and ticket type. When a passenger pays for his/her booking, the database records the payment amount, payment date, and info of passenger who pay for the ticket. Database Management Course Subject: MySQLarrow_forwardThe InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. Create a new table to store car maintenance types.arrow_forwardThe InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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