(2) A generous Hofstra alum establishes a trust fund to support the math department's budget for seminar snacks and contributes $10,000 to it initially. The budget will start at $600 and increase linearly at a rate of 2% each year. Suppose the trust fund earns interest at a rate of 4% each year and that the trust fund is paid out continuously, the interest is compounded continuously, and the budget increase is granted continuously. (a) Write down an initial value problem for the amount of money in the trust fund that describes this situation. (b) Find a general solution to the initial value problem in part (a). QUESTION 1: Entity-Relationship Diagram 1. Suppose you are using a spreadsheet for MBA class schedule. The spreadsheet currently has the following columns: StudentID: Student's identification number StudentName: Student's name StudentAddress: Student's address ClassID: Class identification number ClassDay: Day of the week the class meets Class Time: Time the class meets InstructorID: Instructor's identification number InstructorName: Instructor's name Each class meets only once a week and may have several instructors. An instructor can teach more than one class. A student can enroll in more than one class. (1) You are being asked to design a database to store this information. Create an E-R diagram. Neatly label the entities, the relationships and the maximum cardinalities Simplied ERD (as we discussed in class) is ok. (2) How many tables do you need to create for this database? Hint: Each entity will become a table and each many-to-many relationship becomes a table. (3) Now suppose each class has only ONE instructor, but every instructor can teach severa classes. Please create another E-R diagram. How many tables do you need to create for this database? (2) A generous Hofstra alum establishes a trust fund to support the math department's budget for seminar snacks and contributes $10,000 to it initially. The budget will start at $600 and increase linearly at a rate of 2% each year. Suppose the trust fund earns interest at a rate of 4% each year and that the trust fund is paid out continuously, the interest is compounded continuously, and the budget increase is granted continuously. (a) Write down an initial value problem for the amount of money in the trust fund that describes this situation. (b) Find a general solution to the initial value problem in part (a). QUESTION 1: Entity-Relationship Diagram 1. Suppose you are using a spreadsheet for MBA class schedule. The spreadsheet currently has the following columns: StudentID: Student's identification number StudentName: Student's name StudentAddress: Student's address ClassID: Class identification number ClassDay: Day of the week the class meets Class Time: Time the class meets InstructorID: Instructor's identification number InstructorName: Instructor's name Each class meets only once a week and may have several instructors. An instructor can teach more than one class. A student can enroll in more than one class. (1) You are being asked to design a database to store this information. Create an E-R diagram. Neatly label the entities, the relationships and the maximum cardinalities Simplied ERD (as we discussed in class) is ok. (2) How many tables do you need to create for this database? Hint: Each entity will become a table and each many-to-many relationship becomes a table. (3) Now suppose each class has only ONE instructor, but every instructor can teach severa classes. Please create another E-R diagram. How many tables do you need to create for this database
