Creating an idef1x diagram

Assignment Help Data Structure & Algorithms

Reference no: EM1380296

The Jefferson Dance Club teaches social dancing and offers both private and group lessons. Jefferson charges $45 per hour per student (or couple) for a private lesson and charges $6 per hour per student for a group lesson. Private lessons are offered six days per week (from noon until 10 p.m.). Group lessons are offered in the evenings. Jefferson employs two types of instructors: full-time salaried instructors and part-time instructors. The full-time instructors are paid a fixed amount per week, and the part-time instructors are paid either a set amount for an evening or a set amount for teaching a particular class.

In addition to the lessons, Jefferson sponsors two weekly social dances featuring recorded music. The admission charge is $5 per person. The Friday night dance is the more popular and averages around 80 people; the Sunday night dance attracts about 30 attendees. The purpose of the dances is to give the students a place in which to practice their skills. No food or drinks are served.

Jefferson wants to develop an information system to keep track of students and the classes they have taken. Jefferson?s managers also want to know how many and which types of lessons each teacher has taught and to compute the average revenue generated per lesson for each of their instructors.

The problem is to construct a database for them. To do this, a data model must be created. A Trial model must be created.

A. construct a list of potential entities.
B. Construct an IDEF1X diagram that demonstrate only entities and relationships. Name each relationship and specify its cardinalities. Justify the cardinality decisions.
C. make a list of questions that will need to be asked in order to create an accurate data model.

Reference no: EM1380296

Questions Cloud

Question about data model : Create a simple data model that outlines a database management system. This model requires to track people's participation in several fitness activities at a fitness center.

Normalized relations for a database : Suppose that a information communications network links a computer at corporate headquarters with a computer in each retail outlet. The chain includes fifty stores with an average of 75 workers per store.

Fire in a bangladesh garment factory : CASE STUDY - FIRE IN A BANGLADESH GARMENT FACTORY -What would you advise your staff to do when faced with local expectations of "payoffs" and bribery?

Creating a single table to hold the information : Think about a typical sales invoice that would include the given information. Create a single table to hold all of the information needed to store an invoice including this information.

Creating an idef1x diagram : Construct an IDEF1X diagram that demonstrate only entities and relationships. Name each relationship and specify its cardinalities.

Detailed strategies to recruit : What are the qualifications of a trained Mechanical Engineer and what selection methods are best to assess whether or not an applicant meets or exceeds those qualifications

Create an idef1x entity relationships diagram : The Metropolitan Housing Agency is a non profit corporation that advocates the development and improvement of low income housing.

Separate inventory database : A 20-year old corporation, SewWorld, comprised of 6-locations in three states, sells sewing machines, sewing related software, and accessories. Each store sells between 3-5 different brands of sewing equipments.

Inventory tracking database : Construct a relational database of your choice. The DB should contain no more than six tables. Define three business requirements that this database will provide.

User Account

All Pages