Database
Just tell me what relationships are
ACTIVITY PX STUDENT Nd FN sunt UN dent Phone number Cay Name Venue autocally domi) EMPLOYEE PE IN IN Phone number Address A Gordiata (0) PK emp_ld Fr Id sta city is coordinator 6 7 APPROVED N Name PY FK SHOP Name CITY CONDUCTED Id approved Coordinator Location De Total expenses we id Name PR Coordinator FK ent_cho Stet Scenario The college of CCIS decided to develop a Relational Database for its Activity Club. After setting with the Club Coordinator and members, we concluded important information regarding the operations that are needed to be conducted using the required Database and the data inserted and information retrieved. As per the Club Coordinator (who has a minor knowledge in databases), they have students' information such as Student Identification number, Student First Name, and Last Name, along with their phone numbers, City, and Address stored in an excel sheet. They also keep the information of the Employees (Club's Coordinators, Administrators, and other Co- employees) in the same file. The information related to the Employees are Employee Identification Number Employee First and Last Name, Position (Faculty, Admin), their Phone numbers, City, and Address. The table also has whether the Employee is a Coordinator for the club or not as (yes or no) values. The excel file also contains other important information such as a list of possible Activities that might take place in the college, Activities Approved and Conducted in the past ten years, along with the dates and the students who participated. The Coordinator highlighted that she needs to be able to have different tables for the Activities. First, she needs a list of Activities' names and descriptions, so any Coordinator who comes after can understand what we can have. Second, she also needs separate tables for (Approved Activities) and (Conducted Activities). The first one should have an Approved Activity ID, the Activity itself, who approved it from the Employee list, the approved budget, and the approval date. The second table should have an Approved Activity ID, Employee Coordinator of that Activity, Location of the Activity (in college, public), total expenses, and the date of Activity The Coordinator comes to know that she needs to track the names of the shops that usually arrange the events so she can deal with them in future. Hence, she asked to have a name list of Event Shops. Another request the Coordinator mentioned that she needs to know all Students' names who participated in each Activity and all event shops that arranged each Activity. Moreover, she prefers to have a list of Cities saved in a separate file. This will make it easy for her to find the students/employees who live in other cities to help her in buying/reserving tools and equipment that are not available in AlMajmaah. According to the Club coordinator, she usually chooses the students for conducted Activities based on their skills, so it would be amazing to include the skills field in the Student table. She gave us an information which is any activity should be approved by one and only one employee (Such as the dean or the vice dean)
