Reference no: EM13949845
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. create an IDEF1X diagram that shows 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.
|
What are the positive and negative effects
: Should cartels be allowed to exist? If they should not be allowed to exist, how can they be effectively prohibited?
|
|
Coefficient of performance of a carnot refrigeration
: The refrigerating efficiency is defined as the ratio of the cycle coefficient of performance to the coefficient of performance of a Carnot refrigeration cycle operating between thermal reservoirs at the ambient temperature and the temperature of t..
|
|
What is the cost of capital for the preferred stock
: The preferred stock of Julian Industries sells for S36 and pays $3.00 in dividends. The net price of the security after issuance costs is $32.50. What is the cost of capital for the preferred stock
|
|
Vapor-compression refrigeration system
: A vapor-compression refrigeration system, using ammonia as the working fluid, has evaporator and condenser pressures of 30 and 200 lbf/in.2, respectively. The refrigerant passes through each heat exchanger with a negligible pressure drop.
|
|
Construct a list of potential entities.
: create an IDEF1X diagram that shows only entities and relationships. Name each relationship and specify its cardinalities. Justify the cardinality decisions.
|
|
Prospect corporation, your new audit client
: (1) Sales. Salesclerks prepare sales invoices in triplicate. The original and second copy are presented to the cashier, and the third copy is retained by the salesclerk in the sales book. When the sale is for cash, the customer pays the salesclerk..
|
|
Compressor of an ideal vapor-compression
: Refrigerant 134a enters the compressor of an ideal vapor-compression refrigeration cycle as saturated vapor at 2108F. The condenser pressure is 160 lbf/in.2
|
|
Problem regarding the saturated vapor
: An ideal vapor-compression refrigeration cycle, with ammonia as the working fluid, has an evaporator temperature of 2208C and a condenser pressure of 12 bar. Saturated vapor enters the compressor, and saturated liquid exits the condenser. The mas..
|
|
Indicate the normal form of the relation
: For each of the following relations, indicate the normal form of the relation. Put each relation in the 3NF.
|