Consider the following list of requirements related to a large enterprise with several companies, for which you are required to come up with an ER model.

Create an ER model for each of the following descriptions:a)Each company operates four departments, and each department belongs to one company.b)Each department in part (a) employs one or more employees, and each employee works for one department.c)Each of the employees in part (b)may or may not have one or more dependents, and each dependentd)belongs to one employee.e)Each employee in part (c) may or may not have an employment history.f)Represent all the ER models described in (a), (b), (c), and (d) as a single ER model.

Consider the following College and perform the task that follows.Ocean Sound College, a liberal arts college located on the West Coast, provides dormitory housing for approximately half of its students. Students who choose not to live on campus, or who do not get assigned dormitory space, must find housing in the surrounding community. Currently, the housing office uses a cumbersome system of multiple binders to keep track of housing opportunities for students, faculty, and staff of the college. Housing listings are for college-owned housing, housing owned by private parties including landlords and individuals looking for roommates. The current system is difficult to maintain and keep up-to-date. The new college president approved a request to fund the development of a system to provide easier access and maintenance of listings. You are the systems analyst assigned from the college IT department to conduct the initial investigation into the feasibility of such a system. The preliminary…

Consider the following dimensions, dimension attributes, and dimension sizes for Farm Coop-Insurance: Member(member_ID, Name, Address). On average, there are two members for each policy and item covered by the policy. InsuredItem(Item_ID, Description, Coverage_Type). There is an average of ten covered items per policy. CoopOffice(Office_ID, Address, Manager_name). Each policy is registered and managed by only one office of the cooperative. Policy(Policy_ID, Type). The company has approximately one million policies at the present time. Approximately five percent of these policies experience some change each month. Period(Date_Key, Fiscal_Period). The length of the fiscal period is one month. The decision system reports are supposed to be based on five years of data. Claim(Claim_ID, Claim_Description, Claim_Type). The facts to be recorded for each combination of these dimensions are Policy_Premium, Deductible, and Monthly_Claim_Total. Design a star schema for this problem.  Using the…