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:
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
Get Help By Expert
MalaysiaAssignmentHelp.com 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 assignment help experts to ensure that you submit your case study before your deadline!
Recent Solved Questions
- The main goal of the Business Project Course is to provide an opportunity for you either to achieve a better understanding: Supply Chain Management Assignment, SU, Malaysia
- ACC4304: Auditors cannot effectively audit clients unless they fully understand the client’s industry and the inherent risks that may affect their client: Auditing Assignment, TARC, Malaysia
- MKT542: Write a conclusion paragraph that briefly informs the reader of what you wrote about in your review and your overall findings: Channels Management Case Study, UiTM, UK
- You are asked to develop a program for Mobile Soft Inc. to calculate the year-end promotion price that should be paid by its customers: Programming Assignment, HU, Malaysia
- Provide a brief discussion on the importance of the external environment and internal analysis of the organizations: Business Administration Report, UTN, Malaysia
- Based on the segmentation selected in the previous question, which group of customers do you intend to target: Principle of Marketing Assignment, UTM, Malaysia
- You need to find a news story in the media that discusses (explicitly or implicitly) the effects of public relations: Public relations Assignment, UTAR, Malaysia
- MKT3811: Construct an appropriate Integrated Marketing Communications (IMC) strategy for UMW Holdings to stay attractive to the business-to-business: Marketing Analysis & Decision Making Assignment, Malaysia
- You are required to choose a case for a patient who suffered from a Genitourinary or Endocrine disease/disorder: Genitourinary Case Study, IMC, Malaysia
- SBFS1103: Assuming you are a production manager in a semiconductor manufacturing company in Penang: Thinking Skills and Problem Solving Report, OUM, Malaysia