+1 (208) 254-6996 [email protected]
  

PLEASE POST EACH ASSIGNMENT SEPARATELY

Assignment 1

Don't use plagiarized sources. Get Your Custom Essay on
NEED Data Management Assignments IN 15 HOURS Or LESS
Just from $13/Page
Order Essay

Question A: 

What is a well-structured relation? Why are well-structured relations important in logical database design? 

Question B: 

Summarize six important properties of relations. 

Support your stance by referencing sources such as the textbook, the exploration activity web site, or other internet research. Be sure to cite your source using APA format. 

Assignment 2

Question A: 

What are the major inputs into physical database design? 

Question B: 

Describe an information-level design. 

Assignment 3

Question A:
Outline the steps you would take to conduct a risk assessment for your place of employment with regards to attaching a database to a public site. 

Question B: 

List and discuss four common problems of ineffective data administration. 

Assignment 4

Question A: 

Briefly describe the major components of a data warehouse architecture. 

Question B: 

Explain the potential advantages and risks associated with distributed databases. 

Assignment 5

Review the course syllabus (ATTACHED) and reflect on what you learned in the past 8 weeks. What is the most practical and easily applied lesson you learned? What was the hardest to grasp? Why? 

Data Management

Required Text

Pratt, P. and M. Last. (2015). Concepts of Database Management, 8th ed. Boston: Cengage Learning.

ISBN: 9781285427102

Course Description

This course examines the development and administration of relational databases through the

stages of the database application life cycle, advanced topics in database administration, and

recent trends in database technologies.

Course Objectives

 Describe the database application lifecycle and identify its activities.  Describe the tools and techniques used in database design.  Identify the roles of data administrators, database administrators, and database

designers and discuss how they interact with users.  Apply the Entity-Relationship (ER) model, the Enhanced Entity-Relationship (EER)

model, and the normalization technique to database design.  Develop conceptual, logical, and physical database designs.  Identify methods for improving database performance.  Identify database security issues and describe how they can be addressed.  Describe how transaction management, concurrency control, and recovery services

maintain the consistent state of a database.  Form queries using relational algebra and relational calculus.  Describe the process of query optimization.

 Identify the concepts and issues involved with distributed databases.  Describe the issues involved in integrating databases into the Web environment and the

technologies that are involved.  Describe the importance of XML and its potential impact on database development.  Explain the basic concepts of data warehousing and data mining.

Credit Hours: 3

Prerequisites: None

Tentative Course Schedule

Course Week Weekly Content

Week 1 Introduction to Database Management

 Reading

 Lecture “Introduction to Database Management”

 Lecture “The Relational Model 1: Introduction, QBE, and Relational Algebra”

 Lecture “Database Application Lifecycle”

 Discussion “Introduction to Database Management, QBE, and Relational Algebra”

 Assignment “Introduction to Database Management, QBE, and Relational Algebra”

Week 2 Relational Model SQL

 Reading

 Lecture “What is a Query Optimization?”

 Lecture “The Relational Model 2: SQL”

 Discussion “The Relational Model: SQL”

 Assignment “The Relational Model: SQL”

Week 3 Relational Model Advanced Topics

 Reading

 Lecture “The Relational Model 3: Advanced Topics”

 Discussion “The Relational Model: Advance Topics”

 Assignment “The Relational Model: Advance Topics”

Week 4 Database Design Normalization

 Reading

 Lecture “Database Design 1: Normalization”

 Discussion “Normalization”

 Assignment “Normalization”

Week 5 Database Design Design Method

 Reading

 Lecture “Database Design 2: Design Method”

 Discussion “Design Method”

 Assignment “Design Method”

Week 6 DBMS Functions  Reading

 Lecture “Database Roles”

 Lecture “DBMS Functions”

 Lecture “Database Administration”

Course Week Weekly Content

 Discussion “DBMS Functions and Database Administration”

 Assignment “DBMS Functions and Database Administration”

Week 7 Database Administration

 Reading

 Lecture “Database Management Approaches

 Discussion “Database Management Approaches and Using Access to Create and Publish a Web Database”

 Assignment “Database Management Approaches and Using Access to Create and Publish a Web Database”

Week 8 Database Management Approaches

 Discussion “Reflection”

 Student End of Course Survey

 Assignment “Final Project”

Grading Policy

Grading Category Grade Weight

Discussions 30%

Assignments 50%

Final 20%

Week Type of Activity Activity Estimated Hours Required

1

Online

Readings/Lectures 7.0

Discussions 3.0

Assignments 0.0

Preparation

Readings 2.6

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

2

Online

Readings/Lectures 3.5

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.6

Discussions 2.0

Assignments 2.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

3 Online Readings/Lectures 3.3

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.2

Discussions 2.0

Assignments 2.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

4

Online

Readings/Lectures 2.9

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.0

Discussions 2.0

Assignments 2.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

5

Online

Readings/Lectures 4.3

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.7

Discussions 2.0

Assignments 1.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

6

Online

Readings/Lectures 6.1

Discussions 3.0

Assignments 0.0

Preparation

Readings 1.1

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

7

Online

Readings/Lectures 3.4

Discussions 3.0

Assignments 0.0

Preparation

Readings 0.8

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours

Week Type of Activity Activity Estimated Hours Required

8

Online

Readings/Lectures 0.2

Discussions 3.0

Assignments 2.0

Preparation Readings 0.0

Discussions 2.0

Assignments 3.0

Clinical/Lab Hours

Order your essay today and save 10% with the discount code ESSAYHELP