Question: MIS 1 5 0 , Inc. is a medium size financial service company located in Sacramento City. MIS 1 5 0 offers selling / buying

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.
1. 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, brokers sales
and profit information.
2. Combine the three users external views into the conceptual level of one
logical structure with appropriate interrelated relations, and corresponding
attributes for the MIS 150 database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!