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 Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
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.
Answer
Recent Solved Questions
- ACC116: Introduction To Cost Accounting Assignment, UITM, Malaysia Rising Fast Sdn Bhd manufactures a complete line of fiberglass attaché cases and suitcases
- Personnel and Career Development Counselling Report, MUM, Malaysia I’m the oldest child, so technically I’m like the third Baron in the family, so when I was young I am when my parents
- BMMK5103: Marketing Management Assignment, OUM, Malaysia The World Health Organization on March 11, 2020, declared the novel coronavirus outbreak a global pandemic
- European Union Law Course Work, UOL, Malaysia In June 2020, the European Union adopted the ‘consumer protection’ directive. The Directive provides that consumers
- Factors Influencing Perceived Stress and Its Impact Towards Food Consumption Behaviour During The Pandemic Assignment, MSU, Malaysia Coronaviruses are a group of viruses adapted from the family of Coronavidae that has caused a change in the lives
- ADS553: Strategic Management For Public Sector Report, UiTM, Malaysia Your task is to prepare a proper presentation together with a written report on any newspaper articles discussing various projects
- Ernest Shackleton’s Leadership & Gig Economy’s Impact
- You felt that the above retirement program may be very hard to achieve as your monthly income is not sufficient to contribute the required monthly investment installment: Financial Management Assignment, UTP, Malaysia
- Risk and Hazard Management Assignment, SU, Malaysia Description of the industry or workplace. Evaluation of the possible hazards and risks covering factors such as human errors
- Business Professional Ethics Case Study, UTHM, Malaysia This Milk manufacturer is based in Port Klang, Selangor. The Managers of the company are very friendly with the customers
