Draw an ERD for the following case. State any business rules you identify. Be sure to include the entities, attributes, primary keys (identifiers), foreign keys, and relationships (including cardinality and a description of the relationships). Also, do not leave any many-to-many relationships in your data model. The FSU College of Business is organized by department (Marketing, Management, Finance, etc…). Departments are named, and have a department code assigned by the university. Each faculty member is assigned to a single department. The system tracks the faculty FSU ID number, name, and whether or not they have a Ph. D. Many departments offer more than one major; for example the management department offers a general management degree, human resources, and MIS to name a few. Each major, however is offered by only one department. The department keeps track of the major name, major code, and number of students in the major. A major can exist though even if no students are currently majoring in it. Students can have more than one major, but must have at least one. The system tracks the FSU student ID, student name, and GPA.

The county collector of suncoast county is responsible for collecting all property taxes levied by funds and governments within the boundaries of the county. to reimburse the county for estimated administrative expenses of operating the tax agency fund, the agency fund deducts 1.5 percent from the collections for the town, the school district, and the other towns. the total amount deducted is added to the collections for the county and remitted to the suncoast county general fund. the following events occurred in 2017: 1. current-year tax levies to be collected by the agency were: county general fund $ 10,333,000 town of bayshore general fund 4,840,000 suncoast county consolidated school district 6,550,000 other towns 3,120,000 total $ 24,843,000 2. $13,700,000 of current taxes was collected during the first half of 2017.3. liabilities to all funds and governments as a result of the first half-year collections were recorded. (a schedule of amounts collected for each participant, showing the amount withheld for the county general fund and net amounts due the participants, is recommended for determining amounts to be recorded for this transaction.)4. all cash in the tax agency fund was distributed. requireda. prepare journal entries for each of the foregoing transactions that affected the tax agency fund. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field. do not round intermediate calculations. round your answers to the nearest whole dollar amount.)1. record the current-year tax levies to be collected by the agency.2.record the current taxes collected during the first half of 2017.3.record the liabilities due to all funds and governments at the end of first half-year.4. record the distribution of all cash in the tax agency fundb. prepare journal entries for each of the foregoing entries that affected the town of bayshore general fund. begin with the tax levy entry, assuming 2 percent of the gross levy will be uncollectible. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field. do not round intermediate calculations. round your answers to the nearest whole dollar amount.)1.record the revenues receivable and uncollectible.2. record the taxes collected

Kumar consulting operates several stock investment portfolios that are used by firms for investment of pension plan assets. last year, one portfolio had a realized return of 12.6 percent and a beta coefficient of 1.15. the average t-bond rate was 7 percent and the realized rate of return on the s& p 500 was 12 percent. what was the portfolio's alpha?

Answer the following questions using the banker’s algorithm: a. illustrate that the system is in a safe state by demonstrating an order in which the processes may complete. b. if a request from process p1 arrives for (1, 1, 0, 0), can the request be granted immediately? c. if a request from process p