Construct an entity-relationship model for the database

Assignment Help Data Structure & Algorithms
Reference no: EM13190837

Barwon TaiChi is a small and dynamic business located in Geelong and Melbourne. It provides self-defence, fitness, and martial arts classes to individual of all ages, schools and organisations. More specifically, they provide training in Chi Kung fitness, various forms of Tai Chi chuan, Tai Chi fan, Tai Chi sword, KungFu Wushu such as Shaolin pole, Shaolin spear. It was started as a family business owned by Grand Masters David Sun and Vicky Greens and their children in Barwon early in 2000s.

Over the last 12 years the business has increased in size and diversified. Now with about 20 masters, they run regular classes in seven locations including two in Geelong and five in Melbourne. The classes are scheduled around the Victorian school terms. Students pay tuition fees directly to their master in the first week of every term. If a student starts his/her training during a term then he/she pays in the second class; the first class is free for beginners. About half of their revenue is generated from delivering tailor made courses and one-day programme to schools, corporations, and community events such as multicultural festivals, Chinese New Year celebrations...

Barwon TaiChi offers the following regular activities:

- Classes for beginners
- Classes for advanced students
- Classes for senior citizens
- An annual competition for different levels and age groups.

Regular classes are held after hours, often between 6 pm and 8 pm.

There is very little use of the information technology in Barwon TaiChi. They have a basic Web presence to list the time and place details of the regular classes, contact details and competition photos. They accept email, post and telephone enquiries and bookings for corporate training and individual enrolments in regular classes. All the bookings and enrolments are recorded manually and there are many errors resulting from organisational inefficiencies. Barwon TaiChi accepts bookings from organisational clients around the year, delivers training services, and at the end of each month sends out a billing statement to each of them.

In addition, Barwon TaiChi also sells training materials and weapons to their students, for example instructions in DVDs, Zen music in CDs, books, uniforms, shoes, swords, poles, fans, etc. They seek innovative business development, such as traditional healing acupuncture and medicines, social BBQs, dinners, tea parties, cultural tours to China, Vietnam, Taiwan, etc. Recently, Barwon TaiChi decided that Barwon TaiChi must take advantage of the current technological trends including the Internet and possibly mobile technologies. The business needs a more advanced Web presence that would deliver value through marketing, facilitating information sharing, enabling transaction processing, and/or creating a vibrant community of their masters, students and organisational clients.

You are employed as business analysts at Deakin Innovative Solutions Pty Ltd, a business consulting firm. You are assigned to investigate and develop a conceptual model for back-end of the client's website. The financial system is outside the scope of this project.

Operations

The system needs to be able to provide the following data:

- monthly reports on new students with enrolled style of training and location
- monthly reports on total number of students in each location
- the ability to make ad hoc queries, for example,

o which locations have a particular style
o item by item value of stock on hand
o how many customers from a particular postcode

1. Construct an entity-relationship (ER) model for the database. Make sure you include in your model details of entities, relationships, attributes, keys and limits in participation.

Ensure that you give adequate justification for the assumptions that you make in designing your entity-relationship model and include any important integrity constraints (business rules).

2. Show by providing SQL statements, that all of the ‘dot points' in the Operations section can be produced from an implementation of your ER diagrams. Sometimes you may need to use more than one SQL statement, and you should explain how one SQL statement provides information needed by the subsequent SQL statement.

3. Present this as a Business Report to your client

Reference no: EM13190837

Questions Cloud

Adolescent and family health : Prepare a report on the activities carried out by a teacher in class-room under value-based interventions for adolescent and family health
Explain causes for the downward tailspin of the economy : The global economy in 2011 appears to be headed into a double-dip recession. Based on your knowledge of aggregate demand and aggregate supply, suggest the reasons and causes for the downward tailspin of the economy.
Construct an entity-relationship model for the database : Construct an entity-relationship (ER) model for the database. Make sure you include in your model details of entities, relationships, attributes, keys and limits in participation.
State how long will it take react : Is a first order rate constant of 3.14x10^-4 1/s at room temperature, if you currently have a 2.5 M N2O5 how long will it take for 65% of N2O react?
Tendency to fill in missing sensory information : Can you think of any advantages that the tendency to fill in missing sensory information, such as visual sensations that fall on the blind spot, give humans?
Do events would cause an increase or a decrease in demand : In the market for flash memory drives ( a normal good), exlpaing whether the following events would cause an increase or a decrease in demand or an increase or decrease in the quantity demanded.
Interest-based negotiation : Compare and contrast interest-based negotiation with power- and rights-based negotiations.

Reviews

Write a Review

 

Data Structure & Algorithms Questions & Answers

  Creating a table of xml documents

Make a table of XML documents with a type of XML. Use a primary key so add a field of type INT that is an identity. Insert many records into XML field in this new table.

  Write a procedure hamming

Write a procedure hamming(ascii, encoded) that converts the low-order 7 bits of ascii into an 11-bit integer codeword stored in encoded.

  Find the weight range of normal onion bags

A packaging equipment is used to put onions into five pound bags. In fact the weights vary according to the normal distribution with expected price of average µ = 5.01 lb and standard deviation s = 0.05 lb.

  Developing an eer model

Construct an EER model for the given situation using the traditional EER notation, the Visio notation or the supertypes notation.

  Create a solution algorithm using pseudocode

Algorithm that will receive two integer items from a terminal operator, and display to the screen their sum, difference, product and quotient.

  Design and implement an avl tree algorithm

Design and implement an AVL tree algorithm that searches a collection of documents. You will be provided with a set of 50 documents and a set of sample queries. First, you will process the documents and store their content (i.e. words / tokens) in..

  Conceptual model entity relationship diagram

Assume you are asked you to create a new entity-relationship diagram for a corporation for a customized shipment tracking system.

  The ace is played when both the king

The Ace is played when both the King and Queen are showing on the table, or when neither the King and Queen are showing on the table.

  Complications in a time sharing system

Determine what complications could happen in a time-sharing system if two processes need access to the same file at the same time?

  Give a recursive algorithm for finding the number of one''s

Give a recursive algorithm for finding the number of one's in a bit string, name the algorothm count-ones.

  Give algorithm to find schedule to obtain maximum profit

Give an algorithm to find the schedule that obtains the maximum amount of profit, assuming that all processing times are integers between 1 and n.

  Method singleparent returns number of nodes in binary tree

Write a method singleParent, which returns number of nodes in a binary tree that have only one child.

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