About Global Documents
Global Documents provides you with documents from around the globe on a variety of topics for your enjoyment.
Global Documents utilizes edocr for all its document needs due to edocr's wonderful content features. Thousands of professionals and businesses around the globe publish marketing, sales, operations, customer service and financial documents making it easier for prospects and customers to find content.
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.