MIS 3000- Ex 13 Implementation PDF

Preview

Summary

MIS 3000- Ex 13 Implementation...

Description

MIS 3000-020 F20 Ex 13 (Thursday, 11/12/2020 via Moodle)

Three tables have been established and populated with sample data. Table 1: Sample Raw Data in the Client Group Client Name Helen Lee John Arthur Mary Johnson Lisa Hachtel

City Rochester Auburn Hills Auburn Hills Troy

Phone 248-992-0029 313-001-9735 586-225-7736 248-210-3322

Table 2: Sample Raw Data in the Course Group Course Name Zumba Kickboxing …………

Section MW (7-9pm) TR (6-8pm)

Coach Stephanie OHora Jason Valenti

Table 3: Sample Raw Data in the Enrollment Group Client Name Helen Lee John Arthur Mary Johnson Lisa Hachtel

Course Name Zumba Kickboxing Kickboxing Kickboxing …………

Section MW (7-9pm) TR (6-8pm) TR (6-8pm) TR (6-8pm)

The input information will be saved in an MS Access database (DB) file ( MIS3000Ex13.accdb). The structure of the DB file is as follows in Tables 4-6. PK is short for the primary key and FK is short for foreign key. Table 4: Client Table Field/Attribute Name ClientName

PK

Phone City

Data Type

Length/ Format

Text

20

Text

12

clients’ phone number; entered by clients

20

selected by clients from a set of currently available cities embedded in a drop-down box

Text

Comments client name, entered by clients

Table 5: Course Table Field/Attribute Name

Data Type

Length/ Format

Comments

CourseName

PK

Text

30

course name, entered by staff members or managers

Section

PK

Text

20

section name, entered by staff members or managers

Text

30

coach’s name; entered by staff members or managers

Coach

Page: 1

MIS 3000-020 F20 Ex 13 (Thursday, 11/12/2020 via Moodle)

Table 6: Enrollment Table Field/Attribute Name

Data Type

Length/ Format

ClientName

PK, FK

Text

20

CourseName

PK, FK

Text

30

Section

PK, FK

Text

20

Comments selected by clients from a set of currently available clients embedded in a drop-down box selected by clients from a set of currently available courses embedded in a drop-down box selected by clients from a set of currently available sections embedded in a drop-down box

I. Download the Access file and upload it to Virtual lab (Apporto). Develop the Enrollment Summary query based on the following description. The output of this project will be an enrollment summary table by course and section (see Table 4). Total # of Enrollment

Table 7: Sample Summary Table Course Name Zumba Kickboxing Kickboxing …………

Section

City

MW (7-9pm) TR (6-8pm) TR (6-8pm)

Rochester Auburn Hills Troy

Total Number of Enrollment 1 2 1

Process : Count client names in the same course and section, and from the same city.

Client Name Figure 1: Decomposition Diagram

The process of generating the output table is described as follows. In the output summary table (Table 7), the Course Name and Section information is copied from the Table 2. City is copied from the Table 1. The Total # of Enrollment in the last column is derived by counting the number of Client Names registered for the same course and section, and from the same city in Table 3. An information decomposition diagram is illustrated in Figure 1. In this example, attributes Phone in the Table 1 and Coach in the Table 2 do not contribute to creating Table 7.

II. Close your database file, download it to your local computer, and then submit the file to entry Ex 13 in the Moodle on Thursday, 11/12/2020.

Page: 2...