CIS108 Data Modelling, Management and Governance Assignment

Reference no: EM132979167 , Length: word count:2000

CIS108-6 Data Modelling, Management and Governance - University of Bedfordshire

Assignment Report - Design and implementation

bExhibit a balanced and systematic understanding and knowledge of data modelling and management theory and data governance practice (including querying languages).
Learning outcome 2: Apply knowledge of data modelling and management concepts to design, develop and critically evaluate an information system within a chosen field of interest

This assessment is an individual assignment.

You are required to design (use-case diagram and Entity Relationship Model (ERM) a database solution for a sports club record system. The sports club scenario

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.

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:

1. A use-case diagram that identifies the key actors and use-cases in the system, as well as clearly displaying which use cases each actor has access to.
2. An Entity Relationship Model (ERM) that outlines the database structure required to implement the new sports club record system. Your database should be called ‘Sports Club Management System'.
3. SQL statements used to create each of the tables in the database
4. Two SQL queries - one that shows how a sports club member can view their current bookings; one that displays the current weekly activities for the sports club.

1. Provide a UML use case diagram and ERM diagram that accurately represents the scenario given
2. Create the relevant database tables using appropriate SQL commands
3. Provide two well-formed SQL queries to allow the database to be queried

1. 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)
2. Define appropriate primary and foreign keys for the relevant tables
3. Justify and analyse the design decisions that you have made.
4. Structure your report with a clear table of contents, including section numbers and page numbers, correctly formatted with no spelling errors or grammatical mistakes.

Attachment:- Management and Governance.rar

Reference no: EM132979167

Questions Cloud

Compute the return on equity ratios for both years : Compute the return on equity ratios for both years. Did the company generate greater returns for stockholders in 2015 or 2014?

Calculate the project NPV and advice ABC Ltd : The required rate of return in Germany is 10%. Calculate the project NPV and advice ABC Ltd whether the project should be executed

Calculate the monthly payment needed to amortize : Dan is considering borrowing $500,000 to purchase a new condo. Calculate the monthly payment needed to amortize

Determine bandera manufacturing gross profit : For the month ended January 31, determine Bandera Manufacturing's gross profit. Cost of Goods Sold, Profit Margin, and Net Income for a Manufacturing Company

CIS108 Data Modelling, Management and Governance Assignment : CIS108-6 Data Modelling, Management and Governance Assignment Help and Solution, University of Bedfordshire - Assessment Writing Service

What are the project free cash flows : Based on the research, the project is estimated to generate £600,000 in annual sales with costs of goods sold of £200,000. What are the project free cash flows

Compute the selling price using the variable cost method : Compute the selling price using the variable cost method. GoSnow sells snowboards. Each snowboard requires direct materials of $115, direct labor of $40

Should varto sell the products as is or process further : Should Varto sell the products as is or process further? Varto Company has 13,400 units of its sole product in inventory that it produced last year

Calculate the total change in net income : Calculate the total change in net income if Alternative A, B is adopted. Should Xinhong keep or replace its manufacturing machine?

User Account

All Pages