Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements you will need for this assignment. Run the schema file in APEX following the same process we followed to run a schema during the lab (you can refer to lab 6 recording). NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES. The list of tables available for this assignment is the following: STORE (StoreID, Store Address, WeekDays Hours, WeekendHours) ACCOUNT (AccountNo., AccountName, Balance) DEPARTMENT (DepartmentID, DepartmentTitle, NoOfEmployees, AccountNo, StoreID, Franchise TeamID) FRANCHISE_APP (AppNumber, AppDate, DecisionDate, Status, DepartmentID, TeamID) EMPLOYEE (Employee ID, Name, Phone, Email, Address, Gender, DOB, JoiningDate, CentralOrLocalEmployment, EFTPOSID, CANumber, DepartmentID) CASUAL_EMPLOYEE (Employee ID, HourlyRate) PART_TIME EMPLOYEE (Employee ID, WeeklyHours, Salary) FULL_TIME_EMPLOYEE (Employee ID, LeaveDays, Salary, MemberID) TEAM MEMBER (MemberID) SHAREHOLDER (S.H.ID, Name, Phone, Email, Address, NoOfShares, MemberID) TEAM (TeamID, TeamName, TeamLeaderID) MEMBERSHIP (MemberID, TeamID, PercentageOfShare) NOTE: PK is printed underlined and FK is printed italic in italics. The tasks are listed in the next page. Using the tables provided above, provide SQL statements for the following queries. a. Show the store information along with its departments for all stores that opens the latest during weekend. b. List the franchise application details for each department of H2H along with the department id and title. Include the departments that have not received any application yet. c. Show the team information and number of members for all successful franchise applications. d. Show the details of the franchise application that took the longest time to reach a decision. e. List the team member details (including shareholder and employee details such as id, name, phone and email) for all the team members who are part of a franchise team of a successful application. For each of the members, also include the date on which their franchise application was granted. Hint: use UNION. f. List the team member details (member id and team id) who has the maximum credit to his name, based on his percentage of share in the team and the positive account balance of the franchising department (Hint: account balance can be found in the Account table). Please note, it is safe to assume that only one team member has the highest percentage of share. [a-d: 7 marks each, e- f: 11 marks each] Task 2 [35 marks] Provide the implementation of the following stored procedures and function. For submission, please include both the PL/SQL code and an execute procedure/SQL statement to demonstrate the functionality. a. Write a procedure that takes an employee id as argument and lists the details of an employee's department and reporting boss. Note that an employee's reporting boss is the person who has the highest percentage of share in the franchise team. The reporting boss can be either a full-time employee or a shareholder. If the reporting boss is a shareholder, display number of shares along with contact details and if the boss is an employee, mention DOB, gender and joining date along with the contact information. Hint: First, try to identify the member id of the boss. Then, using that member id, check whether the member is a shareholder or full-time employee. [20 marks] b. Write a stored function that takes an employee id as input and returns how long (in years) an employee has been a part of the company. For convenience, we have provided an attribute in the employee table called 'joiningDate". Use the function to write an sql query that lists down all the employees and their associated duration of employment. [15 marks] Provide the implementation of the following triggers. For submission, please include both the PL/SQL code and a DML statement (insert to demonstrate the trigger functionality. a. A trigger that prevents a full-time employee from applying for a franchise if he/she has less than 10 years of experience as an employee of H2H. Please note, there may be existing data in the database that does not follow this rule and you do not need to consider them when writing your trigger. [15 marks] Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements you will need for this assignment. Run the schema file in APEX following the same process we followed to run a schema during the lab (you can refer to lab 6 recording). NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES. The list of tables available for this assignment is the following: STORE (StoreID, Store Address, WeekDays Hours, WeekendHours) ACCOUNT (AccountNo., AccountName, Balance) DEPARTMENT (DepartmentID, DepartmentTitle, NoOfEmployees, AccountNo, StoreID, Franchise TeamID) FRANCHISE_APP (AppNumber, AppDate, DecisionDate, Status, DepartmentID, TeamID) EMPLOYEE (Employee ID, Name, Phone, Email, Address, Gender, DOB, JoiningDate, CentralOrLocalEmployment, EFTPOSID, CANumber, DepartmentID) CASUAL EMPLOYEE (EmployeeID, HourlyRate) PART TIME EMPLOYEE (EmployeeID, WeeklyHours, Salary) FULL_TIME_EMPLOYEE (Employee ID, LeaveDays, Salary, MemberID) TEAM MEMBER (MemberID) SHAREHOLDER (S.H.ID, Name, Phone, Email, Address, NoOfShares, MemberID) TEAM (TeamID, TeamName, TeamLeaderID) MEMBERSHIP (MemberID, TeamID, PercentageOfShare) NOTE: PK is printed underlined and FK is printed italic in italics. The tasks are listed in the next page. Using the tables provided above, provide SQL statements for the following queries. a. Show the store information along with its departments for all stores that opens the latest during weekend. b. List the franchise application details for each department of H2H along with the department id and title. Include the departments that have not received any application yet. c. Show the team information and number of members for all successful franchise applications. d. Show the details of the franchise application that took the longest time to reach a decision. e. List the team member details (including shareholder and employee details such as id, name, phone and email) for all the team members who are part of a franchise team of a successful application. For each of the members, also include the date on which their franchise application was granted. Hint: use UNION. f. List the team member details (member id and team id) who has the maximum credit to his name, based on his percentage of share in the team and the positive account balance of the franchising department (Hint: account balance can be found in the Account table). Please note, it is safe to assume that only one team member has the highest percentage of share. [a-d: 7 marks each, e - f: 11 marks each] Task 2 [35 marks] Provide the implementation of the following stored procedures and function. For submission, please include both the PL/SQL code and an execute procedure/SQL statement to demonstrate the functionality. a. Write a procedure that takes an employee id as argument and lists the details of an employee's department and reporting boss. Note that an employee's reporting boss is the person who has the highest percentage of share in the franchise team. The reporting boss can be either a full-time employee or a shareholder. If the reporting boss is a shareholder, display number of shares along with contact details and if the boss is an employee, mention DOB, gender and joining date along with the contact information. Hint: First, try to identify the member id of the boss. Then, using that member id, check whether the member is a shareholder or full-time employee. [20 marks] b. Write a stored function that takes an employee id as input and returns how long (in years) an employee has been a part of the company. For convenience, we have provided an attribute in the employee table called 'joiningDate". Use the function to write an sql query that lists down all the employees and their associated duration of employment. [15 marks] Provide the implementation of the following triggers. For submission, please include both the PL/SQL code and a DML statement (insert to demonstrate the trigger functionality. a. A trigger that prevents a full-time employee from applying for a franchise if he/she has less than 10 years of experience as an employee of H2H. Please note, there may be existing data in the database that does not follow this rule and you do not need to consider them when writing your trigger. [15 marks] Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements you will need for this assignment. Run the schema file in APEX following the same process we followed to run a schema during the lab (you can refer to lab 6 recording). NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES. The list of tables available for this assignment is the following: STORE (StoreID, Store Address, WeekDays Hours, WeekendHours) ACCOUNT (AccountNo., AccountName, Balance) DEPARTMENT (DepartmentID, DepartmentTitle, NoOfEmployees, AccountNo, StoreID, Franchise TeamID) FRANCHISE_APP (AppNumber, AppDate, DecisionDate, Status, DepartmentID, TeamID) EMPLOYEE (Employee ID, Name, Phone, Email, Address, Gender, DOB, JoiningDate, CentralOrLocalEmployment, EFTPOSID, CANumber, DepartmentID) CASUAL_EMPLOYEE (Employee ID, HourlyRate) PART TIME EMPLOYEE (EmployeeID, Weekly Hours, Salary) FULL TIME EMPLOYEE (EmployeeID, LeaveDays, Salary, MemberID) TEAM MEMBER (MemberID) SHAREHOLDER (S.H.ID, Name, Phone, Email, Address, NoOfShares, MemberID) TEAM (TeamID, TeamName, TeamLeaderID) MEMBERSHIP (MemberID, TeamID, PercentageOfShare) NOTE: PK is printed underlined and FK is printed italic in italics. The tasks are listed in the next page. Using the tables provided above, provide SQL statements for the following queries. a. Show the store information along with its departments for all stores that opens the latest during weekend. b. List the franchise application details for each department of H2H along with the department id and title. Include the departments that have not received any application yet. c. Show the team information and number of members for all successful franchise applications. d. Show the details of the franchise application that took the longest time to reach a decision. e. List the team member details (including shareholder and employee details such as id, name, phone and email) for all the team members who are part of a franchise team of a successful application. For each of the members, also include the date on which their franchise application was granted. Hint: use UNION. f. List the team member details (member id and team id) who has the maximum credit to his name, based on his percentage of share in the team and the positive account balance of the franchising department (Hint: account balance can be found in the Account table). Please note, it is safe to assume that only one team member has the highest percentage of share. [a-d: 7 marks each, e - f: 11 marks each] Task 2 [35 marks] Provide the implementation of the following stored procedures and function. For submission, please include both the PL/SQL code and an execute procedure/SQL statement to demonstrate the functionality. a. Write a procedure that takes an employee id as argument and lists the details of an employee's department and reporting boss. Note that an employee's reporting boss is the person who has the highest percentage of share in the franchise team. The reporting boss can be either a full-time employee or a shareholder. If the reporting boss is a shareholder, display number of shares along with contact details and if the boss is an employee, mention DOB, gender and joining date along with the contact information. Hint: First, try to identify the member id of the boss. Then, using that member id, check whether the member is a shareholder or full-time employee. [20 marks] b. Write a stored function that takes an employee id as input and returns how long (in years) an employee has been a part of the company. For convenience, we have provided an attribute in the employee table called 'joiningDate". Use the function to write an sql query that lists down all the employees and their associated duration of employment. [15 marks] Provide the implementation of the following triggers. For submission, please include both the PL/SQL code and a DML statement (insert to demonstrate the trigger functionality. a. A trigger that prevents a full-time employee from applying for a franchise if he/she has less than 10 years of experience as an employee of H2H. Please note, there may be existing data in the database that does not follow this rule and you do not need to consider them when writing your trigger. [15 marks] Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements you will need for this assignment. Run the schema file in APEX following the same process we followed to run a schema during the lab (you can refer to lab 6 recording). NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES. The list of tables available for this assignment is the following: STORE (StoreID, Store Address, WeekDays Hours, WeekendHours) ACCOUNT (AccountNo., AccountName, Balance) DEPARTMENT (DepartmentID, DepartmentTitle, NoOfEmployees, AccountNo, StoreID, Franchise TeamID) FRANCHISE_APP (AppNumber, AppDate, DecisionDate, Status, DepartmentID, TeamID) EMPLOYEE (Employee ID, Name, Phone, Email, Address, Gender, DOB, JoiningDate, CentralOrLocalEmployment, EFTPOSID, CANumber, DepartmentID) CASUAL_EMPLOYEE (Employee ID, HourlyRate) PART_TIME EMPLOYEE (Employee ID, WeeklyHours, Salary) FULL_TIME_EMPLOYEE (Employee ID, LeaveDays, Salary, MemberID) TEAM MEMBER (MemberID) SHAREHOLDER (S.H.ID, Name, Phone, Email, Address, NoOfShares, MemberID) TEAM (TeamID, TeamName, TeamLeaderID) MEMBERSHIP (MemberID, TeamID, PercentageOfShare) NOTE: PK is printed underlined and FK is printed italic in italics. The tasks are listed in the next page. Using the tables provided above, provide SQL statements for the following queries. a. Show the store information along with its departments for all stores that opens the latest during weekend. b. List the franchise application details for each department of H2H along with the department id and title. Include the departments that have not received any application yet. c. Show the team information and number of members for all successful franchise applications. d. Show the details of the franchise application that took the longest time to reach a decision. e. List the team member details (including shareholder and employee details such as id, name, phone and email) for all the team members who are part of a franchise team of a successful application. For each of the members, also include the date on which their franchise application was granted. Hint: use UNION. f. List the team member details (member id and team id) who has the maximum credit to his name, based on his percentage of share in the team and the positive account balance of the franchising department (Hint: account balance can be found in the Account table). Please note, it is safe to assume that only one team member has the highest percentage of share. [a-d: 7 marks each, e- f: 11 marks each] Task 2 [35 marks] Provide the implementation of the following stored procedures and function. For submission, please include both the PL/SQL code and an execute procedure/SQL statement to demonstrate the functionality. a. Write a procedure that takes an employee id as argument and lists the details of an employee's department and reporting boss. Note that an employee's reporting boss is the person who has the highest percentage of share in the franchise team. The reporting boss can be either a full-time employee or a shareholder. If the reporting boss is a shareholder, display number of shares along with contact details and if the boss is an employee, mention DOB, gender and joining date along with the contact information. Hint: First, try to identify the member id of the boss. Then, using that member id, check whether the member is a shareholder or full-time employee. [20 marks] b. Write a stored function that takes an employee id as input and returns how long (in years) an employee has been a part of the company. For convenience, we have provided an attribute in the employee table called 'joiningDate". Use the function to write an sql query that lists down all the employees and their associated duration of employment. [15 marks] Provide the implementation of the following triggers. For submission, please include both the PL/SQL code and a DML statement (insert to demonstrate the trigger functionality. a. A trigger that prevents a full-time employee from applying for a franchise if he/she has less than 10 years of experience as an employee of H2H. Please note, there may be existing data in the database that does not follow this rule and you do not need to consider them when writing your trigger. [15 marks] Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements you will need for this assignment. Run the schema file in APEX following the same process we followed to run a schema during the lab (you can refer to lab 6 recording). NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES. The list of tables available for this assignment is the following: STORE (StoreID, Store Address, WeekDays Hours, WeekendHours) ACCOUNT (AccountNo., AccountName, Balance) DEPARTMENT (DepartmentID, DepartmentTitle, NoOfEmployees, AccountNo, StoreID, Franchise TeamID) FRANCHISE_APP (AppNumber, AppDate, DecisionDate, Status, DepartmentID, TeamID) EMPLOYEE (Employee ID, Name, Phone, Email, Address, Gender, DOB, JoiningDate, CentralOrLocalEmployment, EFTPOSID, CANumber, DepartmentID) CASUAL EMPLOYEE (EmployeeID, HourlyRate) PART TIME EMPLOYEE (EmployeeID, WeeklyHours, Salary) FULL_TIME_EMPLOYEE (Employee ID, LeaveDays, Salary, MemberID) TEAM MEMBER (MemberID) SHAREHOLDER (S.H.ID, Name, Phone, Email, Address, NoOfShares, MemberID) TEAM (TeamID, TeamName, TeamLeaderID) MEMBERSHIP (MemberID, TeamID, PercentageOfShare) NOTE: PK is printed underlined and FK is printed italic in italics. The tasks are listed in the next page. Using the tables provided above, provide SQL statements for the following queries. a. Show the store information along with its departments for all stores that opens the latest during weekend. b. List the franchise application details for each department of H2H along with the department id and title. Include the departments that have not received any application yet. c. Show the team information and number of members for all successful franchise applications. d. Show the details of the franchise application that took the longest time to reach a decision. e. List the team member details (including shareholder and employee details such as id, name, phone and email) for all the team members who are part of a franchise team of a successful application. For each of the members, also include the date on which their franchise application was granted. Hint: use UNION. f. List the team member details (member id and team id) who has the maximum credit to his name, based on his percentage of share in the team and the positive account balance of the franchising department (Hint: account balance can be found in the Account table). Please note, it is safe to assume that only one team member has the highest percentage of share. [a-d: 7 marks each, e - f: 11 marks each] Task 2 [35 marks] Provide the implementation of the following stored procedures and function. For submission, please include both the PL/SQL code and an execute procedure/SQL statement to demonstrate the functionality. a. Write a procedure that takes an employee id as argument and lists the details of an employee's department and reporting boss. Note that an employee's reporting boss is the person who has the highest percentage of share in the franchise team. The reporting boss can be either a full-time employee or a shareholder. If the reporting boss is a shareholder, display number of shares along with contact details and if the boss is an employee, mention DOB, gender and joining date along with the contact information. Hint: First, try to identify the member id of the boss. Then, using that member id, check whether the member is a shareholder or full-time employee. [20 marks] b. Write a stored function that takes an employee id as input and returns how long (in years) an employee has been a part of the company. For convenience, we have provided an attribute in the employee table called 'joiningDate". Use the function to write an sql query that lists down all the employees and their associated duration of employment. [15 marks] Provide the implementation of the following triggers. For submission, please include both the PL/SQL code and a DML statement (insert to demonstrate the trigger functionality. a. A trigger that prevents a full-time employee from applying for a franchise if he/she has less than 10 years of experience as an employee of H2H. Please note, there may be existing data in the database that does not follow this rule and you do not need to consider them when writing your trigger. [15 marks] Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements you will need for this assignment. Run the schema file in APEX following the same process we followed to run a schema during the lab (you can refer to lab 6 recording). NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES. The list of tables available for this assignment is the following: STORE (StoreID, Store Address, WeekDays Hours, WeekendHours) ACCOUNT (AccountNo., AccountName, Balance) DEPARTMENT (DepartmentID, DepartmentTitle, NoOfEmployees, AccountNo, StoreID, Franchise TeamID) FRANCHISE_APP (AppNumber, AppDate, DecisionDate, Status, DepartmentID, TeamID) EMPLOYEE (Employee ID, Name, Phone, Email, Address, Gender, DOB, JoiningDate, CentralOrLocalEmployment, EFTPOSID, CANumber, DepartmentID) CASUAL_EMPLOYEE (Employee ID, HourlyRate) PART TIME EMPLOYEE (EmployeeID, Weekly Hours, Salary) FULL TIME EMPLOYEE (EmployeeID, LeaveDays, Salary, MemberID) TEAM MEMBER (MemberID) SHAREHOLDER (S.H.ID, Name, Phone, Email, Address, NoOfShares, MemberID) TEAM (TeamID, TeamName, TeamLeaderID) MEMBERSHIP (MemberID, TeamID, PercentageOfShare) NOTE: PK is printed underlined and FK is printed italic in italics. The tasks are listed in the next page. Using the tables provided above, provide SQL statements for the following queries. a. Show the store information along with its departments for all stores that opens the latest during weekend. b. List the franchise application details for each department of H2H along with the department id and title. Include the departments that have not received any application yet. c. Show the team information and number of members for all successful franchise applications. d. Show the details of the franchise application that took the longest time to reach a decision. e. List the team member details (including shareholder and employee details such as id, name, phone and email) for all the team members who are part of a franchise team of a successful application. For each of the members, also include the date on which their franchise application was granted. Hint: use UNION. f. List the team member details (member id and team id) who has the maximum credit to his name, based on his percentage of share in the team and the positive account balance of the franchising department (Hint: account balance can be found in the Account table). Please note, it is safe to assume that only one team member has the highest percentage of share. [a-d: 7 marks each, e - f: 11 marks each] Task 2 [35 marks] Provide the implementation of the following stored procedures and function. For submission, please include both the PL/SQL code and an execute procedure/SQL statement to demonstrate the functionality. a. Write a procedure that takes an employee id as argument and lists the details of an employee's department and reporting boss. Note that an employee's reporting boss is the person who has the highest percentage of share in the franchise team. The reporting boss can be either a full-time employee or a shareholder. If the reporting boss is a shareholder, display number of shares along with contact details and if the boss is an employee, mention DOB, gender and joining date along with the contact information. Hint: First, try to identify the member id of the boss. Then, using that member id, check whether the member is a shareholder or full-time employee. [20 marks] b. Write a stored function that takes an employee id as input and returns how long (in years) an employee has been a part of the company. For convenience, we have provided an attribute in the employee table called 'joiningDate". Use the function to write an sql query that lists down all the employees and their associated duration of employment. [15 marks] Provide the implementation of the following triggers. For submission, please include both the PL/SQL code and a DML statement (insert to demonstrate the trigger functionality. a. A trigger that prevents a full-time employee from applying for a franchise if he/she has less than 10 years of experience as an employee of H2H. Please note, there may be existing data in the database that does not follow this rule and you do not need to consider them when writing your trigger. [15 marks]
Expert Answer:
Answer rating: 100% (QA)
Solution a SELECT STORE DEPARTMENT FROM STORE INNER JOIN DEPARTMENT ON STOREStoreID DEPARTMENTStoreID ORDER BY STOREWeekendHours DESC b Include the departments that have not received any application y... View the full answer
Related Book For
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall
Posted Date:
Students also viewed these databases questions
-
Show how to create a bull spread using two call options with strike prices at $50 and $55. The premiums are $3 and $5.25. a. Which premium is for which option? b. Show the payoff diagram and the P&L...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
RiskyBusiness Inc., recently stumbled across some hard times due to the recession and on January 1, 2023, decided to approach OldMoney Bank to see what could be done. OldMoney Bank was not willing to...
-
Super Slushie charges $6.50 for a medium slushie and $9 for a large slushie. Their total net marketing contribution is $28,000 per week. They want to raise the price of each slushie 12.5% next month...
-
Fabulous Enterprises manufactures modular kitchens and bathrooms and the Managing Director. Alfred Jones, is concerned that the total number of suppliers has increased from 20 to 60 over the past...
-
What is a Gini coefficient? What would it mean if the Gini coefficient were equal to zero? What if it were equal to one?
-
\( \qquad \) refers to a company pulling revenues into the distribution channel fraudulently. a. Constructive intent b. Channel stuffing c. Gaming strategy d. Big bath e. Double play
-
Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the chapter. SNIDER CORPORATION Balance Sheet December 31, 2013 Assets Current assets:...
-
Assume the following information for Kingbird Corp. Accounts receivable (beginning balance) $135,000 Allowance for doubtful accounts (beginning balance) 11,300 Net credit sales 930,000 Collections...
-
Solve Problem 3.33 in Chapter 3 to construct an x-bar chart in conjunction with an R-chart for delivery time at the Great Outdoors Clothing Company. Data in Problem 3.33 in Chapter 3 The Great...
-
A choice has to be made between two investment proposals. Proposal A requires an immediate outlay of $70000 and a further outlay of $45000 after 3 years. Net returns are $25000 per year for 12 years....
-
Question 31 (1 point) In the area of product and service design the acronym CAD refers to: conceptually appropriate design computer aided design commercial applications design competitive advantage...
-
How do the four frames(Structural, Human Resource, Political, Symbolic) and Systems Archetypes complement each other? In other words, what do the archetypes provide that the frames do not, and...
-
Based on a survey, assume that 27% of consumers are comfortable having drones deliver their purchases. Suppose that we want to find the probability that when six consumers are randomly selected,...
-
The Lagrange Multiplier Test Consider the elementary textbook problem of testing the null hypothesis = against for a sample size n drawn from a normal distribution with known variance, which for...
-
Question 6 An analysis of the liquidity and efficiency ratios for XYZ Trading shows the following results. Ratio 2022 2021 Current ratio 2.5 2.0 Acid-test ratio 0.7 0.9 Days' sales uncollected 42...
-
Jiminy s Cricket Farm issued a 3 0 - year, 6 percent semiannual bond three years ago. The bond currently sells for 9 3 percent of its face value. The book value of the debt issue is $ 9 5 million. In...
-
Consider the circuit of Fig. 7.97. Find v0 (t) if i(0) = 2 A and v(t) = 0. 1 3 ett)
-
What is partitioning, and how is it used?
-
ArticleIndex.com is a company that produces indexes of magazine and periodical articles for a given discipline. AWeb user should be able to enter an article topic or authors and receive a detailed...
-
Explain what command-language interfaces are. To what types of users are they best suited?
-
The market interest rate is 15 percent. What is the price of a consol bond that pays \($120\) annually?
-
Assuming an interest rate of 10 percent, calculate the present value of the following streams of yearly payments: a. \($1,000\) per year forever, with the first payment one year from today. b....
-
World Transportation, Inc., is expected to initiate its quarterly dividend of \($1\) five years from today and the dividend is expected to remain constant permanently. What is the price of World...
Study smarter with the SolutionInn App