Draw an erd based on business rules

Assignment Help Other Subject
Reference no: EM132087936

Task

Overview of business case:

Bruce is a volunteer football (soccer) coach at XYZ United. At this stage, to announce training sessions, Bruce sends an SMS to his players. While this system works for him, it does not help him with getting accurate numbers of those who are coming to training sessions, especially when there are last minute changes. To address this problem he decided to implement a web database system. Accordingly, he hired you to design a relational database to better track and record the operational data.

NOTE: The overview of business case is included here to provide context only. For the purpose of identifying entities, attributes and relationships between entities please read the business rules and instructions for creating your ERD below.

NOTE: For guidance on how to draw an ERD based on business rules, watch this YouTube video:

How to draw an ERD from business rules by Yeslam Al-Saggaf

The business rules and instructions for creating your ERD:

Each player is expected to attend all 20 training sessions. For each training session to go ahead, six or more players must register to attend it. Every training session is identified by a training session ID. The date, time and venue are also kept in the system for each training session. Each player is identified by a player ID. For each player, the player's name, DOB and playing position are recorded in the system. An important training session's detail is that the system also takes note of the players who attended each training session and the rating of the performance that each player gives at the end of each training session.

Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.

Verified Expert

This paper is prepared from the tables Rep, Customer, Orders, OrderLine, Item that is related to Sample data for TAL Distributors. Some Data Manipulation queries are asked which uses select command that uses where condition. The data is retrieved from more than one tables , where we use the alias name for the table. This paper also concentrates in Nested queries which is nothing but a query inside another query. Fist the inner query is executed then the outer query is executed. For all the tables the query is written with its output after execution of the query. This document was prepared by using Microsoft word.

Reference no: EM132087936

Questions Cloud

What is the effect of control buffer on the browning process : What is the effect of control buffer on the browning process?
Discuss purpose and guiding principles of your new venture : Discuss the purpose and guiding principles of your new venture.
How much life insurance do you need : How much life insurance do you need? Using the Life Insurance Calculator, enter the information and post your results in the textbox.
Investors check how their portfolios are doing : Investors check how their portfolios are doing more frequently when markets are going up than when markets are going down.
Draw an erd based on business rules : Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship
Estimate the project overall cost : Describe a high-level timeline that includes key tasks and deadlines. Estimate the project's overall cost and any key staffing and non-staffing resources needed
How the four contemporary approaches to management : The contemporary approaches to management include: socio technical theory, quantitative management, organizational behavior, and systems theory.
What is the cost of new equity to the firm : What is the component cost for Coogly's preferred stock? What are the advantages and disadvantages of using preferred stock in the capital structure?
Successful on platform of ethics and social responsibility : Many small business were founded and grew to be successful on a platform of ethics and social responsibility.

Reviews

inf2087936

10/27/2018 2:44:04 AM

I have not received my paid assignment back. oh sorry did not check your message below, thanks for the solution. I cannot open the document. I do not have a zip. Please send it in Microsoft Word format. thanks for your quick support and sending unzipped files on my mail id, now I accessed and checked everything, its perfect work, thanks

len2087936

8/16/2018 11:34:54 PM

Requirements Either save your ERD diagram as a PDF or embed it in a Word document. Don't use any other file formats Don't submit your file in XML Please include your student ID, name and subject code in the diagram

len2087936

8/16/2018 11:34:47 PM

The marking criteria for this assignment is: Criteria HD DI CR PS be able to model complex business rules using Entity Relationship Diagrams (ERDs). Model identifies all PKs, attributes and relationships. Model accurately represents all four business rules and includes all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Model identifies PKs, attributes and relationships with minor omissions. Model accurately represents the business rules and includes the identified entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Model identifies key PKs, attributes and relationships. Model represents key business rules and includes the related entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Model represents key business rules and draws out the key relationships and includes the related entities, PKs, attributes, relationships, cardinalities and optionalities.

len2087936

8/16/2018 11:34:35 PM

NOTE Use Crows Foot notations Include the PKs where appropriate Any M:N relationship is to be resolved to a 1:M relationship Manually drawing the ERD is NOT acceptable. Rationale This assessment task will assess the following learning outcome/s: • be able to model complex business rules using Entity Relationship Diagrams (ERDs). Marking criteria and standards

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd