Expert Answers

CIS 105: 3.4 If Functions Practice Problem

Chapter 8 Quiz 

Due Oct 27 at 11:59pm

Score for this attempt: 10 out of 10

Question 1

1 / 1 pts

Prejudice against people based solely on age is called:Correct!

•   ageism
•   gerontologism
•   elder abuse 
•   baby boomer phobia

Question 2

1 / 1 pts

What role does the ombudsman play within elderly care?

•   Advocates for active euthanasia
•   Advocates for passive euthanasiaorrect!
•   Advocates for residents of nursing homes, board and care comes and assisted living facilities  
•   Advocates for advanced directives 

Question 3

1 / 1 pts

Which of the following is NOT true of caregivers of people who are older?

•   The average age of caregivers is 49.
•   Caregiving can have a negative effect on the caregiver's financial well-being.Correct!
•   Caregivers do not need to be encouraged to seek resources for themselves, as they do this well. Caregivers can suffer emotionally from caregiving.

Question 4

1 / 1 pts

The oldest-old or frail older people (85 and over) are projected to be the fastest-growing segment of the population in the 21^st century.

Correct!

•   True 
•   False

Question 5

1 / 1 pts

Medicare is needs-based health insurance for individuals whoes income and assets fall below a set amount 

•   TrueCorrect!
•   False

Question 6

1 / 1 pts

What is the basic health insurance program for all people 65 and over??

•   Medicaid
•   SSICorrect!
•   Medicare 
•   Social Security 

Question 7

1 / 1 pts

Approximately 3.7 million grandparents have primary responsibility for their grandchildren

•   True orrect!
•   False

Question 8

1 / 1 pts

Gerontology is the study of

•   social securityorrect!
•   the biological, psychological, and social aspects of aging. 
•   mental health.
•   medical needs.

Question 9

1 / 1 pts

Diverse communities have strengths that can be an asset to social workers to assist clients.orrect!

•   True 
•   False

Question 10

1 / 1 pts

Indigenous older people are the group most likely to utilize existing government services.

•   True Correct!
•   False

CIS 105: Quiz 3

Submission Score:    100 / 100 (100%)
Grade Time:    Oct 24 
Submitted On:    Oct 24 

· Which type of memory helps decrease the time it takes to access memory?

FEEDBACK

10 / 10  (100.0%)

·  What is the dominant OS in the operating system market?

FEEDBACK

10 / 10  (100.0%)

·  Who developed the earliest Mac OS?

FEEDBACK

10 / 10  (100.0%)

·  Transmission Control Protocol/Internet Protocol (TCP/IP)

FEEDBACK

10 / 10  (100.0%)

·  Who is authorized to modify Linux?

FEEDBACK

10 / 10  (100.0%)

·  Which operating system is open source?

FEEDBACK

10 / 10  (100.0%)

·  Defragmentation

FEEDBACK

10 / 10  (100.0%)

·  What is the set of rules to move data from one computer to another over a network?

FEEDBACK

10 / 10  (100.0%)

·  Which operating system is free of cost?

FEEDBACK

10 / 10  (100.0%)

·  Process

FEEDBACK

10 / 10  (100.0%)

CIS 105: Quiz 2

Submission Score:    100 / 100 (100%)
Grade Time:    Oct 24 
Submitted On:    Oct 24 

CIS 105: Quiz 1

Submitted Oct 24 

Submission Score: 100 / 100 (100%) 

· People that use computers are called ________.

FEEDBACK

10 / 10  (100.0%)

·  Gordon Moore made which of the following observations?

FEEDBACK

10 / 10  (100.0%)

·  Which of the following is a major difference between application software and system software?

FEEDBACK

10 / 10  (100.0%)

·  Which of the following is NOT an example of a paradigm shift?

FEEDBACK

10 / 10  (100.0%)

·  Which of the following is a component of IT?

FEEDBACK

10 / 10  (100.0%)

·  Attitude

FEEDBACK

10 / 10  (100.0%)

·  Competency

FEEDBACK

10 / 10  (100.0%)

·  Best practice

FEEDBACK

10 / 10  (100.0%)

·  What is the function of the Sarbanes-Oxley Act of 2002?

FEEDBACK

10 / 10  (100.0%)

·  A computer network consists of which of the following?

FEEDBACK

10 / 10  (100.0%)

CIS 365 – Business Database Systems
HW8 – Basic SQL DML (100 points)

This is an individual exercise, NOT a group assignment.

1. Based on the same table definition of Condo, create two new tables, New_Condo_A and New_Condo_B, by using the SELECT * INTO statement with zero row. Provide screen shots of your select into statements and the newly created tables with zero row. A similar example is in your W7 slide. (10 points)

2. Use INSERT INTO statement to populate New_Condo_A with building A records in Condo. Likewise, use another INSERT INTO statement to populate New_Condo_B with building B records in Condo. Screen shot your insert into statements, and select statements to display all newly inserted records in New_Condo_A and New_Condo_B. A similar example is in your W7 slide. (10 points)

[Note: INSERT INTO in Q2 is different from the SELECT * INTO in Q1.

Q1 creates two new empty tables; Q2 inserts records into the newly created tables.]

You should have 15 rows in New_Condo_A, 9 rows in New_Condo_B

3. Update records in New_Condo_A by adding 15% to the weeklyfee for all 3 bedrooms condos.

Display these three updated records. (10 points)

Only 3 condos in New_Condo_A have 3 bedrooms, so these 3 need to be updated.

4. Based on the result of Q3, delete records in New_Condo_A having the weeklyfee less than the average weeklyfee. Display all records left in New_Condo_A. (10 points)

Two ways to complete this question
a. Use two separate queries: 1) get the average fee first, 2) delete condos < the average fee
b. Use one query to delete condos < the average. You will get extra 5 points.

6 rows less than the average will get deleted based on the requirement
After 6 rows are deleted, New_Condo_A has the following 9 rows left.

5. Use the FamCation CONDO table to answer this question. Show all the condos in building A that costs more than $800 per week. Display Condo ID, Building Number, and Weekly Fee. List the most expensive condo first. Change the column name of WeeklyFee to ‘Expensive A Condos’. (15 points)
9 records in query result

6. Show all the reservations made in 2017 with an activity ID starting with ‘HB’ that were not led by guide
RH01 or MR01 (15 points).
7 records in query result

1. Display the most number of years, the least number of years, and the average number of years FamCation Resort employees have been with the company? Label the columns as ‘Most Years’, ‘Least Years’, and ‘Average Years’.
To standardize the answer, exclude the 5 ‘salary’ employees from the select statement as students might enter different hire dates for these employees. If you reload your database with the solution scripts, salary employees are already excluded. (15 points)

2. Increase the average PPP by 8% for all activities in the select statement, and display the increased average PPP in two columns. The first column shows the result with two significant digits, and the second column shows a rounded full integer. Label these two columns, Avg PPP in Decimal and Avg PPP in Integer, respectively. (15 points)
Avg PPP in Decimal = 18.90
Avg PPP in Integer = 19

Due Date: EOD Wednesday 10/20

• Take a screenshot of your query statement and result in MS SQL. Paste all queries/results in your Word doc.

• Convert the entire document into one pdf file for submission.

• Save your file name as HW8-Student Name.pdf.

• Submissions must be posted to Canvas to be graded.

CIS 365 – Business Database Systems
W7 – Create FamCation Resort Database Tables (150 points)
This is an individual exercise, NOT a group assignment.

• Download FamCation table schema on Canvas in the Assignment folder
• Download FamCation record insert scripts on Canvas in the Assignment folder

Q1. Create FamCation Resort DB tables using GUI (20 points)
Use GUI (graphical user interface) to create CONDO, ACTIVITY, GUEST, and FAMILY tables based on the provided table schema.
Right mouse click Table, select New/Table

Q1.1 Provide a screen shot of each table you created along with the primary key, example below.

Q2. Create the rest of the tables, PERSONNEL, HOUSEKEEPING, GUIDE, CLEANING, BOOKING, RESERVATION by writing the query statement from scratch or using the insert snippet template.
Remove InvoiceID from the RESERVATION table. You don't need to create the INVOICE table. (60 points)
• The order of table creation is very important due to referential integrity!
• You can copy and paste scripts into or from SSMS.
• Remember to SAVE YOUR SCRIPTS
Q2.1 Provide a screen shot of each create table script in SSMS, example below

Q2.2 Provide a listing of all the tables you created. Example below.

View Object Explorer Details – before you insert any records, all the row counts are zero.
Q3. Insert data records to all the tables created in Q1 and Q2 by using the instructor provided scripts on Canvas. (Your table definitions in Q1 need to match the instructor provided table schema on Canvas, e.g., same data type and column position, for the insert statements to work!). (45 points)
Steps -
• Copy and paste the instructor provided scripts from the Word doc to the SSMS window editor. Execute the insert queries.
• After all records are inserted, review the SSMS message. During the insertion processing, three records could not be successfully loaded due to constraint violations.
Q3.1 Screen shot the error message where the violation occurred. Research the errors and explain the cause of the violations. You don't need to fix the data errors. Example below. (3x5 = 15 points)
Cleaning Table - referential integrity violation. 'something' is not defined 'somewhere'.
Q3.2 Take a screen shot similar to the following and match your record counts to the screen below. The row counts don't include the three problem records in Q3.1. (3x10 = 30 points)

Q4. Write your own script to insert 5 more 'salary' employees who are neither housekeepers nor guides to the PERSONNEL table. Enter your own name as the manager of the other four new employees. (25 points)

Q4.1 Screen shot your insert scripts for these 5 employees (15 points)
Q4.2 Screen shot your select query to display these 5 employees similar to the following. (10 points: select query 5 points, result 5 points)
Due Date: EOD Monday 10/11
• All your screenshots need to include your ASU ID on the top. Example below.
• Convert the entire document into one pdf file for submission.
• Save your file name as HW7-Student Name.pdf.
• Submissions must be posted to Canvas to be graded

CIS 365 – Business Database Systems
HW5 – Normalization (70 points)

This is an individual exercise, NOT a group assignment.
HW5-1: Explore data in the following table (60 points)

Assume that the primary key of this relation consists of two components: author ID (AID) and book number (BNbr). Each author has an ID, last name, first name, and teaching institute. Each book has a number, name, price, and publisher which has an ID, name, city, and state. In addition, this table shows an individual author’s royalty amount for each book in the case of multi-authored books. Some books written by different authors might have the same name, i.e., BookName can't uniquely identify a book.
Questions:
1. Identify the normal form in which the relation currently is. (5 points)

2. Identify the determinants and functional dependencies between the attributes. (25 points)
Example:
ADCmgpID ? ADCmpgName, StartDate, Duration, CmpgMgrID, CmpgMgrName (Partial)
CmpgMgrID ? CmpgMgrName (Transitive)
ModusID ? Media, Range (Partial)
ADCmpgID, ModusID ? BudgetPctg (Full)

3. After multi-valued attributes are transformed to store atomic values in the table, identify insert, update, and delete anomalies in the table. (12 points)
Insertion: problem description
Update: problem description
Deletion: problem description

4. Show the final result of the 3NF tables with primary key in each (bold and underlined), foreign key (dotted line for transitive dependency), a pointer from a foreign key to its primary key ?, and the rest of the attributes. (18 points)
Example:

HW5-2: (10 points)
Copy your HW4 solutions for the Housekeeping and Invoice tables and paste them in HW5 here.
If they are in 3NF, state that they are in 3NF and no further work required for this question. If they are not, transform them to 3NF and show your table result.

Due Date: EOD Monday 
• Combine your answers for HW5-1, HW5-2, and HW5-3 into one pdf file for submission.
• Save your file name as HW5-Student Name.pdf.
• Submissions must be posted to Canvas to be graded.

CIS 365 – Business Database Systems
HW3 – FamCation Resort EERD

• Include all necessary entities, attribute identifier(s), attributes, relationship cardinalities, and constraints.
• Identifiers will be bold and underlined.
• Use curly, square, or round brackets around attributes where appropriate.
• Resolve any M:N associative relationship (i.e., create associative entity).
• Define supertype and subtype entities by indicating their partial/complete overlapping or disjoint relationship, and discriminator.
• Hint: there are 11 entities in total
Read the FamCation Resort business scenario and create an EERD diagram.
FAMCation Resort is a luxury family friendly resort. This 180-acre property includes 250 condos, 3 restaurants, 2 fitness centers, and 4 conference rooms. Swimming pools, tennis courts, and golf courses are open to members during their stays. Being close to many mountains and rivers, FamCation is famous for its guided family sports activities including hiking, mountain biking, horseback riding, and rafting.
The recent growth of the resort business has led to the increase of room bookings, activity reservations, and staffing. The resort has been using an antiquated and poorly designed database system which is suffering from its slow performance and frequent downtime. With approval from the management team, the resort technology support team has been given the budget to redesign and upgrade its database system.
The technology team interviewed the management team and relevant staff members to gather business requirements and design rules for the database. These design rules are listed below:
Resort Employee
• This database keeps track of full-time employees (such as managers and technology support) and two types of temporary employees: guides and housekeeping. Each employee has a Personnel ID (PersonID), name (last name, middle name, first name), contact phone number, hire date, his/her manager’s ID. A guide can’t be a housekeeper, and vice versa.
• Guides must be certified every two years to lead the group. Each guide has an employee ID (GuideID), certified date, and renewal date. The database also records the guide’s certificate level (level1, level2, and level3),
• Each condo is assigned to a housekeeper for cleaning, and each housekeeper is assigned to clean multiple condos; for example, Sarah is assigned to clean condo 2, 4, 7, 9, and 14. When the housekeeper completes the task, he/she needs to record the employee ID, condo number, and the completion date for payroll purpose.
Condo
• Similar to a hotel room, each condo has a unique number (CondoID). The database table also includes the building number, unit number, square footage, the number of bedrooms, the number of bathrooms, and weekly fee.
• During low season, not all condos are occupied.
Guests
• The resort keeps the last name, first name, address, and spouse’s first name of the guest who checked in. Each guest is given a unique VIP membership number (GuestID). The resort also keeps the first name, relationship, birth date, and age of the guest’s family members for birthday surprises. (Assuming no two family members have the same first name)
• Due to its high-quality of service, most of the guests are frequent visitors.
• The resort also allows guests without family members to join the membership.
Guest staying at the condos - Booking
• Guests pay for a full week, even if they stay only a few days (condo weekly fee). A one-week stay always starts on a Saturday (check-in) and ends the following Saturday. For example, a 17-day stay will be charged for 3 weeks.
• The Condo Stay Booking records the booking number (BookID), condo ID, guest ID, start date, and end date. Total booking amount is calculated during the invoicing process.
Activities and Reservations
• The resort provides many guided activities for members to enjoy. These activities require a reservation to assign a date and a guide for the tour.
• Activities requiring a reservation are stored in the database with a unique ID (ActID) along with description, number of hours, price per person (PPP), and type (hiking, horseback riding, etc.).
• A guest can reserve many different family activities or none during the stay. Each reservation is given a unique ID (ResID) for billing purpose. The reservation also records the guest ID, activity ID, guide ID, reserved date, number of people in the party, and the total cost. Each reservation requires one and only one guide to lead the group. Because the activity fee is charged per person, the total cost for each reservation is PPP x number of people in the party.
Billing Invoice:
To expedite the check-out process for a better customer experience, the resort pre-calculates the final billing invoice by adding the fees for the stay and the activities if any for guest confirmation in advance. The billing invoice prints out the invoice number (InvoiceID), invoice date, booking ID, condo ID, guest ID, guest name (first and last), start date, end date, condo fee, activity fee, invoice total, sales tax, and grand total. The resort local sales tax rate is 9%.
Due Date: EOD Thursday 9/9/21
• Draw your EERDs by using Diagrams.net
• Your drawing needs to fit into one page.
• Submit your EERDs in one .pdf file.
• Save your file name as HW3-Student Name.pdf
• Submissions must be posted to Canvas to be graded.
THIS CONTENT IS PROTECTED AND MAY NOT BE SHARED, UPLOADED, SOLD, OR DISTRIBUTED

CIS 365 – Business Database Systems
HW2.2 – ERDs (45 points)

This is an individual exercise, NOT a group assignment.
• Only include necessary attributes specified in the business rules.
• Identifiers will be bold and underlined.
• Resolve any M:N relationship and show the after/final diagram.
• You will need to use unary, binary, and ternary degrees in this homework.

1. A bridal shop helps brides and grooms plan for their wedding. Keep track of the social security numbers, the names of the brides and grooms, along with their wedding dates and locations. To simplify the design, a separate Wedding entity is not needed. (5 points)

2. A book club has many members who meet every month to share their thinking and ideas about the book they read each month. They rotate the meeting host and location every month. Keep track of the member's names, contact info, book title, author, along with the monthly meeting date, meeting host and location. (10 points)

3. In a university, a student needs to register at least one course. A course needs to be taken by at least one student. The student record tracks each student's ID, name, and contact info. Each course has its course ID and title. The registration record has the registration ID, semester, schedule, and class room. Each course is assigned to only one professor, but each professor needs to teach at least one course. The DB tracks the professor's ID and name. (15 points)

4. A laboratory has several chemists who are assigned to work on one or more projects. Chemists may also use certain kinds of equipment on each project. Data tracked for the chemist includes employee ID, name, email. Equipment info includes a serial number, date acquired by the lab, and cost. Project information tracked for a project include ID, category, and start date. When a piece of equipment is assigned to a chemist working on a specific project, the assignment date is recorded. A chemist must be assigned to at least one project and one equipment item. A given piece of equipment need not be assigned and a given project need not be assigned either a chemist or an equipment item. Given these business rules, draw the ERD and answer the next set of questions. (15 points)