Part I Kent State University is updating its systems to more agile andscalable ones. In coordination with
Question:
Part I
Kent State University is updating its systems to more agile andscalable ones. In coordination with the MIS department head andprofessor Ghassan Abukar, the CIO requested the help of CIS44043-001 class to lead the design phase, implementation anddeployment of their new database.
KSU pride itself to be the leaders in adopting the newesttechnology and services. The business team drafted initialfunctional requirements to start the design database phase. Therequirements (R) are as follow:
- R1: Each college must have a name, dean name, building, phone,and office number.
- R2: Each department must have a department name, phone, majors,and classrooms.
- R3: College contains many departments.
- R4: Each Professor must have an ID, name, office number, andphone.
- R5: Each department can have multiple professors.
- R6: Appointments must have appointment ID, department name, andprofessor ID.
- R6: Appointments to be scheduled in coordination with theprofessor, and department.
Based on the above information provided, answer the followingquestions, and provide a reason behind your decision.
- Q1: Identify each entity (What are the entities?).
- Q2: Identify the relationships.
- Q3: Identify the key attributes.
- Q4: Identify any other relevant attributes.
- Q5: Identify the cardinalities.
- Q6: Create Crow’s Foot Entity Relationship Diagram thatcaptures the initial information provided by the businessteam.
Part II
After the initial ER design, the business department providedadditional functional requirements to be merged and added to theinitial design. The requirements are as the following:
- R1: Courses have an ID, name, department name, professor ID,duration, and classroom.
- R2: Each Department can have one or more courses.
- R3: Each course can be offered by one department only.
- R4: Professor can teach many courses.
- R5: Each course can have one professor only.
- R6: The student has an ID, first name, last name, phone, andcourses.
- R7: Students can register many courses.
- R8: Each course can have many students.
Based on the above information provided, answer the followingquestions, and provide a reason behind your decision.
- Q1: Identify each entity (What are the entities?).
- Q2: Identify the relationships.
- Q3: Identify the key attributes.
- Q4: Identify any other relevant attributes.
- Q5: Identify the cardinalities.
- Q6: Update the initial Crow’s Foot ERD.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill