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.
Recent Solved Questions
- BAC305: Sun Berhad acquired all the shares in Moon Berhad on 31 December 2022 for a cost of RM900,000: Company Accounting Reporting Assignment, WOU, Malaysia
- Fundamental Concepts of ICT Assignment, APU, Malaysia Information Technology becomes one of the greatest phenomena that ever exist in the world today
- Principle of Marketing Report, UON, Malaysia Business knows that they cannot appeal to all buyers in their markets or at least not to all buyers in the same way
- Project Cost Auditing Assignment, UITM, Malaysia Discuss an issue/ problem/ process improvement that occurs in the current construction project
- International Financial Management Assignment, MUM, Malaysia What can be inferred about the level of interest rate in Japan relative to the level of interest rate in the US
- Contract law Essay, UOL, Malaysia The Littledale Golf Club and At 9 am on 1st May the club places a large poster at the entrance
- ACC116 Introduction To Cost Accounting Assignment, UiTM, Malaysia Limau Manis Sdn Bhd is a medium-sized company that manufactures a variety of pickles in the northern region of Malaysia
- Palm Oil & Oleochemicals Course Work, CU, Malaysia The Oil Palm was first introduced in Malaysia in the early 1870s, as an ornamental plant. In 1917, the first commercial
- CBC3013N: Principles of Management Assignment, UOW, Malaysia Explain the roles and responsibilities of management. Explain management principles and the tasks of managers
- ASM657: Innovative Thinking Strategy Case Study, UiTM, Malaysia Explain how the idea will help to improve the quality of life and psychological well-being. how does the innovation deliver