IT 260 (Introduction to Desktop Databases) Complete Course

 

 

IT 260 Week 1 DQs.

Describe a scenario where you might use a database rather than a file system to store data. Explain why you would choose to use a database
IT 260 Week 1 Individual Short Answer Worksheet.

Week 1 DQ 2

Why should a person developing a relational database use keys in their relational database model?

 

IT 260 Week 1 Individual Short Answer Worksheet.
IT 260 Week 2
IT 260 Week 2 Exercise Database Design Document Part 1 Introduction.
IT 260 Week 2 Individual Assignment Toolwire LiveLab.

IT 260 Week 3 DQs.

 

Week 3 DQ 1

How would you use an Entity Relationship Diagram (ERD) as a part of the design of a database application? Do you think it is necessary to utilize the ERD in the process of designing all types of database applications?

 

Week 3 DQ 2

Why is it so important to choose the correct Data Type for each field in the database? What kinds of problems could choosing an incorrect Data Type cause?
IT 260 Week 3 Exercise Database Design Document Part 2 Database Design.

 

IT 260 Week 4

IT 260 Week 4 Individual Assignment Toolwire.
IT 260 Week 4 Exercise Create Tables and Relationships for Final Project.
IT 260 Week 4 Exercise Database Design Document Part 3 Relationships Components Features and Requirements.

IT 260 Week 5 DQs.

 

Week 5 DQ 1

Discuss some ways that data might be filtered using a query to aid in making decisions. Explain your answer.

 

Week 5 DQ 2

Identify and describe two scenarios where you might use a form in a database application. Explain why you would use a form in these examples.
IT 260 Week 5 Exercise Database Design Document Part 4 Queries and Forms.

IT 260 Week 5 Individual Assignment Toolwire LiveLab.

 

IT 260 Week 6

IT 260 Week 6 Exercise Create Forms Menus and Queries for Final Project.
IT 260 Week 6 Individual Assignment Toolwire LiveLab.

IT 260 Week 7 DQs.

 

Week 7 DQ 1

Identify and discuss the steps you would take to test a database application.

Week 7 DQ 2

Discuss the importance of planning the implementation of a database application. What are some of the pitfalls of not planning for the implementation of a database application?
IT 260 Week 7 Exercise Database Design Document Part 5 Testing and Implementation Plan.
IT 260 Week 7 Individual Short Answer Worksheet.

IT 260 Week 8 ExerciseDatabase Design Document Part 6 File Maintenance and Storage Plan.
IT 260 Week 8 Individual Short Answer Worksheet.

IT 260 Week 9 capstone DQ.
IT 260 Week 9 Final Project Database Application Design Document and Presentation.