Lesson 4: Data Modeling and Database Design

SevraqylAreq
timer Asked: Nov 30th, 2018

Question Description

Assignment 04

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.

Project Question

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.

Unformatted Attachment Preview

ASSIGNMENT 04 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. Project Question 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.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors