New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

24 Pages
ITEC622 Data Analytics and Visualisation

Question: Scenario WA Cyber Command – WACY-COM has acquired aggregate data about 200,000 identified cyber-attacks and scans. The data are sourced from a Honey-pot project which places fake s ...

Course

ITEC622

Type

Programming

Subject

Database

University

Australian Catholic University

Season

Fall

0 Page
Establish Data Models

...

Course

IT234M1

Subject

Database

University

Purdue University Global

Season

Fall

0 Page
Conceptual Data Modeling

...

Course

IT234M1

Subject

Database

University

Purdue University Global

Season

Fall

43 Pages
Structured Query Language

© Swinburne University of Technology 24/09/19 Page 1 of 4 A ss ignm ent 2 COS60009 Da ta M anag em ent for the Big Da ta Age 1 Assignm ent Descript ion This is ...

Course

COS60009

Subject

Database

University

Swinburne University of Technology

Season

Spring

CIS108-6 Data Modelling Management and Governance

Question

Answered

Question:

1.Exhibit a balanced and systematic understanding and knowledge of data modelling and management theory and data governance practice .

2.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?

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.

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

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.

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.

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?

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

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

1.Provide an Entity Relationship model that accurately reflects the scenario and that captures appropriate attributes and correctly identifies relationship cardinality

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.

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?

Your assignment will be marked according to the threshold expectations and the criteria on the following page.

You can use them to evaluate your own work and consider your grade before you submit.

CIS108-6 Data Modelling Management and Governance

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

19 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com boasts a team of talented and highly skilled coursework writers based in UK who assist students in the best possible manner. Students, who need coursework help, find our services fulfilling and effective because we provide high quality help at affordable price. So, students who often search can someone do my coursework cheap or can experts Write my coursework for cheap get perfect solution at MyAssignmenthelp.com. They pay for best coursework and get it from us.

More CIS108-6 Data Modelling Management and Governance: Questions & Answers

Q
icon

We aren't endorsed by this University

ITEC622 Data Analytics and Visualisation

Question: Scenario WA Cyber Command – WACY-COM has acquired aggregate data about 200,000 identified cyber-attacks and scans. The data are sourced from a Honey-pot project which places fake servers across the globe and records attacker activity and techniques. As Honeypots are simulated net ...

View Answer
Q
icon

We aren't endorsed by this University

Establish Data Models

...

View Answer
Q
icon

We aren't endorsed by this University

Conceptual Data Modeling

...

View Answer
Q
icon

We aren't endorsed by this University

Structured Query Language

© Swinburne University of Technology 24/09/19 Page 1 of 4 A ss ignm ent 2 COS60009 Da ta M anag em ent for the Big Da ta Age 1 Assignm ent Descript ion This is an individual assignment. Stud ents are r eferr ed to the F ac ulty’s policy on plagiarism. S ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?