Consider the bank database of Figure 5.21. Write an SQL trigger to carry outthe following action: On delete of an account, for each customer-owner of theaccount, check if the owner has any remaining accounts, and if she does not,delete her from the depositor relation branch (branch_name, branch_city, assets)customer (customer_name, customer_street, cust omer_city)loan (loan_number, branch_naте, атоиnt)borrower (сustoтer name, loan питber)ассоunt (аccouиnt_лumber, branchлaтe, balance )depositor (custoтer-лame, accounnumber)Figure 5.21 Banking database for Exercise 5.6.

branch (branch_name, branch_city, assets) customer (customer_name, customer_street, cust omer_city) loan (loan_number, branch_naте, атоиnt) borrower (сustoтer name, loan питber) ассоunt (аccouиnt_лumber, branchлaтe, balance ) depositor (custoтer-лame, accounnumber) Figure 5.21 Banking database for Exercise 5.6.

branch (branch_name, branch_city, assets) customer (customer_name, customer_street, cust omer_city) loan (loan_number, branch_naте, атоиnt) borrower (сustoтer name, loan питber) ассоunt (аccouиnt_лumber, branchлaтe, balance ) depositor (custoтer-лame, accounnumber) Figure 5.21 Banking database for Exercise 5.6.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 3RA

See similar textbooks

Similar questions

(Transaction Management) Each branch of the Jaja restaurant has a mainstay menu that is very popular with customers, so information on the availability of the number of servings is needed to be able to serve orders. Here are two transactions that are ordering a food menu at the same time. T1: Start the transaction at time t1, read 10 servings of food stock at t2. Because ordering one portion, the stock is reduced by 1 at t3. On t6, update the stock count, and commit to t7. T2: Transaction T2 starts a transaction on t2, reads the number of stocks in t3 as many as 10. At t4 orders 3 portions. On t5 it updates the stock to 7 and then on t6 commits it. As a result of the T1 and T2 transactions above, there was an error in the amount of food stocks. Make a solution with 2PL. What kinds of problems happened? Give a reason why choosing this type of problem! How much food is still available?
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g. the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission percentage on profit are stored in the system. For example, John is a…
Question Setup: Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: USER_ID USER_FIRST_NAME USER_LAST_NAME USER_EMAIL USERS Table In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: DRIVER_ID DRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING LICENSE_ID DRIVER_START_DATE DRIVER_DRIVING_LICENSE_CHECKED DRIVER_RATING DRIVERS Table In the CARS table, all the cars in the InstantRide…
In Senior Project Website, the user requests the website to search for previous senior projects, the website displays the search web form, the user inputs the keywords to be used for the search process, the user submits the search criteria to the website, and the website requests a remote database to search for senior projects that fulfill the requested criteria (keywords). The remote database returns back a Boolean value (indicating if the search is successful or not) and a list of found senior projects (the list is empty if not successful), If the search is successful, the website displays the list of received senior projects, else, the website displays error dialog box indicating that no projects were found. Q2. For Senior Project Website System described above, students are required to conduct the following task: a) Design the Sequence Diagram of Senior Project Website System described above.
Explain how many fields questions should be asked on a single request for information form ?
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
On the Sales Data worksheet, calculate the total earnings for each sales associate. In cell G2, calculate the total earnings using a SUM function to total the values in cells E2 and F2. Copy the formula to cells G3:G9.
A company that provides a movie-streaming subscription service uses a relational database to store information on movies to answer customer questions. Each entry in the database contains the following items: Movie ID (the primary key), movie title, year made, movie type, MPAA rating, starring actor #1, starring actor #2, starring actor #3, and director. Movie types are action, comedy, family, drama, horror, science fiction, and western. MPAA ratings are G, PG, PG-13, R, NC-17, and NR (not rated). Using a graphics program, develop an entity-relationship diagram for a database application for this database.
Patient is registered in hospital through centralized registration counter. User will enter all relevant information (i.e name, phone no, address, age, no etc.) into the relevant form. If user enters invalid information, then system will show error messages. On successful registration unique medical record number will be issued to user and registration card can also be printed. On confirmation of registration patient will submit registration fee on cash counter. Against registered primary patient their family tree should be maintained in the system. Against each registered primary patient his/her family member details will also be saved in the system. Patients can be searched in order to update their information, block/unblock patient or add family member(s), view family member against them in the system. There should be provision in application to edit patient and patient’ family member details. Registration of the patient can also be blocked. Blocking the Registration of a Primary…
Patient is registered in hospital through centralized registration counter. User will enter all relevant information (i.e name, phone no, address, age, no etc.) into the relevant form. If user enters invalid information, then system will show error messages. On successful registration unique medical record number will be issued to user and registration card can also be printed. On confirmation of registration patient will submit registration fee on cash counter. Against registered primary patient their family tree should be maintained in the system. Against each registered primary patient his/her family member details will also be saved in the system. Patients can be searched in order to update their information, block/unblock patient or add family member(s), view family member against them in the system. There should be provision in application to edit patient and patient’ family member details. Registration of the patient can also be blocked. Blocking the Registration of a Primary…