COM330 Full Course (June 2019) (No Exams)

COM 330 Database Concepts & Programming

Module 1 Discussion

Do First Discussion

You are applying for a job and the supervisor asks for the following information during the interview:

Directions:

Click on Choice 1, Choice 2, and Choice 3 buttons below.

Read the information for each of the three choices.

Decide if you would create a relational database, an object-oriented database, or multiple forms in either Excel or in tables in Word documents .

Remember, you are in an interview and you should be answering as if you were answering the interview question.

Then post on the Do First Discussion Board for Module 1 which option you would choose to track for each of the three choices and why.

Click here for the discussion guidelines and date this graded assignment is due.

CHOICE 1 Your Personal Academic Information, including:

Names, teachers, times, and room locations for each course you are taking this year

Grades for each of your classes and the individual assignments

Academic events, times, dates, and locations that are mandatory and optional to attend for each class in which you are registered

Advisor name and contact information, number of times you need to meet, and any registration information you must have for your major

Information on names, times, contact information, locations of the tutoring center, instructor hours, or online help desk info if you have a problem with academic or technical issues

CHOICE 2 Your Personal Information, including:

All social events, including the name, organization, sponsors, cost, contact information, and location

Family email, phone number, address, and birthday or special event information (anniversaries, family events, etc.)

Financial budget for all individual school costs (including but not limited to books, tuition, food, registration fees, and social events) and home expenses (including food, clothes, car insurance, medical and dental insurance, home insurance, food, electric, water, trash pickup, and travel budget). Also include the contact information for your car, medical, dental, and other places that you have to pay expenses to. Finally include the dates that any bills are due.

CHOICE 3 Significant Event Information

If you are planning a significant event, such as a wedding, graduation party, or a family member’s retirement party, determine the type of event and determine:

Guest list, contact information

Date, location, cost, and location of the venue

Budget for the event

Itemized food, supplies and any other costs for the event, amount needed for the event, and where you will get the cheapest items

List of apps or places to get discounts or coupons for the event

Way to track who is and is not attending

Permit or security information, contacts, and cost

Clothing budget

Any other pertinent information

COM 330 Database Concepts & Programming

Module 2 Discussion

You have now been called back for a second interview with the same company that interviewed you in Module 1. The supervisor interviewing you asks you to bring to the second interview the following information:

Directions:

Click on Choice 1, Choice 2, and Choice 3 buttons below.

Read the information for each of the three choices.

Create a relational database, an object-oriented database, or multiple forms in either Excel or in tables in Word documents for the choice you choose.

You are to actually create the database or forms as if you were presenting it to the person interviewing you.

Then post each database or the forms that you chose on the Do First Discussion Board for Module 2 for your peers to view and also what you learned from this Do First activity. Include any software you used, how long it took you, tutorials you used, and how long it took you to complete the information.

Click here for the discussion guidelines and date this graded assignment is due.

CHOICE 1 Your Personal Academic Information, including:

Names, teachers, times, and room locations for each course you are taking this year

Grades for each of your classes and the individual assignments

Academic events, times, dates, and locations that are mandatory and optional to attend for each class in which you are registered

Advisor name and contact information, number of times you need to meet, and any registration information you must have for your major

Information on names, times, contact information, locations of the tutoring center, instructor hours, or online help desk info if you have a problem with academic or technical issues

CHOICE 2 Your Personal Information, including:

All social events, including the name, organization, sponsors, cost, contact information, and location

Family email, phone number, address, and birthday or special event information (anniversaries, family events, etc.)

Financial budget for all individual school costs (including but not limited to books, tuition, food, registration fees, and social events), home expenses including but not limited to (food, clothes, car insurance, medical and dental insurance, home insurance, food, electric, water, trash pick-up, and travel budget) Also include the contact information for your car, medical, dental, and other places that you have to pay expenses to. Finally include the dates that any bills are due.

CHOICE 3 Significant Event Information

If you are planning a significant event, such as a wedding, graduation party, or a family member’s retirement party, determine the type of event and determine:

Guest list, contact information

Date, location, cost, and location of the venue

Budget for the event

Itemized food, supplies, and any other costs for the event, amount needed for the event, and where you will get the cheapest items

List of apps or places to get discounts or coupons for the event

Way to track who is and is not attending

Permit or security information, contacts, and cost

Clothing budget

Any other pertinent information

COM 330 Database Concepts & Programming

Module 3 Discussion

What is SQL and what jobs does it perform? Describe the basic commands and functions of SQL.

COM 330 Database Concepts & Programming

Module 4 Discussion

Why is data modeling an important tool in database design? What problems can occur if we neglect modeling? What modeling tools does our textbook discuss and how are they used effectively?

 

COM 330 Database Concepts & Programming

Module 5 Discussion

How does a data model differ from a database design and how do the two relate? What are some of the specifics of a dbms that must be taken into consideration when building a database design?

COM 330 Database Concepts & Programming

Module 6 Discussion

For this module, you are required to answer at least two discussion questions on the discussion board. You are also required to respond to at least one of your classmates’ posts.

Why would you want to remove the users of a database from the Access environment? For what reasons might you want your menu system to do away with the Access environment (in the background) altogether?

Have any of you had experience with a computer virus? Do you know how you got it? How did you “fix” it? Specifically have any of you received a virus from a macro? Why would you not want to use the highest security level in Access so that no macros are allowed?

How do the colors, text, graphics, etc., affect the user’s experience with the menu system? How could a “busy” interface become distractive to users?

COM 330 Database Concepts & Programming

Module 7 Discussion

The starter for these questions is the video you watch as the first item in the lesson. Feel free to expand on these using other resources.

Why is a data language necessary for web databases?

What issues can arise with web database design?

How secure are web databases from hackers?

COM 330 Database Concepts & Programming

Module 8 Discussion

How can Big Data help your employer or school?

Will Big Data have an impact on how you use the Internet?

What are some of the challenges of Big Data?

COM 330 Database Concepts & Programming

Module 1 Assignment

In your textbook, complete Chapter 1:

Exercises 1.37, 1.38, 1.39 (page 65)

Case Question: San Juan Sailboat Charters (page 67)

COM 330 Database Concepts & Programming

Module 2 Assignment

In your textbook, complete Chapter 2:

Exercises 2.38 and 2.40 (page 122)

COM 330 Database Concepts & Programming

Module 3 Assignment

In your textbook, complete Chapter 3:

Exercises 3.52, 3.53, 3.54, and 3.55 (page 238)

Project #1 – Garden Glory Project, answer parts A, B, C, and D (page 254-255)

COM 330 Database Concepts & Programming

Module 4 Assignment

In your textbook, complete Chapter 4:

Case Question – Highline University Mentor Program, complete only A, B, and C (page 312)

COM 330 Database Concepts & Programming

Module 5 Assignment

In your textbook, complete Chapter 5:

Exercises 5.36 and 5.37 (page 326)

Project #2 – Garden Glory Project, answer parts A, B, and C (page 360)

 

COM 330 Database Concepts & Programming

Module 6 Assignment

In your textbook, complete Chapter 6:

Case Question – Marcia’s Dry Cleaning, complete only A and B (page 417-418)

COM 330 Database Concepts & Programming

Module 7 Assignment

For this module you are to complete the following assignment:

In your textbook, complete Chapter 7:

Garden Glory Case, answer parts A, B, C, and D (page 485)

COM 330 Database Concepts & Programming

Module 8 Assignment

For this module you are to complete the following assignment:

In your textbook, complete Chapter 8:

Case Question – Marcia’s Dry Cleaning, complete only A, B, C, and D (page 537)

Incorporate in your response how this assignment incorporates the Saint Leo core value of integrity.