Company ownership and boards: A government regulatory agency is trying to track the relationships between a large number of companies and individuals. For the purposes of this exercise, assume that the agency is interested only in the present state of these relationships, and not in how they may have changed over time. For each individual, you want to store the social security number, first name, last name, middle name/ initial, date of birth, address, city, state, zip code, e‐mail address, and phone number. Assume the agency wants to include a zip code table in the database. For each company, you want to store a tax ID number, name, mailing address, city, state, and zip code. Assume that all individual and company addresses are within the United States. The agency wants to understand the ownership relationships between the individuals and companies. The system should record the companies in which each individual owns stock, and how many shares are involved. Furthermore, some of the companies hold stock in other companies. You want to record each such situation, including the number of shares held. In addition to stock ownership, an individual may also be related to a company by membership on its board of directors. You want the system to record all such board memberships. Design a database to hold all this information. Draw an ER diagram, and write a database design outline
The post Draw an ER diagram, and write a database design outline appeared first on Best Custom Essay Writing Services | EssayBureau.com.