Loading ...
Global Do...
News & Politics
15
0
Try Now
Log In
Pricing
PROJECT TITLE : ASSET TRACKING AND MANAGEMENT SYSTEM REPORT 2: E-R MODELLING LECTURER’S NAME : ENCIK AHMAD TARMIZI BIN ABDUL GHANI GROUP(20) MEMBERS : (TP) PHOON LEM A129548 NENO FITRI A130506 MUHAMMAD IBRAHIM A130507 RIRA RAHAYU ARRIDHA A130505 Applicant (Outsiders) PK FK Applicant_ICno Booking_ID Applicant_name Applicant_housePhoneNo Appicant_hpNo Applicant_email Make STUDENT PK FK Stud_matrixNo Booking_ID, Equipment_ID Student_name Student_ICno Student_collAdd Student_hpNo Student_email BOOKING PK FK Booking_ID Courts_ID Date_of_Booking Start_date End_date Start_time End_time Field_type Field_no Court_type Court_no Others Quantity Chargers/fees Make Make COURTS PK FK Courts_ID Maintenance_ID Booking_ID Courts_no Field_no STAFF PK FK Staff_ID Booking_ID, Equipment_ID Staff_name Staff_ICno Staff_offAdd Staff_offPhoneNo Staff_hpNo Staff_email EQUIPMENTS PK Equipments_ID Sport_type Equipment_type date_of_borrowing Start_date End_date Quantity Borrow TECHNICIAN PK FK Technician_ID Maintenance_ID Technician_name MAINTENANCE PK FK Maintenance_ID Courts_ID Technician_name(discovered problems) Technician_name(fixed problems) date_problems_found date_problems_fixed Problems Field_type Field_no Court_type Court_no Others Fixed_part Cost Do Make Borrow To book E-R MODELLING BUSINESS RULES UPDATED 1. A student can make zero or many booking. 2. Attributes of student are Stud_matrixNo, Booking_ID, Equipment_ID, Student_name, Student_ICno, Student_collAdd, Student_hpNo, Student_email 3. An applicant(outsider) can make zero or many booking. 4. Attributes of applicant(outsiders) are Applicant_ICno, Booking_ID, Applicant_name, Applicant_housePhoneNo, Applicant_hpNo 5. A staff can make zero or many booking. 6. Attributes of staff are Staff_ID, Booking_ID, Equipment_ID, Staff_name, Staff_ICno, Staff_offAdd, Staff_offPhoneNo, Staff_hpNo, Staff_email 7. Attributes of booking are Booking_ID, Courts_ID, Date_of_Booking, Start_date, End_date, Start_time, End_time, Field_type, Field_no, Court_type, Court_ no, Others, Quantity, Charges/fees 8. Zero or many students can borrow for equipments. 9. A student can borrow for zero or many equipments. 10. Zero or many staffs can borrow for equipments. 11. A staff can borrow for zero or many equipments. 12. Attributes of equipments are Equipments_ID, Sports_type, Equipment_type, Date_of_borrowing, Start_date, End_date, Quantity. 13. A booking can be used to book one or many courts. 14. A court may need to make zero or many maintenance. 15. Zero or many courts may need to make a maintenance. 16. A technician can be assigned to do zero or many maintenance. 17. One or many technician can be assigned to do a maintenance. 18. Attributes of maintenance are Maintenance_ID, Courts_ID, Technician_name(discovered problems), Technician_name(fixed problems), date_problems_found, date_problems_fixed, Problems, Field_type, Field_no, Court_type, Court_no, Others, Fixed_part, Cost 19. Attributes of technician are Technician_ID, Maintenance_ID, Technician_name 20. A court or field is rented out based on a rental plan chose by customer. 21. Many courts may make many time of maintenance from time to time. 22. Courts may be rented out to students, staffs, and outsiders. 23. Equipments may be borrowed out just for students and staffs but not outsiders.
