ISM 4212 Homework 1 - ERD Design Given the case provided identify the entities, the attributes, the business rules and design a database diagram.

1. Identify the entities (15 point).
2. Identify the attributes for the entities (15 points).
3. Draw an ERD for the following case. Be sure to include the entities, attributes, primary keys (identifiers), foreign keys, and relationships (including cardinality). Also, do not leave any many-to-many relationships in your data model. The ERD can be drawn on a paper, scanned and then uploaded to Canvas. (60 points)
4. Specify the major business rules based on the case description. (10 points)

ISM 4212 Homework #1 - ERD Design Due Date: Oct 01, 2021 by 23:59 Points:100 points Late penalty: 5% penalty for one-day late The latest submit date: Oct 04 12:00 pm Business Case: 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. Assignment Instructions: Given the case provided identify the entities, the attributes, the business rules and design a database diagram. (1) Identify the entities (15 point). (2) Identify the attributes for the entities (15 points). (3) Draw an ERD for the following case. Be sure to include the entities, attributes, primary keys (identifiers), foreign keys, and relationships (including cardinality). Also, do not leave any many-to-many relationships in your data model. The ERD can be drawn on a paper, scanned and then uploaded to Canvas. (60 points) (4) Specify the major business rules based on the case description. (10 points) Deliverables: A word document answering Questions (1), (2) and (4). A photo or scanned ERD design