[collegegirl08]

Hi,

I am working on setting up an ER Diagram, and was wondering if someone could please tell me if I have correctly done this? I was confused with the query information and added it as an attribute.

The information worked with is:

"A local karate specialist teaches karate in her home studio. She has been teaching karate for years, and with recent surge in karate's popularity, her business has grown so much that she has hired instructors to help her offer many classes. The logistics of teaching classes and keeping records by hand has become too cumbersome. So, knowing that you know Access, she has asked you to create a database. In addition to having you create the database, she wants you to create forms, queries, and reports she can use to mange her karate business.

The karate classes have quite a loyal following, and most students sign up for classes again and again. So, the business owner wants to keep student data – for past and present students – in the database. At present, she writes student data on an index card when a student registers to take a class. On each card, she notes the student's name, address, date of birth, and gender. After some mix-ups with three students having the same last name, she has decided that each student should also have a unique ID number. She then notes on each index card whether the student has paid for the class. All this information must be captured in the database, and it must be input via a Student Registration Form to make it easy for the business owner.

The karate classes are quite varied. Some karate classes cost more than others, depending on the focus of the class and the teacher's expertise. Some classes have more weekly sessions than others. The times at which classes begin and end are staggered throughout the day and evening. All these details need to be tracked in the database. To simplify things, the business owner wants each class to have a unique ID in addition to its name. She also needs to keep track of her instructors and the class or classes that each instructor teaches.

The business owner would like you to create a number of queries. She frequently receives telephone calls from people who want to know the duration (in weeks) of a particular class. She would like to run a query so she can quickly answer that question. She also gets telephone calls from people who want to know whether they can enroll in a particular class. She has no way of knowing whether a class is filled, so she needs to be able to run a query to find out how many students are in each class. The business owner also wants to increase her class offerings, so she would like to be able to run a query that will tell her which classes are most popular.

Of course, this is a for-profit business, and the business owner needs to collect tuition. If a student does not pay for a class by the third week, the business owner tells the delinquent student that s/he is no longer enrolled. The database must mirror the business owner's actions, so she would like a query that will delete those students who have not paid their tuition and have been “dis-enrolled.”

The business owner also needs to provide her instructors with a list of students in their classes. You can create a query that will allow the business owner to type in the name of the class and see a list of students' names.

Because the business owner also keeps the books for his business, she would also like a report that lists each student's tuition charges."

You are to:
1. Begin by identifying the entities and listing their attributes.
Entity: Student
Attributes:
Student Name
Student Address
DOB
Gender
Unique ID#
Tuition Charges
Paid
Disenrollment

Entity: Class
Attributes:
Instructor Name
Unique ID#
Number of Weekly Sessions
Time of Class
Price of Class
Duration of class
Enrollment Number
Popularity
Roster


2. Develop an entity-relationship (E-R) diagram to represent the database model for the Karate Studio business.

See attachment

3. Explain shortly the relationships between the entities.

One-to-many
Student can be enrolled in one class and the class and instructors have relationships with many students.