Computer Application Assignment, ICT, Malaysia Infinity College of Technology (ICT) provides sports facilities to be used not only by its students but also by the public
| 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:

Get Help By Expert
Assignmenthelper.my offers essay help online for students of all educational levels who are facing difficulties in any essay-related task. With us, you can get top-notch quality services without any worries. We provide the best and most reliable assignment help in Malaysia, so you do not have to worry about anything.
Recent Solved Questions
- Sustainable Project Management Assignment, OUM, Malaysia Sustainable Development Decision Making Decision-making for sustainable project management can be a very arduous
- Ethical Research Proposal: Preschool Parents’ Views on 21st Century Education
- Delivering Values for Customers Assignment, TU, Malaysia To create the most suitable STP and marketing mix strategies, the sales representatives of Mercedes Benz
- TME303: Figure 1(a) and (b) shows a robotic arm used in automotive industry for painting and welding application: Automation And Robotics Assignment, WOU, Malaysia
- JAVA Programming Level 1 Assignment, UNIKL, Malaysia The management of an airport thinks that the way in which the airport is operated means that incoming flights
- HRM2100: the Job Description (JD) and Job Specification (JS) of the job title stated :Fundamentals of Human Resource Management Assignment, IIU, Malaysia
- MPU3223 V2: ENTREPRENEURSHIP II KEUSAHAWANAN II MAY 2024 SEMESTER Assignment, OUM, Malaysia
- ABXM1103: MAN, SOCIETY AND CULTURE Assignment, OUM, Malaysia The International Labour Organization (ILO) reports that more than 15 million children or nearly one in every 10 children
- Organic Chemistry Assignment, UNIMAS, Malaysia Draw the structures of the following compounds showing every orbital involved in the sigma
- Occupational Safety and Health Management Report, OUM, malaysia Discuss the tragedy happened in this movie from the point of view of the Domino Theory and Multiple Causation Theory
 
     
			