Infinity College of Technology (ICT) provides sports facilities to be used not only by its students but also by the public: Computer Application Assignment, ICT, Malaysia

University Infinity College of Technology (ICT)
Subject Computer Application

Question 1

Infinity College of Technology (ICT) provides sports facilities to be used not only by its students but also by the public. To keep track of the booking information of the facilities, ICT hires a database designer to design and develop a database system according to the following requirements:

  • The facilities provided by ICT include sports equipment, a gymnasium, a court for games like badminton, futsal, and netball, a football field, and indoor games. Generally, these facilities can be categorized into two categories which are equipped and venues. The information that should be recorded for facilities includes Fac_ID, Fac_Type, Fac_Name, Fac_Desc, and Fac_Rate. The equipment may have its own specific attribute such as unit availability while capacity is a special characteristic of the venues.
  • A user can book many facilities and a facility can be booked by many users. Booking information is needed such as UserID, a facility that they want to book, time of use, date of use, and quantity of equipment and number of venues they need.
  • A user can be a student or the staff of ICT or they could be outsiders. The students or staff may use the sports equipment and venue for free but the outsiders, they will be charged. All types of users may have their own special characteristics that should be recorded.
  • The staff of the sports center at ICT can record many bookings, and each booking is recorded by only one staff.

Question 2

Identify the business rules in the ERD diagrams below:

Computer Application

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Get Help By Expert is an excellent chance for students to get case study assignment help quickly and conveniently. Our writers are experts in their fields and offer unmatched case study services. Trust our malaysia assignment help helper to ensure that you submit your case study before your deadline!


Recent Solved Questions

Online Exam & Assignment Writing Services

11770+ Orders Delivered

5 Star Rating

Confidential & Secure Assignment Help For

Group Assignment Help

Online Exam -Test & Quiz

Cheapest Price Quote

Diploma & Certificate Levels

Semester & FYP Papers

Summative & Individual

GBA & Reflective

Last Minute Assistance

Sample Assignment Download

CEM584 Infrastructure Asset Management UITM Assignment Sample Malaysia
CEM584 Infrastructure Asset Management is a comprehensive course offered by Universiti Teknologi MARA (UITM) that aims to equip students with the necessary knowledge and skills to effectively manage infrastructure assets.…
BCM673 Project Evaluation And Development UITM Assignment Sample Malaysia
BCM673 Project Evaluation And Development is a unique course that provides students with an in-depth understanding of the importance of project evaluation and development. This course explores real-world applications of…
Assignment Sample


Instant Paper Writing Services by Native Malaysia Writers

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now

Get Assistance for Assignments, online Exam, and Projects Writing