CIS108-6 Data Modelling, Management and Governance-Management Assignment Help

What am I required to do in this assignment?

This assessment is an individual assignment.You are required to write a report on how you design and implement a database solution for a sports club record system. Remember this is NOT a research project. Your report cannot be research report.

The sports club scenario

You have been employed as a database designer to design and implement a Sportclub record system that stores information about sports activity and taught class bookings.

The imagination sport club exhibits the following facts:

1. Each sports club member has a unique membership number, the system needs to store member's first name, surname, address, telephone number, email address, date of birth and any medical conditions.

2. Each sports club staff also has a unique staff number, first name, surname, role and a contact number.

3. Each sports class (staff teach) must have a unique class code, title, day and time of delivery.

4. Non-class Activity (only use facilities) and class bookings must follow the following rule:

a. Each member can book up to five sports classes per week.

b. Each member can only book once of any one sport activity (like badminton, Basketball)and the maximum two-hour time slot.

c. No activities that overlap can be booked.

d. Sports class only runs from 9am to 5pm but activity can run from 6am to 10pm.

5. The system should allow:

a. An instructor (staff member) to search for the activities running on a particular day.

b. Sports club staff members and staff can check and update their personal details.

c. Sports club staff can record attendance for a class they are teaching.

d. Each club member can view their daily or weekly activity bookings.

Your report must provide (minimum):

1. A relational database system named Sports Club Management System.

2. A Use-case diagram that identifies the key actors and use-cases in the system and represents the requirements specified in the scenario.

3. An Activity diagram for a club member to book an badminton session and a Yoga class.

4. An Entity Relationship diagram that you designed can satisfy the requirements outlined by the use-case diagram and the activity diagram.

5. A list of the SQL statements that covers:

a. Used to create tables that implement the ERD identified in 3.

b. shows how a sports club member can view their current bookings and reflect the booking rules.

c. displays the current week activities booked club members.

d. Display the current week class offered by the club including staff and number of class size.

e. Show most active members monthly (most bookings and most attendance) Your report should explain your design process and decisions at each phase. You should also identify any issues or challenges that you faced in each step.

What do I need to do to pass? (Threshold Expectations from UIF)

1. Provide a clear data system design process and decision you made

2. Provide a use case diagram, an activity diagram and that accurately represents the requirements for the scenario given

3. SQL statements that create the relevant tables with sufficient attributes name, type and domain and queries that evidently shows the required function are implemented.

How do I produce high quality work that merits a good grade?

1. Evidently demonstrated you have sufficient knowledge of system design process, methodology and use of necessary tools.

2. Requiremen analysis: identify proper use cases. Provide reasonable UML use case diagram to reflect your understanding of the given scenario, a supplementary use case document may be provided

3. Provide an Activity diagram that check booking constraints and make book successfully.

4. Provide an Entity Relationship model that accurately reflects the scenario and that captures appropriate attributes and correctly identifies relationship cardinality (e.g., 1-to-1; 1-to-Many or Many-to-Many). A supplementary annotation may be provided to explain your design rationality.

5. Define appropriate primary and foreign keys for the relevant tables, a relation scheme diagram may be provided to show all the tables and relations between tables in your system. Justify and analyse the design decisions that you have made.

6. SQL statement with running results clearly demonstrated the requirements are utilised. Particularly demonstrate the constrains of booking are implemented.

7. Structure your report with a clear table of contents, including section numbers and page numbers, correctly formatted tables, figures with captions, whole report should have no spelling errors or grammatical mistakes.

8. Extra marks will be awarded to any creative idea, constructive analysis and evidently demonstrate the report beyond the requiments listed in this section but towards more professional practice in the industry such as “system tech design report, implementation report, testing report and operation manual (typical usage) etc.

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.

This CIS108-6: Management Assignment Help has been solved by our Management experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.