What are the two common methods by which users interact with data in a database? Which one is more convenient to users if they do not have an understanding of query language? Why?
> Carolina Company included the following items in its financial statements for 2018, the current year (amounts in millions): Requirements: 1. Use DuPont Analysis to calculate Carolina’s return on assets and return on common equity duri
> Financial Services is considering two plans for raising $800,000 to expand operations. Plan A is to borrow at 10%, and plan B is to issue 200,000 shares of common stock at $4.00 per share. Before any new financing, United has net income of $500,000 and
> Data from the financial statements of Eclectic Candle Company included the following: The company had no preferred stock. Requirements: 1. Calculate the following ratios: a. Net profit margin b. Asset turnover ratio c. Leverage ratio d. Return on asse
> Identify the effects—both the direction and the dollar amount—of these transactions on the total stockholders’ equity of Niles Corporation. Each transaction is independent. a. Declaration of cash dividends of $85 million. b. Payment of the cash dividend
> Dean Sales Company completed the following note payable transactions: Requirements: 1. How much interest expense must be accrued at December 31, 2018? (Round your answer to the nearest whole dollar.) 2. Determine the amount of Dean Salesâ€&#
> The stockholders’ equity section of the balance sheet for Warren Corporation on August 16, 2019, follows: On August 16, 2019, the market price of Warren common stock was $20 per share. Warren declared and distributed a 10% stock divi
> Ontario Manufacturing, Inc., reported the following at December 31, 2018, and December 31, 2019: Ontario Manufacturing has paid all preferred dividends only through 2015. Requirement: 1. Calculate the total amounts of dividends to both preferred and co
> Omega Products Company reported the following stockholders’ equity on its balance sheet: Requirements: 1. What caused Omega’s preferred stock to decrease during 2019? Cite all possible causes. 2. What caused the compa
> Use the Atlantic Corporation data in E10-29A to prepare the stockholders’ equity section of the company’s balance sheet at December 31, 2019. Data from E10-29:
> At December 31, 2018, Atlantic Corporation reported the stockholders’ equity accounts shown here (with dollar amounts in millions, except per-share amounts). Atlantic’s 2019 transactions included a. Net income, $440 m
> Wishtown Marketing Corporation reported the following stockholders’ equity at December 31 (adapted and in millions): During the next year, Wishtown purchased treasury stock at a cost of $28 million and resold treasury stock for $14 m
> Bretton Software had the following selected account balances at December 31, 2018 (all numbers and amounts are in thousands, except par value per share): Requirements: 1. Prepare the stockholders’ equity section of Brettonâ€
> The financial statements of Mountainview Employment Services, Inc., reported the following accounts (adapted, with dollar amounts in thousands except for par value): Net income has already been closed to Retained Earnings. Prepare the stockholdersâ
> Excursion Publishing was recently organized as a corporation. The company issued common stock to an attorney who provided legal services worth $24,000 to help with the incorporation. Excursion also issued common stock to an inventor in exchange for her p
> Pickering Stores is authorized to issue 11,000 shares of common stock. During a two-month period, Pickering completed these stock transactions: Requirements: 1. Journalize the transactions. 2. Prepare the stockholders’ equity section
> On August 1, 2019, The Shoppes at Mill Lake, Inc., purchased inventory costing $40,000 by signing a 6%, six-month, short-term note payable. The company will pay the entire note (principal and interest) on the note’s maturity date. Requirements: 1. Journ
> Complete each of the following statements with one of the terms listed here. a. The right to maintain one’s proportionate ownership in the corporation is the right of . b. The right to receive a proportionate share of any assets remain
> Holloway Corporation issued 8%, 10-year bonds with a face value of $2,000,000 at a price of 96 on July 1, 2018. The bonds pay interest each January 1 and July 1. Holloway uses the straight-line amortization method for all bond premiums and discounts. T
> Green Earth Homes, Inc., builds environmentally sensitive structures. The company’s 2018 revenues totaled $2,770 million. At December 31, 2018 and 2017, the company had, respectively, $663 million and $613 million in current assets. The
> Companies that operate in different industries may have very different financial ratio values. These differences may grow even wider when we compare companies located in different countries. Compare three fictitious companies (Biltmore, Mackey, and Vic
> Coldwell Transportation LO 4owns a fleet of 60 semi-trucks. The original cost of the fleet was $9,000,000. Coldwell uses straight-line depreciation for the fleet for accounting purposes, and MACRS depreciation for tax purposes. The company had a deferred
> On January 1, 2017, Ditchey Corporation issued five-year, 6% bonds payable with a face value of $3,500,000. The bonds were issued at 96 and pay interest on January 1 and July 1. Ditchey amortizes bond discounts using the straight-line method. On December
> On June 30, 2018, the market interest rate is 9%. Randall Corporation issues $600,000 of 10%, 15-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. Requirements:
> Energy Ltd. is authorized to issue $3,000,000 of 1%, 10-year bonds payable. On December 31, 2018, when the market interest rate is 8%, the company issues $2,400,000 of the bonds. Energy amortizes bond discount using the effective-interest method. The sem
> Town Bank has $100,000 of 4% debenture bonds outstanding. The bonds were issued at 106 in 2018 and mature in 2038. The bonds have annual interest payments. Requirements: 1. How much cash did Town Bank receive when it issued these bonds? 2. How much cas
> On January 31, 2018, Pristar Logistics, Inc., issued 10-year, 5% bonds payable with a face value of $5,000,000. The bonds were issued at 95 and pay interest on January 31 and July 31. Pristar Logistics amortizes bond discounts using the straight-line met
> Wicker Sales, Inc.’s, comparative income statements and balance sheets show the following selected information for 2017 and 2018: Requirements: 1. Calculate the company’s accounts payable turnover and daysâ€
> Robson Corporation issued 5%, 10-year bonds with a face value of $1,000,000 at a price of 98 on July 1, 2018. The bonds pay interest each January 1 and July 1. Robson uses the straight-line amortization method for all bond premiums and discounts. The com
> EnviroFriend Structures, Inc., builds environmentally sensitive structures. The company’s 2018 revenues totaled $2,780 million. At December 31, 2018, and 2017, the company had, respectively, $656 million and $591 million in current asse
> Companies that operate in different industries may have very different financial ratio values. These differences may grow even wider when we compare companies located in different countries.Compare three fictitious companies (Albertson, Millstone, and Ra
> Fresno Transportation owns a fleet of 50 semi-trucks. The original cost of the fleet was $7,500,000. Fresno uses straight-line depreciation for the fleet for accounting purposes, and MACRS depreciation for tax purposes. The company had a deferred tax lia
> On January 1, 2017, Kittle Corporation issued five-year, 4% bonds payable with a face value of $2,500,000. The bonds were issued at 95 and pay interest on January 1 and July 1. Kittle amortizes bond discounts using the straight-line method. On December
> On June 30, 2018, the market interest rate is 9%. Ramsey Corporation issues $550,000 of 12%, 20-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. Requirements:
> Winter Ltd. is authorized to issue $2,500,000 of 4%, 10-year bonds payable. On December 31, 2018, when the market interest rate is 5%, the company issues $2,000,000 of the bonds. Winter amortizes bond discount using the effective-interest method. The sem
> Perry Bank has $450,000 of 9% debenture bonds outstanding. The bonds were issued at 105 in 2018 and mature in 2038. The bonds have annual interest payments. Requirements: 1. How much cash did Perry Bank receive when it issued these bonds? 2. How much ca
> On January 31, 2018, Dunkin Logistics, Inc., issued five-year, 3% bonds payable with a face value of $8,000,000. The bonds were issued at 93 and pay interest on January 31 and July 31. Dunkin Logistics amortizes bond discounts using the straight-line met
> Diamond Security Systems’ revenues for 2018 totaled $27.5 million. As with most companies, Diamond is a defendant in lawsuits related to its products. Note 14 of the Diamond annual report for 2018 reported the following: Requirements:
> Which option is better: receive $160,000 now or $50,000, $25,000, $55,000, $30,000, and $40,000, respectively, over the next five years? The cash flows are at the end of each year except for $160,000. Requirements: 1. Assuming a 6% interest rate, which
> Newcomb Corporation holds a portfolio of equity securities. On September 15, Newcomb paid $83,000 for an investment in Sarelli Company stock, representing 5% of Sarelli Company stock. Newcomb plans on holding the securities a few months. On October 31, t
> Figure 4-34 shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. Your assignment is to: a. Develop a relational schema. b. Show the functional dependencies. c. Develop a set of 3NF rela
> In Chapter 4, you created the logical data model for the database that will support the functionality needed by FAME. You will use this information to implement the database in the DBMS of your choice. Reread the case descriptions in Chapters 1 through 3
> Figure shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants. Each charge is identified by the date and time of the charge
> Figure 4-32 shows a class list for Millennium College. Convert this user view to a set of 3NF relations using an enterprise key. Assume the following: • An instructor has a unique location. • A student has a unique maj
> Arrange an interview with a database administrator in your area. Focus the interview on understanding the environment within which SQL is used in the organization. Inquire about the version of SQL that is used and determine whether the same version is us
> Locate three database administrator vacancies advertised online and assess the requirements for the position. What is the key knowledge and skill employers require of a database administrator? If you were interested in a career in administration, how wou
> The text lists a number of cloud service providers that offer traditional data management services like MS SQL database, Amazon RDS, and cloud services for information systems such as analytics and DM warehouse services. Choose any two cloud service prov
> In Chapter 4, you created the relational schema for the FAME system, and in Chapter 5 you implemented that schema with a relational database management system without giving full consideration to the details of physical database design. In Chapters 5 and
> In Chapter 4, you created the relational schema for the FAME system, and in Chapter 5 you implemented that schema with a relational database management system without giving full consideration to the details of physical database design. In Chapters 5 and
> In Chapter 5, you implemented the database for FAME and populated it with sample data. You will use the same database to complete the exercises below. Create a strategy for reviewing your database implementation with the appropriate stakeholders. Which s
> In Chapter 4, you created the relational schema for the FAME system, and in Chapter 5 you implemented that schema with a relational database management system without giving full consideration to the details of physical database design. In Chapters 5 and
> In Chapter 4, you created the relational schema for the FAME system, and in Chapter 5 you implemented that schema with a relational database management system without giving full consideration to the details of physical database design. In Chapters 5 and
> Compare two versions of SQL to which you have access, such as Microsoft Access and Oracle. Identify at least five similarities and three dissimilarities in the SQL code from these two SQL systems. Do the dissimilarities cause results to differ?
> Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: An international school of technology has hired you to create a database
> Contact the DBA of an organization you are familiar with. Interview them to understand how they collect, manage, and utilize metadata. Do they store it using a data repository? If they do use a data repository, do they allow users to create their own pas
> Draw an EER diagram for the following problem: MoneyBags Bank customers can access over 10,000 ATMs worldwide. These are a combination of the Bank’s own machines and those provided through the Visa network. Customers using the Bank’s own machines can che
> Draw an EER diagram for the following problem: A company posts job openings online. Job seekers must apply for these jobs online as well. The company will process the applications and call eligible job seekers for an interview. Upon successful completion
> Visit an organization that has implemented a database approach. Evaluate each of the following: a. The organizational placement of data administration, database administration, and data warehouse administration. b. The assignment of responsibilities for
> Visit the database designer or administrator of an organization that has heavy transaction oriented applications and requires frequent updates to records in the database as well. Examples include any organization dealing with customers, point-of-sale sys
> Denormalization can be a controversial topic among database designers. Some believe that any database should be fully normalized (even using all the normal forms discussed in Appendix B, available on the book’s Web site). Others look for ways to denormal
> Using a table, differentiate between how data is represented in a file processing environment and how it is represented in a relational database.
> Using the Web and Internet resources, search for the application areas of parallel processing. Which DBMS in the market supports this feature?
> Visit an organization that has implemented a database management system and interview concerned individuals about the standards and regulations used by the organization for financial reporting and ensuring the security of the IT Infrastructure. How does
> Look for a receipt from a supermarket or other retail store you have purchased from. Based on the receipt, draw an EER diagram of the data in this form or report. Transform the diagram into a set of 3NF relations.
> Using the online Appendix B, available on the book’s Web site, as a resource, interview a database analyst/designer to determine whether he or she normalizes relations to higher than 3NF. Why or why not does he or she use normal forms beyond 3NF?
> Obtain an EER diagram from a database administrator or system designer. Based on what you have learned in this book, convert this into a relational schema in 3NF. Now interview the administrator on how they convert the diagram into relations. How do they
> Interview system designers and database designers at several organizations. Ask them to describe the process they use for logical design. How do they transform their conceptual data models (e.g., E-R diagrams) to relational schema? What is the role of CA
> For the same E-R diagram used in Field Exercise 2-56 or for a different database in the same or a different organization, identify any uses of time stamping or other means to model time dependent data. Why are time-dependent data necessary for those who
> Ask a database or systems analyst in a local company to show you an E-R diagram for one of the organization’s primary databases. Ask questions to be sure you understand what each entity, attribute, and relationship means. Does this organization use the s
> Ask a database or systems analyst to give you examples of unary, binary, and ternary relationships that the analyst has dealt with personally at his or her company. Ask which is most common and why. Ask them if they ever model weak or dependent entities
> Interview a database analyst or a systems analyst. How do they extract business rules for ER modeling? Ask for specific sources. Are they all listed in the text? Did they purchase an ER model and customize it or design it on their own? How did they decid
> List the nine major components in a database system environment.
> Interview a database analyst and ask how they go about identifying business rules in the data modeling process. How do they decide to document what business rules they will gather, utilize, manage, and consider while developing an E-R model? How do they
> What changes can be made in data administration at each stage of the traditional database development life cycle to deliver high-quality, robust systems more quickly?
> Briefly describe four database administration trends that are emerging today.
> What factors must be considered when deciding on an open-source DBMS?
> What functions require the input and involvement of both the data administrator and the database administrator?
> Why are data administrators required to maintain an information repository?
> Indicate whether data administration or database administration is typically responsible for each of the following functions: a. Managing the data repository b. Installing and upgrading the DBMS c. Conceptual data modeling d. Managing data security and p
> Many organizations are now offering cloud-based data warehousing services such as IBM’s dashDB, Amazon’s Redshift, and Microsoft Azure. Pick any three such firms and, using the Internet, compare them based on the factors listed. Prepare a report based on
> Contrast the following terms: a. chief data officer; DBA b. data administration; database administration c. open source DBMS; commercial DBMS d. ETL; MDM
> What distinguishes MDM from other forms of data integration?
> Describe the three major approaches to MDM.
> State any four data availability problems and how they can potentially be addressed.
> Explain how TQM techniques can help in improving data quality.
> Match the following terms and definitions: - data administration database - master data management - data steward - open source DBMS a. oversees data quality for a particular data subject b. a database management system available for free (typically incl
> What are some of the advanced techniques that can be applied by a software solution for data quality improvement?
> Explain how an organization’s business rules can be checked as part of a data audit.
> Describe the key steps to improve data quality in an organization.
> Explain four reasons why the quality of data is poor in many organizations.
> Visit an organization that has implemented information systems on a data warehouse, and interview managers to discuss following issues: a. Does increased data collection lead to any information gaps for managers? b. Do they receive information from diver
> Define the eight characteristics of quality data.
> What are the four basic facilities for the backup and recovery of a database?
> What are four reasons why data quality is important to an organization?
> How can fuzzy logic, pattern matching, and expert systems be used to improve data quality?
> How can the data capture process be improved?
> Briefly describe four threats to high data availability and at least one measure that can be taken to counter each of these threats.
> Define each of the following terms: a. database administration b. data administration c. chief data officer d. master data management e. open source DBMS
> Compare and contrast R and Python as computational environments for analytics.
> Briefly describe three types of operations that can easily be performed with OLAP tools.
> Discuss the role of OLAP in the context of descriptive analytics.
