Business, 23.09.2020 16:01 ashleybashaam6821

MIS 150, Inc. is a medium size financial service company located in Sacramento City. MIS 150 offers selling/buying stocks and bonds to its customers. MIS 150 hires competent, careful and hardworking brokers to perform the selling/buying transactions for customers. The management likes to have instant summary business information regarding customers, brokers, stocks, and bonds. The broker likes to track his/her sales, customers, stocks and bonds for improving sales volume and offering better customer services. The customer likes to have an instant report for his/her profits and the information of every stock and bond. A. Develop an external level of three user views (one for the top management, one for the broker and one for the customer) in terms of customer information, performance of the stock and bond, broker’s sales and profit information
B. Combine the three users’ external views into the conceptual level of one logical structure with appropriate relations and corresponding attributes for the MIS 150 database.
C. Translate the conceptual level into the internal level via stating the most appropriate file organization for sequential and direct access methods and indicating attribute(s) to be indexed for quick searching and reporting of each relation. That can facilitate the information needed by the top management, broker and customer.

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 19:20

You wish to buy a cabin in 15 years. today, the cabin costs $150,000. you believe the price of the cabin will inflate at 4% annually. you want to invest a single amount of money (lump sum) today and have the money grow to equal the future purchase price of the cabin 15 years from now. if you can earn 10% annually on your investments, how much do you need to invest now, in order to be able to purchase the cabin?

Answers: 3

Answer

Business, 22.06.2019 03:50

John is a 45-year-old manager who enjoys playing basketball in his spare time with his teenage sons and their friends. at work he finds that he is better able to solve problems that come up because of his many years of experience, but while on the court, he finds he is not as good keeping track of the ball while worrying about the other players. john's experience is:

Answers: 1

Answer

Business, 22.06.2019 05:40

Grant, inc., acquired 30% of south co.’s voting stock for $200,000 on january 2, year 1, and did not elect the fair value option. the price equaled the carrying amount and the fair value of the interest purchased in south’s net assets. grant’s 30% interest in south gave grant the ability to exercise significant influence over south’s operating and financial policies. during year 1, south earned $80,000 and paid dividends of $50,000. south reported earnings of $100,000 for the 6 months ended june 30, year 2, and $200,000 for the year ended december 31, year 2. on july 1, year 2, grant sold half of its stock in south for $150,000 cash. south paid dividends of $60,000 on october 1, year 2. before income taxes, what amount should grant include in its year 1 income statement as a result of the investment?

Answers: 1

Answer

Business, 22.06.2019 15:00

Oerstman, inc. uses a standard costing system and develops its overhead rates from the current annual budget.the budget is based on an expected annual output of 120,000 units requiring 480,000 direct labor hours.(practical capacity is 500,000 hours)annual budgeted overhead costs total $772,800, of which $556,800 is fixed overhead.a total of 119,300 units, using 478,000 direct labor hours, were produced during the year.actual variable overhead costs for the year were $260,400 and actual fixed overhead costs were $555,450.required: 1. compute the fixed overhead spending variance and indicate if favorable or unfavorable.2. compute the fixed overhead volume variance and indicate if favorable or unfavorable.

Answers: 3

Answer

You know the right answer?

MIS 150, Inc. is a medium size financial service company located in Sacramento City. MIS 150 offers...

Questions