Exhibit a balanced and systematic understanding and knowledge of data modelling and management theory and data governance practice (including querying languages).
Apply knowledge of data modelling and management concepts to design, develop and critically evaluate an information system within a chosen field of interest
What am I required to do in this assignment?
You are required to design (use-case diagram and Entity Relationship Model (ERM) a database solution for a sports club record system.
You have been employed as a database designer to design and implement a new membership record system that is capable of storing information about members, sports club staff and sports activity bookings.
Each sports club member needs to have a unique member reference number, as well as storing first name, surname, address, telephone number, email address and date of birth and any medical conditions.
Each member can book up to five sports classes per week. Each sports class has a unique class code, title, day and time of delivery. The system should allow an instructor (sports club staff member) to search for the activities running on a particular day. Each member can only sign up for one sports club during any two hour time slot (9am-5pm) and no activities that overlap can be booked concurrently. Sports club staff members and staff can check and update their personal details, sports centre staff can record attendance for a class they are teaching, and each member can view their daily or weekly activity bookings.
As part of this assignment you must produce and hand-in the following:
As part of your report you should explain your design decisions, and identify and issues or challenges that you faced in completing the report. A single report containing items 1-4, plus your design decisions and challenges should be submitted online via the Assessment and Feedback area.
What do I need to do to pass? (Threshold Expectations from UIF)
How do I produce high quality work that merits a good grade?
How does this assignment relate to what we are doing in scheduled sessions?
This assignment brings together database design (use-case, requirements specification, Entity Relationship Modelling) and implementation (tables creation, primary and foreign key assignment) and testing through use of SQL queries.
How will my assignment be marked?