K11L Assignment 04 (1)
Get perfect grades by consistently using www.customizedassignments.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20
Order a Similar Paper Order a Different Paper
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
K11 Database Processing
Directions:Be sure to make an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to use correct English spelling and grammar. Sources must be cited in APA format. Your response should be four (4) pages in length; refer to the “Assignment Format” page for specific format requirements.
Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to use correct English, spelling and grammar. Sources must be cited in APA format. Refer to the “Assignment Format” page located on the Course Home page for specific format requirements.
4.45 Consider the tables:
PT_SESSION (Trainer, Phone, Email, Fee, ClientLastName, ClientFirstName, ClientPhone, ClientEmail, Date, Time)
CLUB_MEMBERSHIP (ClientNumber, ClientLastName, ClientFirstName, ClientPhone, ClientEmail, MembershipType, EndingDate, Street, City, State, Zip)
CLASS (ClassName, Trainer, StartDate, EndDate, Time, DayOfWeek, Cost)
Recommend a design for a read-only database that would support the following needs:
A. Enable trainers to ensure that their clients are members of the club.
B. Enable the club to assess the popularity of various trainers. There are two parts to this – client sessions and class enrollees. This will require two tables.
C. Enable the trainers to determine if they are assisting the same client.
D. Enable class instructors to determine if the attendees to their classes have paid.